SQL Performance Management

SQL Server In-Memory Tables SQL Server In-Memory Tables(Hekaton) Andy Novick April 2015
SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them.  In-Memory …

Video – Improving SQL Server Performance by writing faster T-SQL Code- Sept 11, 2014 This webinar is now available for viewing online at any time. (About 60 Minutes)
http://www.mssqltips.com/sql-server-video/332/proving-sql-server-performance-by-writing-faster-tsql-code/
Some of the concepts we will cover include:

Ways to find code that’s slow:

DMV’s like sys.dm_exec_procedure
SQL Profiler and …

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

Writing Faster T-SQL Stored Procedures and Functions: Lessons Learned Stored procedures and functions are the mainstay of SQL Server coding. This presentation will show techniques to improve their performance.

Formatting a Datetime for use in a File Name I’ve been working with scripting SQL traces over the last few weeks. To minimize the overhead of the trace, it can be sent to a file instead of the SQL …

SQL Security