Browse by Tags

• AlwaysOn
• Automation
• Backup
• Best Practices
• Career
• Cloud Computing
• Database Design
• Database Mirroring
• DBA
• Developer
• Disaster Recovery
• Ethics
• FutureWatch
• High Availability
• Infrastructure
• Internals
• Interoperability
• IO
• Migration
• MS-Access
• MySQL
• News Analysis
• Opinion
• Oracle
• PASS
• People
• Performance
• Professional Development
• Quest Software
• Releases
• Security
• Society
• Speaking
• SQL Programming
• SQL Server 2008 R2
• SQL Server 2012
• SQLMag
• Sybase
• Tips
• Tools
• Transact-SQL Programming
• Trends
• Video
• Wait States
• White Papers

• 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

• High-Availability White Papers and Resources for SQL Server

  These resources detail five common high-availability and disaster-recovery architectures deployed by customers, along with a case study of each, plus FAQs about SQL Server high availability. Read More... Posted Thursday, July 26, 2012 11:00 AM by KKline | 3 Comments Filed under: Administration, Troubleshooting, Database Mirroring, High Availability, Security, Backup, SQL Server 2012, AlwaysOn, Disaster Recovery

• New White Paper: SQL Server Extended Events and Notifications

  Download the new, free white paper from Microsoft MVP Jason Strate detailing SQL Server Extended Events and Event Notifications (registration required). Read More... Posted Wednesday, April 25, 2012 9:13 AM by KKline | 10 Comments Filed under: Performance, Best Practices, Administration, Troubleshooting, Tools, Automation, Infrastructure, DBA, SQL Server 2008 R2, White Papers

• 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

• Pain of the Week/Expert's Perspective: Performance Tuning for Backups and Restores

  First off - the Pain of the Week webcast series has been renamed. It's now known as The Expert's Perspective . Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster! The bigger Read More... Posted Monday, June 27, 2011 10:39 AM by KKline | 0 Comments Filed under: Performance, Best Practices, Administration, Troubleshooting, Automation, High Availability

• Available Online - SQL Server Training Videos

  Interested in my various performance tuning and troubleshooting videos about SQL Server? These videos feature my good buddies (and uber-SQL Server experts) Brent Ozar ( blog | twitter ) and Buck Woody ( blog | twitter ). View these insight-packed training Read More... Posted Wednesday, June 01, 2011 11:37 PM by KKline | 0 Comments Filed under: Performance, Best Practices, Administration, Quest Software, Troubleshooting

• SQL Server Migration Roll-Up

  There are so many great tools out there for data professionals using Microsoft SQL Server. I really like to see all of these great tools made free to the public. On the other hand, I'm bummed that the tools are cast about in a very decentralized fashion. Read More... Posted Monday, May 02, 2011 10:42 AM by KKline | 0 Comments Filed under: Administration, Interoperability, Troubleshooting, Oracle, Sybase, Migration, MS-Access, MySQL

• New on SQLMag.Com: Update to SP_WHOISACTIVE

  I profiled Adam Machanic's ( blog | twitter ) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time. Adam has been diligent about maintaining the tool and adding new features. Read the details on my Read More... Posted Thursday, April 21, 2011 10:12 AM by KKline | 2 Comments Filed under: Performance, Releases, Best Practices, Administration, Internals, Tips, Troubleshooting, SQLMag

• Reminder: Totally Awesome and Totally Free Training SQL Server Training

  One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia , to our free posters mailed anywhere in North America (and don't forget the free hi-res Read More... Posted Monday, February 21, 2011 8:45 AM by KKline | 0 Comments Filed under: Performance, Best Practices, Administration, Quest Software, Troubleshooting, Wait States, Opinion

• My Last "Catch-Up" Post for 2010 Content

  I did a lot of writing in 2010. Unfortunately, I didn't do a good job of keeping all of that writing equally distributed throughout all of the channels where I'm active. So here are a few more posts from my blog, put on-line during the months of November Read More... Posted Friday, December 31, 2010 3:57 PM by KKline | 0 Comments Filed under: Trends, Best Practices, Administration, Troubleshooting, Opinion, Professional Development, Database Design, Tools, Ethics, Society, FutureWatch, News Analysis, Developer, Career

• Join Me May 19th for 24 Hours of PASS

  Check out all the great SQL Server sessions you can attend for FREE in this on-line event. Read More... Posted Monday, April 26, 2010 10:16 AM by KKline | 0 Comments Filed under: Performance, SQL Programming, Administration, Internals, People, Speaking, Troubleshooting, Professional Development, PASS, Database Design, Cloud Computing, Developer

• Free Training for You, Punishing Workload for Me. Thank You for Enjoying My Misery.

  Everybody enjoys a little free training now and then. I've got mountains of free training in the works. Some of it is in-person and local while some are in webcast format. Please join me as you're able! Tomorrow - Wednesday! Wed, Feb 10, 2010 12 pm (noon) Read More... Posted Tuesday, February 09, 2010 2:12 PM by KKline | 3 Comments Filed under: Best Practices, Administration, People, Speaking, Quest Software, Troubleshooting, Professional Development, PASS, Tools, Developer

• SSIS Packages Need Love Too, er, Memory Too!

  Kevin shares some tips on how to predetermine and then track memory usage by SSIS packages. Read More... Posted Thursday, October 09, 2008 12:53 PM by KKline | 0 Comments Filed under: Performance, Administration, Troubleshooting

• SQL Server Memory Tracking with Windows Task Manager

  Kevin describes a possible problem scenario when monitoring SQL Server memory using Windows Task Manager. Read More... Posted Friday, August 29, 2008 6:01 PM by KKline | 4 Comments Filed under: Performance, Administration, Troubleshooting

• More SQL Server Automation Scripts

  Kevin points you to some new SQL Server scripts that automate database administration tasks. Read More... Posted Wednesday, March 26, 2008 4:12 PM by KKline | 1 Comments Filed under: Administration, People, Tips, Troubleshooting, Tools