All About SQL

This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal,...

2017-01-25

611 reads

Using Extended Events Telemetry Session

by Arun Sirpal

All About SQL

You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...

2017-01-23

1,916 reads

MVPs

by Arun Sirpal

All About SQL

I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program...

2017-01-20

661 reads

SQL database built-in intelligence

by Arun Sirpal

All About SQL

I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in...

2017-01-18

504 reads

Looking at wait stats differently with SQL 2016

by Arun Sirpal

All About SQL

Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on sys.dm_os_wait_stats...

2017-01-16

628 reads

Checking Time Zones in SQL Server

by Arun Sirpal

All About SQL

I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...

2017-01-13

1,324 reads

I used to shrink my databases!

by Arun Sirpal

All About SQL

This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...

2017-01-11

820 reads

SQL Server Bugs & Enhancement Requests

by Arun Sirpal

All About SQL

T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out...

2017-01-10

633 reads