Taking Script of Sql Server Jobs for Migration

when migration sql server database to a new server, i use the following powershell script to take all sql server...

Red Gate’s SQL Source Control and better SQL objects organization

Red Gate’s SQL Source Control (RGSSC) is very decent solution source control solution for database development. I am personally using...

Creating A User Group Daily Paper

A few months back, I was asked if there was a way that the information shared by the Twitter users...

find...underlings...

find.....underlings.....
searching......
underlings found......

I recently was given the task to create a stored procedure to find people who are under other people...

Three must-have tools you should use everyday

There are three tools I use every day without exception.  They all save me valuable time in surfing the net:
Delicious...

Presenting For South Florida SQL Server UG Tonight

Tonight, June 22, at 6:30 PM EDT I'm presenting Paging DR Availability, You're Wanted In The Recovery Room for the...

TransactionLog Internals

Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file...

Tampa PowerShell Presentation

The presentation material from the Tampa PowerShell User Group 6/21/2011 meeting on PowerShell ETL is available here:
 

PASS DBA Virtual Chapter Tomorrow

Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter. ...

Data Compression in SQL Server

Do you know much about data compression? It seems that quite a few people I meet don’t really understand how...