Good reads from around the Web.
Morning folks! Regular readers know that I’m a huge fan of Automation when it comes to life as a Data Professional. This week what I’m interested know is how you automate deployments to SQL Server in your environment? What software and tools do you use to perform your deployments, maybe you have created your own bespoke system? Are you going all crazy about Agile practices and using Continuous Integration in your shop? Share your thoughts and experiences in comments.
Here’s your weekly roundup of SQL Server Blog Posts, News and Technology Stuff. Enjoy….
From the SQL Server blogs
- Multi-column statistics and exponential backoff – Kimberly Tripp (Blog|Twitter)
- Why Haven’t You Changed Everything? – Grant Fritchey (Blog|Twitter)
- Guess the Bug Source: Microsoft SQL Server or MongoDB – Brent Ozar (Blog|Twitter)
- Force only certain values to be unique – Kenneth Fisher (Blog)
- An Incompatible Sql Server Version Was Detected – Thomas Larock (Blog|Twitter)
- Database Lifecycle Management – Grant Fritchey (Blog|Twitter)
- Parameter Sniffing, Part 1 – Klaus Aschenbrenner (Blog|Twitter)
- Compatibility Level vs Database Version – John Morehouse (Blog|Twitter)
- Why I Don’t Use SQL Server’s Activity Monitor – Kendra Little (Blog|Twitter)
SQL Community Forum
- Database performance is very poor after a month of use
- Identity and graceful shutdown – When is a SQL shutdown graceful?
- SA Passwords SQL 2012