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
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 SQL Server Query Plans: Finding Scan and Lookup Problems with DMVs and XQuery Use SQL Server DMVs (sys.dm_db_index_usage_stats) and XQuery against cached query plans to find queries causing scan and lookup problems. Converts... 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
Joshua Feierman High Availability and Disaster Recovery for Small Businesses Too often in the past , High Availability and Disaster Recovery have been marketed as expensive choices for businesses with... 16 December 2014 13 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
Joshua Feierman The Mindset of the Enterprise DBA: Harnessing the Power of Automation After you have done the necessary groundwork of standardizing and centralizing your database administration processes, you are now in a... 02 September 2014 16 min read
Joshua Feierman The Mindset of the Enterprise DBA: 8 Ways To Centralize Your Work Although it is possible to provide good service to small to medium companies as a DBA without putting in place... 12 August 2014 10 min read
Matthew Skelton Common database deployment blockers and Continuous Delivery headaches Deployability is now a first class concern for databases, so why isn't it as easy as it should be? Matthew... 06 August 2014 17 min read
Grant Fritchey Why Put Your Database into Source Control? Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood.... 08 July 2014 7 min read
Grant Fritchey Rollback and Recovery Troubleshooting; Challenges and Strategies What happens if your database deployment goes awry? Do you restore from a backup or snapshot and lose all the... 26 June 2014 16 min read
Joshua Feierman The Mindset of the Enterprise DBA: Creating and Applying Standards to Our Work Although many professions, such as pilots, surgeons and IT administrators, require judgement and skill, they also require the ability to... 25 June 2014 12 min read
Tony Davis Database Branching and Merging Strategies Source control will allow you to maintain branches in the development of your database, but the subsequent merge isn't pain-free.... 18 June 2014 23 min read
Database Administration Jonathan Hickford in Database Administration Database Migration Scripts: When to Write Them and How Database migration scripts handle changes that automated sync tools can't infer - table renames, column splits, data migrations. Learn when... 17 June 2014 21 min read
Saurabh Dhoble Setting Up Your SQL Server Agent Correctly It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges', and ensure... 28 May 2014 15 min read
