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

Kevin provides two new session slide decks and tells about his week presenting sessions in Colorado from August 14-17, 2012.

SQLMag = SQL Server Pro. Goes all-digital!

I was recently chatting with Megan Keller, my long-time editor for the Tool Time column and Executive Editor at SQL Server Pro, DevProConnections, and SharePoint Pro.

New on SQLMag Tool Time Blog – Update to FineBuild

Read about the latest update to FineBuild for SQL Server, a tool with speeds installation and configuration of SQL Server and associated utilities and programs.

Everybody Needs a Test Harness

Here’s a handy little block of T-SQL code to improve code stability.

Blogger, Have You Heard of Microsoft Broadcaster?

Microsoft unleashes a torrent of free technical content which you can use in your blogs or user group site to drive deeper engagement with your audience and community.

SQL Server Migration Roll-Up

Here are a hand full of cool database migration tools and white papers worth mentioning for SQL Server, Oracle, MySQL, and Sybase.

New on SQLMag.Com: Update to SP_WHOISACTIVE

I profiled Adam Machanic’s excellent stored procedure, SP_WHOISACTIVE, back in August of 2010

Database Maintenance Scripting Done Right

why write your own when you can download a prewritten preventative maintenance script for SQL Server?

What’s Up With Discovery Wizard for SQL Server?

Disco is a free tool for DBAs and developers that enables you to discover and inventory almost all extant versions and editions of Microsoft SQL Server

Video: Ensure Optimal Performance When Deploying SQL Server 2005

Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including:
* Hardware design
* SQL Server configuration settings
* Database configuration settings
* Application design
* SQL Tuning