-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

All About SQL

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

Archives: January 2017

Interactive query experience for SQL databases

This is a new feature where you can issue TSQL commands via a TSQL editor straight from the Azure portal, why this is great is because sometimes you do not want to keep switching between your SSMS (SQL Server Management … Continue reading

Read more

1 comments, 394 reads

Posted in All About SQL on 25 January 2017

Using Extended Events Telemetry Session

You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session known as telemetry_xevents that is shipped with SQL Server 2016. This is not the same as the system_health session that … Continue reading

Read more

1 comments, 492 reads

Posted in All About SQL on 23 January 2017

MVPs

I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program and they asked me (being the one that works with Microsoft technology) what Microsoft’s equivalent was, to which I answered … Continue reading

Read more

1 comments, 428 reads

Posted in All About SQL on 20 January 2017

SQL database built-in intelligence

I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in Azure. SQL database has built-in intelligence and with that intelligence it may recommend an elastic pool setup if it’s more … Continue reading

Read more

1 comments, 320 reads

Posted in All About SQL on 18 January 2017

Looking at wait stats differently with SQL 2016

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 and/or sys.dm_os_waiting_tasks. Did you know from SQL 2016 you have the ability to work with wait stats at a session … Continue reading

Read more

3 comments, 427 reads

Posted in All About SQL on 16 January 2017

Checking Time Zones in SQL Server

I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself as I found a way to get a time based on a geographic region. This new feature is available to … Continue reading

Read more

1 comments, 1,005 reads

Posted in All About SQL on 13 January 2017

I used to shrink my databases!

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” days. My post takes me back 11 years and while it is nothing ground breaking I still  want to convey … Continue reading

Read more

1 comments, 620 reads

Posted in All About SQL on 11 January 2017

SQL Server Bugs & Enhancement Requests

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 on this one because I want to mention a connect item that I logged last year which is still … Continue reading

Read more

1 comments, 399 reads

Posted in All About SQL on 10 January 2017

Clearing Plan Cache in SQL Database (Azure)

Sometimes when in a testing mode I do like to clear cache within my SQL database (Azure). Nowadays a lot of my test databases are Azure based so how I clear cache is different to how I would do it with an older “earthed” SQL Server.

Looking at my locally… Read more

1 comments, 307 reads

Posted in All About SQL on 5 January 2017

Checking DBCC CHECKDB

I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to. For this post I want to show you how you can check whether or not CHECKDB has been successfully executed. … Continue reading

Read more

1 comments, 352 reads

Posted in All About SQL on 3 January 2017