Browse by Tags

• Administration
• Automation
• Best Practices
• Conferences
• DBA
• Developer
• Hardware
• Infrastructure
• Internals
• IO
• On-line Resources
• PASS
• Performance
• Releases
• Speaking
• SQL Programming
• SQL Saturday
• SQL Server 2012
• SQL Server 2014
• SQLMag
• Tips
• Tools
• Troubleshooting
• Video

• Join Me at the Ft. Lauderdale SQL Saturday on June 14, 2014!

  If you're in South Florida, read the details about the upcoming SQL Saturday and Kevin's full day pre-conference seminar on Friday, June 13. Read More... Posted Wednesday, May 21, 2014 10:01 AM by KKline | 0 Comments Filed under: Conferences, PASS, Speaking, SQL Saturday, Transact-SQL Programming

• Amazingly Useful SQL Server Articles on SQLPerformance.com

  Ever wonder which specific T-SQL pattern is best for splitting strings? There are lots of ways to calculate running totals, but which is optimal? What CPUs are best for SQL Server 2012? For SQL Server 2014? Find out more in this post from Kevin Kline. Read More... Posted Monday, March 03, 2014 11:50 AM by KKline | 1 Comments Filed under: DBA, Developer, Hardware, On-line Resources, SQL Server 2012, SQL Server 2014, Transact-SQL Programming

• 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: Administration, DBA, Developer, Infrastructure, Internals, IO, Performance, Speaking, SQL Server 2012, Tips, Transact-SQL Programming, Troubleshooting, Video

• 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: Administration, Releases, SQL Programming, 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: Developer, SQL Server 2012, Tips, Transact-SQL Programming

• 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: Best Practices, Developer, SQL Programming, SQLMag, Tips, Tools, 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: Administration, Automation, DBA, Developer, Performance, Transact-SQL Programming, Troubleshooting