sys.dm_db_persisted_sku_features (Introduced in SQL Server 2008) DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/cc280724.aspx
Some features of the SQL...
2013-05-13
2,092 reads
The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies...
2013-05-13 (first published: 2013-05-07)
1,582 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-13
661 reads
Starting with SQL Server 2005 all tables are grouped into schemas. While creating a table if the schema name is...
2013-05-13
1,816 reads
I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I...
2013-05-13
1,087 reads
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-12
719 reads
This script looks much more intimidating than the results it produces, so I recommend running it before reading through it. ...
2013-05-11
471 reads
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-10 (first published: 2013-05-04)
5,201 reads
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
706 reads
2013-05-10
409 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers