All About SQL

UPDATE November 2016 – With SQL Server 2016 SP1, Microsoft will include key enterprise-class features in every edition of SQL Server...

2016-07-27

520 reads

SQLskills Training

by Arun Sirpal

All About SQL

Well I finally accomplished a goal of mine– that being to complete the training for SQL Server Performance Tuning and...

2016-07-12

178 reads

Azure SQL Database scripts

by Arun Sirpal

All About SQL

I thought that this would be useful for others – couple of scripts that I have been using in Azure for...

2016-07-01

179 reads

sys.dm_db_wait_stats DMV

by Arun Sirpal

All About SQL

Come on guys, lets “UP- vote” this suggestion for the actual SQL Server product – even the “Scary DBA” likes the...

2016-06-02

185 reads

PowerShell – Deleting those files

by Arun Sirpal

All About SQL

Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...

2016-06-01

157 reads

Wait Types and Latch Classes Library

by Arun Sirpal

All About SQL

Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...

2016-05-10

264 reads