SQL Performance Management

100 Times Faster: Experiences Making SQL Server Fly Download the presentation: 100-times-faster-experiences-making-sql-server-fly-sql-saturday-prov-2015-12-12
How do you go about making a program run a lot faster!  Like 100 times faster?   It’s difficult.  Microsoft tried in the Hekaton project, its in-memory tables …

Natively Compiled T-SQL: The Fastest SQL Ever! Download the Presentation .Natively-Compiled-T-SQL-Andrew-Novck-presentation
Demo files: Natively-Compiled-T-SQL-Andrew-Novck-demo-sql
SQL Server’s In-Memory tables are accompanied by Natively Compiled Stored Procedures and Functions that run at amazing speed.  However, the speed boost comes with tradeoffs.
The …

SQL Storage Management

SQL Server Performace on Solid State Drives (SSD) Solid State Disks (SSDs) are devices that take advantage of the high speed nature of flash memory chips to provide fast persistent data storage

sp_storage: A proc to manage disk space in SQL Server sp_storage is a procedure that I wrote to help me manage available disk space on a SQL Server

SQL Coding Techniques

100 Times Faster: Experiences Making SQL Server Fly Download the presentation: 100-times-faster-experiences-making-sql-server-fly-sql-saturday-prov-2015-12-12
How do you go about making a program run a lot faster!  Like 100 times faster?   It’s difficult.  Microsoft tried in the Hekaton project, its in-memory tables …

Entity-Attribute-Value (EAV): The Antipattern to Great to Give Up Download the presentation: entity-attribute-value-eav-the-antipattern-too-great-to-give-up-andy-novick
The Entity-Attribute-Value (EAV) is a design pattern for relational databases that uses an extreme form of normalization to achieve flexibility and the ability to efficiently store temporal …

SQL Security