-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2015

Shredding XML in XEvents

One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues.

Despite that, Extended Events takes advantage of XML much like we have seen in… Read more

2 comments, 606 reads

Posted in SQL RNNR on 26 August 2015

Compressing Outcomes

You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a spare chair in your cubicle to talk about the weather.

Well, not entirely true there. The CIO dropped in because the alerts for disk space have been blowing up everybody’s… Read more

0 comments, 607 reads

Posted in SQL RNNR on 24 August 2015

Tables, Columns and Defaults Oh My!

Picture this if you could. You inherit a new database either through the change of a job, or finding a black box database server, or maybe due to the acquisition of a new application.

No matter the cause, you are now responsible for maintaining that database and you also really… Read more

0 comments, 1,903 reads

Posted in SQL RNNR on 19 August 2015

Compressing Encrypted Backups

A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much smaller.

This was a knock for the early days of Transparent Data encryption (circa SQL Server 2012). If TDE were enabled,… Read more

1 comments, 1,647 reads

Posted in SQL RNNR on 11 August 2015

What is DBCC?

If I ask you what is DBCC, what would your answer be?

I want you to think about that one for just a little bit. What comes to mind when you hear DBCC? Is it the default go-to used when talking about consistency checks? Is it something more involved? Maybe… Read more

1 comments, 4,521 reads

Posted in SQL RNNR on 11 August 2015

HealthySQL – A Review

How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or even what the health was like a few months back? Sure, one could anecdotally say the databases and servers are healthy, but how do you quantify it?

Many have asked… Read more

0 comments, 2,167 reads

Posted in SQL RNNR on 7 August 2015

Table Size Script Update for 2015

As was recently promised, I have an update to an old tried and true script for calculating the size of an object.

That promise was doled out in the previous article when I discussed the internal table types. You can read the article here. Information from that article was… Read more

2 comments, 937 reads

Posted in SQL RNNR on 4 August 2015