Browse by Tags

• Administration
• Automation
• Backup
• Best Practices
• Big Data
• Blogging
• Business Intellience
• Career
• Cloud Computing
• Conferences
• data cleansing
• data quality
• Database Design
• DBA
• Developer
• Devices
• ETL
• Express Edition
• FutureWatch
• Gadgets
• Google
• Hardware
• High Availability
• Humor
• Infrastructure
• Internals
• Interoperability
• IO
• IT Horror Stories
• Leadership
• Memory
• Monitoring
• MySQL
• News Analysis
• NoSQL
• On-line Resources
• Opinion
• PASS
• People
• Performance
• Productivity
• Professional Development
• Quest Software
• Recovery
• Releases
• Robocopy
• Society
• Speaking
• SQL Programming
• SQL Server 2012
• SQLIOSIM
• SQLMag
• Tools
• Transact-SQL Programming
• Trends
• Troubleshooting
• Video
• Virtualization
• Wait States
• Web Development
• WorldView
• Writing

• 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: Administration, Best Practices, Internals, Performance, Releases, SQLMag, Tips, Troubleshooting

• Database Maintenance Scripting Done Right

  I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's Read More... Posted Friday, February 18, 2011 8:16 AM by KKline | 0 Comments Filed under: Administration, Automation, Best Practices, People, Performance, SQL Programming, Tips, Tools

• Cloud Evolving, SQL Server Responding

  Brent Ozar ( blog | twitter ) and I did an interview with TechTarget’s Brendan Cournoyer at last summer's Tech-Ed, which as turned into a podcast titled “Cloud efforts advance, SQL Server evolves.” The podcast covers all the major trends at the conference Read More... Posted Wednesday, February 02, 2011 9:49 AM by KKline | 0 Comments Filed under: Administration, Career, Cloud Computing, Conferences, Opinion, People, Professional Development, Tips, Trends, Writing

• Azure, a Beautiful Color, and So Much More...

  Windows and SQL Azure Resources Cloud computing is more than just the latest buzz word in the IT trade papers. It is a remarkable paradigm shift with as much potential to "turn over the apple cart" of IT computing as client-server had for the world of Read More... Posted Thursday, January 27, 2011 5:04 PM by KKline | 0 Comments Filed under: Administration, Cloud Computing, Developer, Tips, Tools

• Top Notch Database Professionals Offer More Than Technical Prowess

  I've done a poor job lately in keeping my SQLBlog posts synchronized with my professional blog . As a result, you probably haven't seen a column I've been doing on professional development for the database professional called Plays Well With Others . Read More... Posted Saturday, November 06, 2010 3:02 PM by KKline | 0 Comments Filed under: PASS, Professional Development, Tips

• Visual Studio 2010 - Special Edition

  I wanted to pass along this great info from Microsoft. There are literally oodles of free resources for Visual Studio programmers. In their own words... Take Visual Studio for a Test Drive Take this powerful tool and its features for a spin by downloading Read More... Posted Friday, September 10, 2010 4:21 PM by KKline | 0 Comments Filed under: Best Practices, Developer, Tips, Web Development

• Significant Personnel Moves Inside of the Microsoft Azure Team and "Protect Your @#$% Content!"

  Dream Team Forms Around Azure If you're wondering whether to hedge your long-term bets on cloud computing, this should help you solidify your thinking. Microsoft has been building a dream team for Azure , including the patriarch of Windows (and father Read More... Posted Sunday, August 01, 2010 1:57 PM by KKline | 0 Comments Filed under: Cloud Computing, People, Professional Development, Quest Software, Tips, Writing

• It's the Atlanta Attendance Contest!

  I'm speaking tonight on Top 10 Mistakes DBAs Make at the Atlanta SQL Server User Group meeting in Alpharetta, GA. You can find all of the details here . The Best Dang Design Book for SQL Server Professionals - EVER! I thought I'd liven things up a bit Read More... Posted Monday, July 12, 2010 11:02 AM by KKline | 1 Comments Filed under: Administration, Best Practices, Database Design, PASS, Speaking, Tips

• New on SQLMag - Automating the Startup and Shutdown of Windows Services

  How to automate the shutdown and startup of Windows services Read More... Posted Tuesday, April 27, 2010 6:21 PM by KKline | 0 Comments Filed under: Administration, Automation, SQLMag, Tips, Tools

• New Webcast - SQL Server Internals & Architecture

  Join me tomorrow for the PASS DBA Virtual Chapter meeting SQL Server Internals & Architecture (or view the archive). It's the most fun you'll ever have learning about the inner workings of a relational database - I promise! Read More... Posted Tuesday, March 23, 2010 12:23 PM by KKline | 8 Comments Filed under: Administration, PASS, Speaking, Tips

• The Awesomeness of ROBOCOPY Now at SQLMag

  If you're like me, you've used Ctrl+C/Ctrl+V more than a time or two, but you've always felt a little dirty afterwards. Yeah, you can use the command-line COPY or XCOPY utilities. But they're decidedly 20th Century, much like some of the laundry still Read More... Posted Tuesday, January 12, 2010 9:22 PM by KKline | 3 Comments Filed under: Robocopy, Tips, Tools

• 2009: The Year in List Form

  Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock ( blog | twitter ), I decided I'd spend a few minutes looking back on both the year 2009. (From a personal standpoint, the 00's were my most difficult decade yet. Major Read More... Posted Tuesday, January 05, 2010 2:53 PM by KKline | 0 Comments Filed under: Administration, Humor, Opinion, People, Performance, SQL Programming, SQLIOSIM, Tips, Tools, Trends

• Got a slow holiday seaons? Why not spend it learning?

  Traditionally, the time between Christmas and New Years is a bit slow. Many people take time off from work and, for those of us still working, it's a good time to catch up on all of those low priority projects that have been on the back burner for the Read More... Posted Thursday, December 31, 2009 1:40 PM by KKline | 3 Comments Filed under: Releases, Tips, Virtualization

• Like PowerShell for SQL Server?

  Check out my new Tool Time column in this month's SQL Server Magazine . It features some great new PowerShell scripts and information from Chad Miller ( blog ) who I had the pleasure to meet in person back in October of this year while speaking at the Read More... Posted Monday, December 14, 2009 6:29 PM by KKline | 0 Comments Filed under: Administration, Quest Software, Tips, Tools

• Sequels for SQL Server: The Week of November 27, 2009

  I'm starting a new series called Seven Sequels for SQL. In this series, I point you to seven sites where you can go beyond the nose-to-the-grindstone resources that we see every day as SQL Server professionals. These are the story that comes after and outside (the sequels) of our daily working lives (the other SQL). Let's broaden our horizons together. Read More... Posted Wednesday, November 25, 2009 5:02 PM by KKline | 0 Comments Filed under: Devices, FutureWatch, Gadgets, Humor, Opinion, Performance, Professional Development, Society, Tips, Trends, WorldView