Neeraj Tripathi SQL Server Heaps, and Their Fragmentation In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are... 02 November 2015 11 min read
Laerte Junior Automating Your SQL Server Best Practice Reports: The Document If you're making a report from table-based data, an MS Word document is often a good option. In the second... 21 October 2015 10 min read
Laerte Junior Automating Your SQL Server Best Practice Reports:The Checks A DBA in charge of a whole lot of databases and servers has to check regularly that there are no... 06 October 2015 13 min read
Mike Fal DevOps and the DBA Michael Fal is a huge advocate of automation and many ways it can improve the lives of developers and DBAs... 08 May 2015 11 min read
Robert Sheldon How to Get SQL Server Security Horribly Wrong It is no good doing some or most of the aspects of SQL Server security right. You have to get... 29 April 2015 24 min read
Grahaeme Ross Understanding Cross-Database Transactions in SQL Server Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database... 11 April 2015 19 min read
Joshua Feierman How DBAs Can Adopt the Craftsman Mindset The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen... 01 April 2015 16 min read
Robert Sheldon How to get Database Design Horribly Wrong Database Design is one of those tasks where you have to carefully get all the major aspects right. If you... 06 March 2015 34 min read
Tony Davis Questions About SQL Server Transaction Log You Were Too Shy To Ask You can give a deep-dive presentation about SQL Server's transaction log, and round it off by inviting questions. Your audience... 11 February 2015 26 min read
Feodor Georgiev Curing Data-Obesity in OLTP Databases OLTP databases work best when data that becomes no longer current is then transferred to a separate database for analysis... 06 February 2015 13 min read
Jonathan Watts The Promise – and the Pitfalls – of In-Memory OLTP When SQL Server 2014 was released, it included Hekaton, Microsoft's much talked about memory-optimized engine that brings In-Memory OLTP into... 04 February 2015 7 min read
Dennes Torres Centralize Your Database Monitoring Process SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about... 26 January 2015 17 min read
Phil Factor A Start with Automating Database Configuration Management For a number of reasons, it pays to have the up-to-date source of all the databases and servers that you're... 16 January 2015 24 min read
Dennes Torres Exploring Query Plans in SQL SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time.... 31 December 2014 15 min read
Feodor Georgiev Data Cleaning in SQL 2012 with Data Quality Services For data to be usefully analyzed, it must be consistent, accurate, and trustworthy. When incoming data is non-uniform, duplicated records... 31 December 2014 11 min read
Matthew Skelton Continuous Delivery for Databases: Microservices, Team Structures, and Conway’s Law Having described some of the most common database deployability blockers, Matthew Skelton proposes a way to enable database continuous delivery... 19 November 2014 20 min read
William Brewer Database Configuration Management for SQL Server It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention... 05 November 2014 16 min read
Kalen Delaney Hekaton in 1000 Words The SQL Server 2014 In-Memory OLTP engine (a.k.a. Hekaton) is a radical change for relational databases. This article, an exerpt... 22 October 2014 6 min read
Joshua Feierman The Mindset of the Enterprise DBA: Delegating Work A lot of the routine jobs demanded of a DBA can be automated, but a tougher prospect is to automate... 17 October 2014 19 min read
Scott Swanberg Exploring Your SQL Server Databases with T-SQL Most DBAs hoard their own favourite T-SQL scripts to help them with their work, often on a USB 'thumbdrive', but... 09 October 2014 40 min read
