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
Tools Michael Sorens in Tools MySQL Data Compare: The Manual that Time Forgot MySQL Data Compare can both compare the data in MYSQL databases and also synchronise them. It is handy for a... 28 May 2013 16 min read
Robert Sheldon Getting Started with the SSAS Tabular Model SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to... 22 May 2013 16 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
Tools Michael Sorens in Tools MySQL Compare: The Manual That Time Forgot, Part 1 Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you... 03 May 2013 14 min read
Grant Fritchey Custom Metrics for Monitoring Database Mirroring SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure... 16 April 2013 7 min read
Robert Sheldon Getting Started Testing Databases with tSQLt There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is... 08 April 2013 22 min read
Michael Sorens TortoiseSVN and Subversion Cookbook Part 11: Subversion and Oracle It is only recently that the tools have existed to make source-control easy for database developers. Although entire build-scripts for... 03 April 2013 17 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
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
Robert Sheldon Some Books on Programming SQL Server 2012 It is a measure of the range of facilities that are available to the database developer nowadays that three different... 21 February 2013 12 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
Michael Sorens TortoiseSVN and Subversion Cookbook Part 10: Extending the reach of Subversion Subversion provides a good way of source-controlling a database, but many operations are best done from within your database-development environmant.... 12 February 2013 19 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
Feodor Georgiev SQL Monitor – Using the performance data smartly How does a Database Consultant use a tool such as SQL Monitor? The seasoned expert doesn't just dive into DMVs... 05 February 2013 8 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
Seth Delconte Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012 Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1... 25 January 2013 14 min read
