Chris's SQL Blog

Powershell and Dynamic SSIS (or any for that matter) Config files

• by SQLGeordie

• Chris's SQL Blog

As I imagine that the majority of people who are reading this will have some level of SSIS knowledge, I’ll...

2011-12-05

1,171 reads

Powershell to Script out SQL Server Objects using a CMS list

• by SQLGeordie

• Chris's SQL Blog

I’ve recently decided I’ve got to get with the times and started dabbling with Powershell. Up until now i’ve not...

2011-09-19

1,961 reads

Being an Exceptional DBA Award 2011 Finalist

• by SQLGeordie

• Chris's SQL Blog

On Wednesday 13th July at 16:06 (GMT) I got what could only be described as the biggest shock of my...

2011-07-25

828 reads

NetApp Dynamic Backup Script

• by SQLGeordie

• Chris's SQL Blog

For those of you who’ve worked with NetApp and SnapManager for SQL Server, you will know can generate a scheduled...

2011-06-09

1,152 reads

SnapManager Epic Fail – oh dear!

• by SQLGeordie

• Chris's SQL Blog

An ex colleague and good friend of mine has recently been having trouble with Snapmanager for SQL, anyone had similar...

2011-04-07

671 reads

Why I don’t like NULLs and Nullable Columns

• by SQLGeordie

• Chris's SQL Blog

As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...

2011-03-25

730 reads

Database Mail – Collection of SQL Server Scripts

• by SQLGeordie

• Chris's SQL Blog

As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...

2011-03-21

912 reads

Poll: – Index Rebuild / Defrag, what page count filter do you set?

• by SQLGeordie

• Chris's SQL Blog

After reviewing a number of clients overnight index defrag / rebuild scripts over the years, I’m intrigued to know how many...

2011-03-11

726 reads