All About SQL

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

182 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

194 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

158 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

265 reads

Symbols

• by Arun Sirpal

• All About SQL

I just want to write the setup I went through for using debug symbols within SQL Server to resolve call...

2016-04-20

216 reads

Community work

• by Arun Sirpal

• All About SQL

I have been really busy lately with articles, podcasts and so forth. Lately I have been working on 2 public...

2016-04-16

142 reads

SQL Bite-Size Podcasts are live!

• by Arun Sirpal

• All About SQL

Well, after many late nights I have finally produced a set of podcasts – Bite size style – therefore called SQL Bite...

2016-03-27

252 reads

SQL Server Podcasts

• by Arun Sirpal

• All About SQL

Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...

2016-03-23

384 reads

SQL Server articles

• by Arun Sirpal

• All About SQL

Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...

2016-03-16

173 reads

An Extended Event script

• by Arun Sirpal

• All About SQL

I have been enjoying XE alot recently ( from following SQLSKILLS) so I decided to write something that I used recently...

2015-05-22

143 reads