Our mission is to be the best location to find reviewed and accurate information on Microsoft SQL Server administration and development.


Demand Media is hiring many SQL positions

0
Your rating: None

Demand Media is looking for a very experienced SQL Server DBA. We are running on SQL 2005/2008, Windows 2003/2008, and MySQL 5/5.1. Clustering and replication experience a must. Apply at www.demandmedia.com/jobs

 

Hundreds of Great PowerPoint Slides and How To

0
Your rating: None

Microsoft has published 157 great Power Point template examples and how to create cool effects to spice up our slide decks: http://blogs.msdn.com/inside_office_online/archive/2009/10/29/watch-ppt157-everything-in-this-video-is-a-powerpoint-template.aspx

I keep a folder on all my computer systems that store cool template files that I like and would want to re-use in the future. Comes in handy done the road.

-Chuck

SQL Replication Undelivered Command Count

0
Your rating: None

Ever wanted to get an email summary of subscriptions that are behind a certain amount? This script can do it! Just setup as a job on your distributor and it will send you a summary email with how many commands are yet to be delivered in a table format for easy reading.

SQL Replication Error Summary

0
Your rating: None

How to Troubleshoot Example

0
Your rating: None

In this second installment of troubleshooting techniques at SQL University, I will be covering a couple real-world situations that should hopefully give you some ideas for your next troubleshooting scenario. If you haven’t read my first class lecture, please do so now.

How to Troubleshoot Complex Systems

5
Your rating: None Average: 5 (2 votes)

This is the first installment of troubleshooting techniques at SQL University. I am your host, Chuck Lathrope (@SQLGuyChuck) and will be guiding you through some techniques I use every day. In coming articles, we’ll get into real world examples from my work life as a DBA.

The Ultimate MS SQL Backup Script

5
Your rating: None Average: 5 (1 vote)

I am finally getting around to publishing my ultimate Microsoft SQL Server Backup scripts. All told, it is about 1600 lines of code and it can do just about anything you would need for Native or Quest Litespeed backups.

http://www.sqlwebpedia.com/files/Scripts/DBOPSBackupScripts.zip

Here are some examples so you get idea of its power.

PowerShell Script to Export SQL Schema Definition

0
Your rating: None

Ganesh Kaliaperumal created a script to export schema to files for us to easily compare with WinMerge. Check out the options and modify as needed.
Call from powershell command line like so:
.\GenerateScript.ps1 "Servername" "Adventureworks" "c:\scripts\powershell\"

Opensource for Courseware you say?

0
Your rating: None

Kevin Kline (Twitter|@KeKline) wrote up an article on SQLPASS.org about learning opportunities and opensource education couseware. This was news to me that it even existed and I know a lot about free software! There is a consortium http://www.ocwconsortium.org that has a list of the major Universities that participate, including MIT. Very cool.
-Chuck

My Windows 7 Upgrade Nightmare

0
Your rating: None

My experience at upgrading my HP Pavilion 9500 from Vista Ultimate x64 to Windows 7 Ultimate x64 was the worst I have read about so far. To help anyone who had my issues I documented all my fixes and posted some comments on the net for those who had same issues.