-->
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: October 2016

SSMS 2016 Bug

I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to manage compression you couldn’t as it is greyed out. Microsoft SQL Server Management Studio 13.0.15900.1 The actual message that you … Continue reading

Read more

1 comments, 355 reads

Posted in All About SQL on 27 October 2016

More bytes for Row versioning

I like row versioning– see this link for more details: https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx If your database is enabled for one of the isolation levels that uses row versioning and a row is updated it will have 14 bytes added to it. Before … Continue reading

Read more

3 comments, 209 reads

Posted in All About SQL on 26 October 2016

Azure App Service Companion for iOS

This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt like blogging about it. I saw an announcement recently and I was intrigued by it. All my excitement was over … Continue reading

Read more

3 comments, 284 reads

Posted in All About SQL on 25 October 2016

Another way to move SQL DB to Azure

About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database to Azure using a BACPAC import. If you look at the following diagram I will now show you the … Continue reading

Read more

1 comments, 285 reads

Posted in All About SQL on 20 October 2016

Azure SQL Database DMVs

The following DMVs shown within this blog post are some of the more common ones that I am finding really useful within the Azure world, hopefully I am not the only one. Sys.geo_replication_links This query will return primary and secondary … Continue reading

Read more

3 comments, 269 reads

Posted in All About SQL on 18 October 2016

The dark side of Fn_dump_dblog

I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are consistently dumping the contents into a table for analysis) The below 2 queries shows the current state of my system … Continue reading

Read more

2 comments, 1,130 reads

Posted in All About SQL on 17 October 2016

Microsoft Certifications

Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place regarding certification within the Data Platform space. (Check out the link – http://www.microsoft.com/en-us/learning/certification-overview.aspx) Nothing has changed in terms of … Continue reading

Read more

1 comments, 308 reads

Posted in All About SQL on 13 October 2016

Azure SQL Database – TDE

I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent Data Encryption – see this article for more details https://blobeater.wordpress.com/category/sql-server-2/tde/ ) is nothing new, setting it up on “earthed” SQL Servers … Continue reading

Read more

1 comments, 254 reads

Posted in All About SQL on 10 October 2016

SQL Performance Dashboards – update

SQL Server Performance Dashboards – update The first article that I ever wrote (http://www.sqlservercentral.com/articles/SQL+Server/127992/) was last year where I wanted to share with people a project that took me many late nights to complete. The idea of using Microsoft’s performance … Continue reading

Read more

1 comments, 391 reads

Posted in All About SQL on 7 October 2016

ALTER INDEX….ABORT!

I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes it makes sense it is a great product with a lot of new features such as Query Store, Stretch DB … Continue reading

Read more

2 comments, 309 reads

Posted in All About SQL on 6 October 2016

Detaching corrupt databases

Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL 2005 and prior it was possible, with the newer versions of SQL you will not be able to … Continue reading

Read more

2 comments, 301 reads

Posted in All About SQL on 4 October 2016

Query Store – Quick Tour

The query store, Borko Novakovic Senior Program Manager from Microsoft calls this feature “Similar to an airplane’s flight data recorder”. To get this setup there are some pre-Reqs needed. First you need the latest version of SSMS https://msdn.microsoft.com/library/mt238290.aspx – download … Continue reading

Read more

1 comments, 293 reads

Posted in All About SQL on 3 October 2016