Secure Your Spot at the Nashville SQL Saturday!

PASS SQL Saturdays are free 1-day training events for IT professionals interested in Microsoft SQL Server, providing a variety of high-quality technical sessions, all happen through the efforts of local volunteers.  The leadership team of the local chapter of PASS here in Nashville (Facebook | LinkedIn) have worked hard to make this year's SQL Saturday a day of great training and networking. The local NashSQL leadership team includes yours truly (blog | twitter), Joe Webb (Twitter | Blog), Louis "Dr SQL" Davidson (Twitter | Blog), Christina Leo (blog | twitter), and Shelton Dickson … [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...]

Come See Me. I’ll Probably Be Just Down the Street Soon!

Even though I've recently changed jobs, I'll still be speaking at a lot of SQL events across the country and internationally.  There are still a few trips that I've yet to finalize, in particular with the fine folks in Houston, run by my friend Nancy Hidy (blog | twitter), and my friends in San Francisco and Silicon Valley, run by my friend Mark Ginnebaugh (blog | twitter).  Also, do to some missed deadlines, it looks like I won't be speaking at the Nordic SQL Rally this fall. My bad!  On the other hand, you can see when checking my roster, that I hardly have time to catch my breath with this … [Read more...]

High-Availability White Papers and Resources for SQL Server

I was just telling the good people of Charlotte about how they (and how YOU) need to read all things by Paul Randal (blog | twitter), except for all of his cheesy romance novels like Caress and Conquer written under the nom de plum of Connie Mason. There's lots more good stuff from Paul, just not romantic. This is a 'so-last-version' whitepaper describing  five common high-availability and disaster-recovery architectures deployed by customers, along with a case study of each. Although the white paper is specific to SQL Server 2008 R2 and isn't updated for AlwaysOn features, it's still … [Read more...]

Build Your Own Microsoft Operations Manager Pack

Operations Manager Management Pack Development Kit I just recently told you about some cool new things happening with System Center - before I stumbled across this tidbit.  Hey, if I could, I'd go back in time and add this entry to the previous one --- yeah, and totally NOT play the stock market to make a fortune through time travel.  But I digress... So the Operations Management Management Pack Development Kit applies to Microsoft Operations Manager 2012 and Microsoft System Center Operations Manager 2007.  It provide the you with all of the info need to design and build a management pack … [Read more...]

How is Microsoft IT using the Cloud?

Steve Balmer very publicly pronounced that Microsoft was “all in” for cloud computing and Windows Azure.  So that means Microsoft is using cloud for its internal IT as well as building products to utilize the cloud.  If you want to learn how Microsoft IT is using Windows Azure to move existing applications to the cloud and creating new applications for the cloud, click here: IT Showcase on Windows Azure.   Let me know what you think.  Accurate and informative? Or marketing fluff? Thanks, -Kevin Follow me on Twitter! … [Read more...]

Give A Round of Applause for Microsoft System Center!

I hope you've taken a few minutes to peek in on the nice refresh that's happened on a bunch of the System Center engineering blogs.  Good things are afoot there.  And if you haven't checked in, avail yourself of these great resources: System Center: Service Manager System Center: Operations Manager System Center: Virtual Machine Manager System Center: Orchestrator System Center: Data Protection Manager And, as always, I'm interested in your feedback. Tell me what you think! Enjoy, -Kevin Follow me on Twitter! … [Read more...]

New White Paper: SQL Server Extended Events and Notifications

Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred.  There's PerfMon, and Profiler, and loads of Dynamic Management Views to check.  But where to look? As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white … [Read more...]

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

Here's an evergreen question.  It's a question that never completely goes away.  But lately, I've been getting it a few times per week.  So I thought it's time to readdress the question, which usually takes some form of the following: I can't really do effective development on my little dev laptop because our production SQL Server database is 15 gazillionbytes, way too big for my workstation.  What's a uber-nerd to do?  Well, maybe they didn't use the word "uber-nerd".  But you get my drift, right?  The production database is really, really big - unmanageably big for keeping a local copy.  … [Read more...]

Have You Heard About the Microsoft TechNet Wiki?

Here's another one to add to your list of browser bookmarks! The TechNet Wiki covers Microsoft technologies from writers throughout the community for use by the community. As with all wikis, this grassroots effort needs your help. Microsoft is encouraging everyone to contribute the effort - all you have to do is join. So start a whole new article, add your knowledge or draw from your experience to improve an existing article. You can start small or large... Join in at http://social.technet.microsoft.com/wiki/ or simply use the wiki as a new resource to answer your tough technology … [Read more...]