SQL Performance Management

In-Memory Tables with Natively Compiled T-SQL: Blazing Speed for OLTP and More in-memory-tables-with-natively-compiled-t-sql-blazing-speed-for-oltp-and-more
The SQL Server 2014 and 2016 Hekaton project brings us In-Memory tables and Natively Compiled T-SQL objects that run at amazing speed.  What you can accomplish is astounding. This presentation …

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 …

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

In-Memory Tables with Natively Compiled T-SQL: Blazing Speed for OLTP and More in-memory-tables-with-natively-compiled-t-sql-blazing-speed-for-oltp-and-more
The SQL Server 2014 and 2016 Hekaton project brings us In-Memory tables and Natively Compiled T-SQL objects that run at amazing speed.  What you can accomplish is astounding. This presentation …

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 …

SQL Security