Category Archives: Blog

What is Projectsv13 in SQL Change Automation?

I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting up a new PoC (Proof of Concept), they were confused about why there is a new entry in their list … Continue reading

Posted in Blog | Tagged , , | 1 Comment

A Summit Contest for registering by Sept 22

If you haven’t registered for the 2018 PASS Summit and plan to go, you might press to get registration done this week. Next week prices increase, but this week you can save. There is a promotion from PASS that will … Continue reading

Posted in Blog | Tagged , | Leave a comment

Deleting a User that Owns a Schema

This was an interesting question I saw posted recently. Through SQL Server 2000, trying to delete a user that owned objects was a pain. We had to actually rebuild all the objects, which was problematic. With SQL Server 2005 and … Continue reading

Posted in Blog | Tagged , | Leave a comment

Learn about SQL Source Control in Redgate University

I love the SQL Source Control product from Redgate. It’s not perfect, and it can be slow to run at times, but the simplicity of what it does, of getting my code quickly and easily to a VCS is fantastic. … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Importing Flat Files in SSMS 17.x Works

One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis. For some reason I constantly seem to get files that the import wizard keeps having issues. On top of that, … Continue reading

Posted in Blog | Tagged , , | 2 Comments

SQL in the City Summits–Coming to New York, London, and Chicago

I love New York. Every time I get to travel to the city, I get excited and look forward to the trip. I was able to spend a night in Brooklyn earlier this year, touring a college with my daughter. … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Redgate University is Growing

There isn’t a degree to be gained, but you can get a lot of information about Redgate products at Redgate University. This is the place to learn how to best use the products. This is a work in progress and … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Discussing Database DevOps with Gene Kim

I’m really excited for this webinar. Register today for the Sept 25 webinar  to learn more about the 2018 State of DevOps report. I read The Phoenix Project a few years back and I’ve been following Gene Kim as one … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Watch SQL in the City Streamed September 2018

I’m over in the UK and we have SQL in the City Streamed tomorrow. This is our September edition, and Grant, Kathi, and myself are prepping today. We also have a special guest this time, Rob Richardson. Rob is a … Continue reading

Posted in Blog | Tagged , , | Leave a comment

T-SQL Tuesday #106 – Trigger Headaches or Happiness

Since I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since I’ve done it twice, but Wayne Sheffield got his third spot last month. Gotta keep up with Mr. Sheffield. Triggers, … Continue reading

Posted in Blog | Tagged , , | 37 Comments