Beating Back the Creeping Tyranny of Big Data

Jan 04, 2017

By Mark Buchanan ...

Better Business Decisions via an Application “Suite” You Already Own

Jan 03, 2017

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...

Sponsor Content

What You Need to Know About Managing Your SQL Server Performance

Jan 01, 2017

Sponsored by: IDERA

How Old Are Your Backups?

Dec 30, 2016

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...

Querying Secure Information from a Restored Master Database Backup

Dec 29, 2016

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...

SQL Server IO Analysis Part 2

Dec 23, 2016

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...

SQL Server IO Analysis Part 1

Dec 23, 2016

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...

Using Optimize for Ad Hoc Setting in SQL Server

Dec 21, 2016

The size of the plan cache in SQL Server is not configurable. You only have so much space allocated for caching query plans and why waste that with single-use ad hoc queries? Since SQL Server 2008 there's been a simple solution for...

Quick T/SQL Tip: Parsing Drive and File Information in SQL Server

Dec 16, 2016

Parsing full physical file names for information is one of those tasks a Database Administrator finds they do on a semi-frequent basis; from looking up SQL Agent Job output paths or reviewing database file metadata. Recently, I found myself up...

Microsoft to Release Translator App in AI Race Against Google

Dec 14, 2016

(Bloomberg) -- Microsoft Corp. said it will release a translation app for Windows and other operating systems from rivals Apple Inc. and Google, part of a broader race between the world’s largest technology companies for supremacy in the...