My Best Blog Posts from 2015

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in which I blogged. Namely - simply reposting a slight variant of a given blog post could hurt your overall SEO rankings for any of the given posts. Now you might be saying to me "Kevin, those aren't new factors. They've been around for a long time, you idgit". And I would say in response "Ok then. But I had other things on my mind". (Of course, if you have other recommendations for improving one's blog performance, … [Read more...]

Kevin and the Ice Bucket Challenge

Well, the entire Horde of my children had to play a part in this ice bucket challenge. And Kayden the #SQLBaby makes an appearance too. … [Read more...]

Top 10 DBA Mistakes on SQL Server

  Hear one of my most popular session via streaming media at SQLSentry.TV! Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t mean that database administration on SQL Server is problem free.  And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago.  Why not learn from those who first blazed the trails of database administration, so that we don’t make … [Read more...]

The All-New ‘Database Lifecycle Management” is available on MSDN

The initial release of Database Lifecycle Management is now available on MSDN. The site is something called "curated content". This means it's a single consolidated location to look up lots of disparate articles and content, all in one easy to search location. This “curated content view” contains the best content, video, and community-centric information from Microsoft, including topics like: SQL Server Data Tools · Get started with sample projects, code samples · Video demos by Gert Drapers (blog) · Script common data portability tasks using Sqlpackage.exe · Link to the SSDT … [Read more...]

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

I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, don't let the title mislead you.  This session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said "Times, they are a'changin'".  This session on Wednesday, December 19th at 11:30 AM EST, sponsored by Astute Networks, takes you through all of the basics of storage and IO tuning, regardless of the underlying storage technology.  I'll … [Read more...]

Two New Slide Decks. Plus, the Week in Colorado.

I had the honor of traveling the great state of Colorado last week, speaking at the PASS chapters in Boulder, Colorado Springs, and Denver.  At all three events, we had a stellar attendance and, at least in Denver, broke all the records in recent memory both in terms of overall attendance and in first-timers.  Denver, in fact, was standing room only and had nearly 30 first time attendees.  Great news!  I also want to give a special shout-out of thanks and appreciation to Chris Shaw (Twitter | Blog) whose hard work and tenacity ensured that all of Colorado got to see me speak. From left to … [Read more...]

Recorded Webcast Available: Extend SCOM to Optimize SQL Server Performance Management

Join me and Eric Brown, Quest Software senior product manager for SQL Server monitoring tools, as we discuss the server health-check capabilities of Systems Center Operations Manager (SCOM) in this previously recorded webcast. We delve into techniques to maximize your SCOM investment as well as ways to complement it with deeper monitoring and diagnostics. You’ll walk away from this educational session with the skills to: Take full advantage of SCOM’s value for day-to-day SQL Server monitoring Extend the capabilities of SCOM to proactively manage SQL Server performance Troubleshoot … [Read more...]

Two TechNet Radio Sessions You Don’t Want to Miss

I was recently honored to speak on TechNet Radio in two separate sessions about BigData & Hadoop and cloud databases (specifically SQL Azure).  The show debuted on the TechNet homepage under “Today’s News” and on the TechNet Edge homepage.  In each of these shows, I did what I like to do for all the parties I attend - bring a friend.  To make my life easier, I simply reposted the verbiage that TechNet used, rather that to write my own. About the BigData/Hadoop video: Microsoft SQL Server MVP Kevin Kline and Vice President of Database Development at Quest Software Guy Harrison (blog | … [Read more...]

Must-Have Resources – SQL Server Backup & Recovery

One of the things that drives me crazy as I'm getting older is that my brain is losing the capacity to differentiate version numbers.  As I speak travel around speaking with customers and at conferences, I find my self saying things like "I can't recall if this problem was fixed in SQL Server 2000 or 2005. But you don't have to worry about that any more."  Or things like "That feature was added in SQL Server 2008 R2, eh, or was that version 6.5.  DOH!" followed by a loud slapping sound as I whap my palm into my forehead. The Internet doesn't forget either.  Recommendations that were once … [Read more...]

New Releases in the Toad Family of Tools

Toad Extension for Visual Studio 1.2 is now live. You can access it HERE. Key new features in Toad Extension for Visual Studio v1.2: Deployment Scripts: the pre- and post-deployment scripts of TFS are now supported. XML Columns: supports tables with XML data type columns. Nested Tables: supports tables with up to two levels of nested table type columns. Synonyms: synonyms can now be imported into your DB project Source Navigation: You can now use F12 navigation to find the definition of items in the code editor. Stored Procedures: generate Oracle stored procedures that … [Read more...]