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 […]
Category: SQLServerPedia Syndication
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 […]
Drumroll Please…
Defensive Db Programming Chapter 10 After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up. I have been working through a chapter by […]
Defensive Db Programming Chapter 08
We are slowly getting to the end of this book by Alex Kuznetsov (Blog). You can find more on this series by looking here. We are now discussing chapter 8 and it is a good chapter. […]
Blogger Awards
A few days ago I wrote about an election that was taking place (ok so it was a week ago at this point). That election was the SQLServerpedia Awards. My first post on that election […]
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today we get to talk about chapter 7 in the book by Alex Kuznetsov (Blog). […]
T-SQL Tuesday #012 – Skills
November is upon us and in some areas this also means that the leaves have changed color. With the change in leaves we also have a change in TSQL Ones…err Tuesday this month. The change […]
November Snuck Up on Me
I should have gotten this post out last week with another follow-up this week. Well, looks like I will have to get a couple out this week to try to remind people. This month SSSOLV […]
My SQLSat54 Experience
In case you hadn’t heard SQLSaturday #54 was Oct 23 in Salt Lake City. It was a dreary opening to the Deer hunt, and a good morning to be inside to learn about SQL Server. […]
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a table?