Last week I posted the first part of this series. I thought it would be a good idea to give a little follow-up on how my foray into Powershell as I attempted to download this […]
Tag: SQL
Powershell, Me and the MCM
If you haven’t heard yet, Microsoft has made some significant changes to the MCM program. The changes make the certification more accessible to the masses. You can read more about that from sources such as […]
Tis the Season
This month has been quite the month for change in my family. The changes that we are experiencing did not end with the birth of our baby girl two weeks ago. My employment is changing […]
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post from Paul Randal (Blog | Twitter) about wait stats. The thing that strikes me about this […]
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed requirement. I was attempting to create […]
SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago and am finally getting around to putting it together. The idea came about while I […]
DB Maintenance
About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server. It seems to be a rather comprehensive list. If you don’t have some sort of […]
TSQL Tuesday Indexes and Blobs
How does one find what columns were LOB columns in the database. I knew I had some past blog posts about various aspects of LOBs, but I had never broken it down to find the columns in the LOB. Even better was that I wanted to know what columns were in what index that were also a BLOB.
Star Struck
Have you ever run into an error and been puzzled as to why that error occurred? Recently I have been working on a project to backfill a development and QA environment. These environments are essential […]
Declare Scalar Variable
Lately I have been going through a bunch of maintenance style scripts and fixing them. Along with fixing them, I have also been updating them to work more efficiently and to work in SQL 2008. […]