Browse by Tags

• Administration
• Automation
• Best Practices
• DBA
• Developer
• Infrastructure
• Internals
• IO
• Performance
• Releases
• Speaking
• SQL Programming
• SQL Server 2012
• SQLMag
• Tips
• Tools
• Troubleshooting
• Video

• Learn More About SQL Server IO and Query Tuning in These Webcasts

  Join database expert Kevin Kline in two new webcasts for SQL Server users: Storage IO Best Practices and Query Tuning Best Practices. Read More... Posted Friday, December 14, 2012 1:50 PM by KKline | 5 Comments Filed under: Performance, Administration, Internals, Speaking, Tips, Troubleshooting, Developer, Infrastructure, DBA, Transact-SQL Programming, SQL Server 2012, Video, IO

• Help Me Update the History of SQL Server

  Find out the early history and evolution of Microsoft SQL Server in this engaging article from database expert Kevin Kline. Read More... Posted Wednesday, September 12, 2012 11:01 AM by KKline | 6 Comments Filed under: SQL Programming, Releases, Administration, Transact-SQL Programming

• Flexibility When Waiting on Locks

  An attendee at a recent performance tuning session wanted ideas to more flexibly react to locks on blocks than using the WITH (NOLOCK) hint. Read More... Posted Thursday, May 17, 2012 9:29 AM by KKline | 1 Comments Filed under: Tips, Developer, Transact-SQL Programming, SQL Server 2012

• Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

  If you're struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap! Read More... Posted Friday, March 16, 2012 10:30 AM by KKline | 3 Comments Filed under: SQL Programming, Best Practices, Tips, Tools, Developer, SQLMag, Transact-SQL Programming

• Everybody Needs a Test Harness

  Here's a handy little block of T-SQL code to improve code stability. Read More... Posted Monday, October 31, 2011 10:17 AM by KKline | 3 Comments Filed under: Performance, Administration, Troubleshooting, Developer, Automation, DBA, Transact-SQL Programming