-->
SQL Clone
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: September 2016

My application to Microsoft

I have been eager to write this blog post for a while now. I want to share my experience of the process that I went through (last year) when I applied to Microsoft for a SQL PFE (Premier Field Engineer) … Continue reading

Read more

10 comments, 463 reads

Posted in All About SQL on 29 September 2016

SSMS 2016& Azure SQL DBs

When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that I noticed when you are connected to an Azure (logical) SQL Server. So below I have 2 screen shots – … Continue reading

Read more

0 comments, 1,287 reads

Posted in All About SQL on 27 September 2016

Azure SQL Data warehouse

For this blog post I want to show you the steps required to setup an Azure SQL Data warehouse and how to connect to it via Power BI to allow for advanced reporting. Please note that this is not a … Continue reading

Read more

1 comments, 339 reads

Posted in All About SQL on 21 September 2016

SSMS Keeps Crashing

It is quite frustrating when SSMS (SQL Server Management Studio) randomly crashes, all too often for my liking. If you have the following screen shot then read on. Digging into the event logs I noticed the following error: Faulting application name: Ssms.exe, … Continue reading

Read more

3 comments, 492 reads

Posted in All About SQL on 20 September 2016

Azure IaaS Premium Storage Test

I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will have SQL Server installed. I will then show a comparison of the same test on my local (average) machine. DiskSpd … Continue reading

Read more

2 comments, 363 reads

Posted in All About SQL on 19 September 2016

Restoring Azure SQL Database

A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering to a point in time is straightforward. With all editions of the database full backups are taken every week, … Continue reading

Read more

1 comments, 998 reads

Posted in All About SQL on 16 September 2016

More PowerShell for the Azure World

The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use the following quite frequently and I am sure they will be useful to others too. Scaling You can scale … Continue reading

Read more

0 comments, 342 reads

Posted in All About SQL on 15 September 2016

PowerShell to create Azure SQL DBs

Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So I decided to find a scripted approach via PowerShell where I could just change some parameters and hit enter. I … Continue reading

Read more

1 comments, 343 reads

Posted in All About SQL on 14 September 2016

DBCC CHECKFILEGROUP

Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to talk about another strategy that you could use to manage CHECKDB on your TB sized databases – something that I … Continue reading

Read more

0 comments, 1,029 reads

Posted in All About SQL on 13 September 2016

Query Performance Insight

It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a good job with the User Interaction and with the information provided – even though I would have liked to see … Continue reading

Read more

3 comments, 412 reads

Posted in All About SQL on 12 September 2016

DBCC HELP

I was going through some online courses and came across Erin Stellato’s Course on DBCC commands.http://www.sqlskills.com/blogs/paul/new-course-understanding-and-using-dbcc-commands/ I learnt something new! It’s not that complicated but I have found it useful. It is called DBCC HELP. The command returns syntax information … Continue reading

Read more

0 comments, 389 reads

Posted in All About SQL on 9 September 2016

CHECKDB is slow!

Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower than usual timings. I started to dig into wait stats. OLEDB I expected as that is what is used by … Continue reading

Read more

1 comments, 247 reads

Posted in All About SQL on 1 September 2016