Over recent months I have written a series of articles on how the overall size of a financial services database was tamed by the application of table compression, XML compression, and PDF size reduction. I have applied this approach at many sit...
We know that late last year Microsoft announced their plans to bring a collection of Head Mounted Displays (HMDs) as part of a partnership with Intel called Project Evo...
In doing “more with less”, far too many organizations own a potential “suite” (of integrated apps and data) that they don’t really know they have. In other words, these organizations are well-positioned to...
The Most Important Task for DBAs
It's what matters most for a Database Administrator: being able to recover databases with as little loss of data as possible. In order to accomplish this you need two things of equal importance:
A well-exe...
I recently had someone pose the following question to me: "Is it possible to collect login/security information from a backup of the master database?" Since I'm always looking for topics to write about here I wanted to answer that question here...
Never Upset a Nerd
In 2010 I wrote a book on Dynamic Management Objects with fellow SQL Server MVP Louis Davidson. Over the years I've grown even more passionate about what these constructs offer to the DBA and Developer alike in identifyin...
Microsoft SQL Server offers system objects called Dynamic Management Objects which offer metadata insights into performance aspects of your SQL Server instances. Using one in particular, sys.dm_io_virtual_file_stats, empowers the data...