DBTA: Getting Up to Speed on the SQL Server Social Media Scene

If you haven't paid attention to the new social media, you're doing yourself a disservice.  Just as email was a game-changer in the 1980s and the internet revolutionized society in the 1990s, social media is making a huge impact on the way people work and interact today.  Personally, I was skeptical about social networking until some good friends persuaded me to give it a trial run.  It seemed like a great way to dither away some valuable time, but I didn't see the business value in the whole proposition until I tried it. [READ MORE] … [Read more...]

Video: Maximize SQL Server Performance with SQL Tuning

This presentation is a bit old, but largely still applicable.  It will help you understand Microsoft tuning techniques. It will teach tips and tricks for making queries perform better, and how to use tools to tune SQL. Posted March 27, 2007. … [Read more...]

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 a full Visual Studio 2010 trial version. Discover how Visual Studio 2010 Professional helps individual developers build, test, debug software solutions. http://clk.atdmt.com/MRT/go/206383954/direct/01/ Attend an Event Find out how you can ride the next wave of innovation ushered in by Microsoft Visual Studio 2010. Choose from full day, … [Read more...]

Video: MVPs talk about SQL Server 2008

Video chat with Brent Ozar and SQL Server MVPs Kevin Kline, Hilary Cotter and Geoff Hiten to talk about how SQL Server 2008 addresses DBA challenges and pain points. In this webcast, we cover features like Transparent Data Encryption, spatial data, and other new things that really differentiate SQL Server 2008 from 2005. Posted December 24, 2008. … [Read more...]

Free Poster – SQL Server PerfMon Counters

You Needs It! You Wants It! We all know how hard troubleshooting SQL Server can be.  There are tools and techniques that can make troubleshooting much easier, such as the Windows System Monitor. The only problem with SysMon, or more commonly "PerfMon", is that it takes a lot of knowledge and experience to know which objects and counters to examine. I've put together a nice poster for you covering all of the important PerfMon counters for SQL Server troubleshooting, with a little help from some of my friends: Brent Ozar, Bob Ward, Christian Bolton, and Raoul Illyes. You Can Has It Fer … [Read more...]

Presentation: SQL Server for Oracle DBAs

Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA.  Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin.  You can see the recording and slide deck here.  Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had pretty good legs to stand on doing this presentation.  Here's the abstract: In enterprise IT, database professionals face a mixed-bag of platforms within their environments -- and the overlapping duties that go along with them. Whether you like it or not, you get … [Read more...]