Feodor Georgiev Collecting the Information in the Default Trace The default trace is still the best way of getting important information to provide a security audit of SQL Server,... 02 July 2013 14 min read
Rob Garrison Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1 The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you... 25 June 2013 12 min read
Jonathan Allen Preparing to Upgrade your SQL Server It isn't a problem to use deprecated TSQL features until it comes to the time to move the database to... 12 June 2013 17 min read
Alexander Karmanov Automating SQL Server Database Deployments: Scripting Details To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted... 06 June 2013 30 min read
Grant Fritchey The DBA Detective: The Case of the Missing Index When problems arise in SQL Server, we're faced with a server full of suspects, including disk I/O, memory, CPU, incorrect... 15 May 2013 12 min read
Allen White Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell.... 03 May 2013 15 min read
Kat Hicks Diagnosing Common Database Ails When a database starts showing signs of an illness, it's up to the DBA to get to the root of... 25 March 2013 13 min read
Tony Davis Shawn McGehee Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth You've just become responsible for a database, only to find that the log file is growing out of control. Why... 14 March 2013 13 min read
Seth Delconte Ad-Hoc XML File Querying When you need to shred just part of the data within a large XML file into a SQL Server table,... 05 March 2013 15 min read
Alexander Karmanov Automating SQL Server Database Deployments: A Worked Example Alex talks through a simple practical example of a database deployment, First creating a empty database and then upgrading it... 27 February 2013 21 min read
Feodor Georgiev Full Text Searches on Documents in FileTables SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex... 14 February 2013 11 min read
Alexander Karmanov An Incremental Database Development and Deployment Framework Often, an existing database application must evolve quickly by incremental steps. Alex describes a tried and tested system to provide... 12 February 2013 27 min read
Robert Sheldon Getting Started with Extended Events in SQL Server 2012 Extended Events provide a way of unintrusively monitoring what's going on in a SQL Server instance. Unlike SQL Server Profiler... 04 February 2013 16 min read
Phil Factor Database Deployment: The Bits – Versioning Although databases have no inherent way of recording their version numbers, SQL Server provides the means of doing so, and... 04 February 2013 11 min read
Fabiano Amorim Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment SQL Server's Query optimiser judges the best query plan from the data in the relevant tables and the server's hardware.... 30 January 2013 9 min read
Warwick Rudd Expanding AlwaysOn Availability Groups with Replication Subscribers High Availability (HA) and Disaster Recovery (DR) can be provided for subscription databases from an AlwaysOn Avaliability Group, but the... 18 January 2013 8 min read
Gail Shaw The SQL Server Instance That Will not Start Everyone's SQL Server nightmare: The instance will not start. If such a problem strikes you, keep calm, follow Gail's advice,... 17 January 2013 29 min read
Warwick Rudd Expanding AlwaysOn Availability Groups with Replication Publishers SQL Server 2012 AlwaysOn Availability Groups provide a high-availability and disaster-recovery solution for you SQL Server 2012 environments. Replication has... 14 January 2013 9 min read
Feodor Georgiev HDDs, SSDs and Database Considerations In this article Feodor clears up a few myths about storage, explains the difference in how HDDs and SSDs work... 09 January 2013 11 min read
Robert Sheldon Handling Errors in SQL Server 2012 The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included... 03 January 2013 10 min read
