page contents
Archive | SQL RSS feed for this section

PowerShell and TSQL code to list database information

Let’s say you want to get a list of all the tables in your database, along with their row counts and data space used. This would be really nice to know if you could not get it from SQL Server Management Studio. (SSMS) Well, today you are in luck, because I am going to show […]

Comments Off on PowerShell and TSQL code to list database information Continue Reading →

Be careful using sysprep with Windows 2008 r2 in a cloud environment

First off, this is an excellent post on the new changes with sysprep with Windows 7/Windows 2008r2: http://briandesmond.com/blog/how-to-sysprep-in-windows-server-2008-r2-and-windows-7/ I could not write it better myself, so if you need help with sysprep and all the new changes, please review Brain Desmond’s blog on it. Instead, I want to highlight a key point, when you are […]

1 Comment Continue Reading →

Have a need to port existing SQL Server Agent Jobs?

If you are like me, you have a few SQL Servers that you are managing and sometimes you write a cool job and say to yourself that would be awesome if I could take this job on Server A and allow Server B to run this job as well. Well, a good friend of mine (Jeremy Carter […]

Comments Off on Have a need to port existing SQL Server Agent Jobs? Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.