Red Gate

Guest of @RedGate at #DOES20

Haven’t blogged in a bit, and I definitely need to get back to writing. However, just wanted to post a quick note that I’m super excited to be presenting a guest session with RedGate Software‘s Grant Fritchey at the DevOps Enterprise Summit. I’m very excited about this for multiple reasons:

  1. I love this conference; DOES is very inspirational, and there are lots of great speakers and content. It’s focused more on the technical goals than the actual tools, so it’s a good fit for where i am career wise.
  2. I love RedGate Software. Their company is simply an amazing producer of tools for the database community, and they’ve been very supportive of #sqlfamily and #sqlSaturdays for a long time. I’m stoked that they’re expanding their reach.
  3. Grant‘s ok. (Really, he’s a great guy and a lot of fun to talk to).

See y’all in virtual Vegas. Registration for the conference is half-price through August 31; it’s a great deal at $325.

Checking for #RedGate SCA databases

We’re starting a large scale conversion of our development processes with some very old database servers. Some of these databases were developed over 10 years ago, and they were never checked into source control. As our team develops new features, they’ve been using Red Gate’s SQL Change Automation to develop database projects along side their applications; it’s an impressive tool, and we’re getting ready to tackle older databases in an effort to improve our code base.

But, first, we need to determine what databases are already source control and which ones are not. Most of these databases and applications are minimally documented, so most of our development team doesn’t know what’s actually in production. To discover what databases are already part of SCA, I created a simple SQL script. It looks for the existence of the [dbo].[__MigrationLog] table, an artifact of the SCA process. I can then tell when a snapshot was last deployed, and what version was given.

CREATE TABLE #tmp (dbname varchar(1000), completedate Datetime, version varchar(200))

DECLARE @sql varchar (MAX)

SET @SQL = ' USE ?;
If exists (SELECT * from sys.tables t WHERE t.name = ''__MigrationLog'')
SELECT db_name() dbName, MAX(complete_dt) completeDate, MAX(version) version
FROM dbo.__MigrationLog
'

INSERT INTO #tmp
exec sp_msforeachdb @SQL

SELECT *
FROM #tmp

DROP TABLE #tmp

Friend of Red Gate 2018 – @redgate

I’m super excited to have been named a Friend of Red Gate again in 2018; I often wonder why they keep letting me back in because they do so many super awesome things with so many super awesome people.  However, I’m grateful as always.

They are an amazing company, and have always been very supportive of the SQL Server community.  Thanks so much for bringing me along on the ride, y’all.

SQL In The City Atlanta, Oct 11, 2013

SITC13_Banner_300x250_SpeakerJust a quick note to say that I’m super excited to be presenting at the Red Gate SQL In the City event in Atlanta this year; I’ll be covering some of their development tools (many of which I use daily).  As far as I know, there are still some seats left, but I wouldn’t count on them being available too much longer.

It’s free, and you’ll get a chance to hear lots of great topics presented by Grant Fritchey, Steve Jones, and Tim Radney, as well as me. Click on the image for more information, and I hope to see you there.

Couple of upcoming presentations

I know; I suck at blogging.

Anyway, I have a couple of upcoming presentations this month, so I figured I needed to get back and gear and at least post a notice about them.  First, I’ll be presenting at A Bunch of Devs (http://www.meetup.com/A-Bunch-of-Devs/) on the Red Gate development suite of tools.  Funny story; I actually work in that building.  The organizers reached out to Red Gate to see if they had a Friend nearby.  I guess I qualified.

Next, I’ll be back at SQL Saturday Atlanta to present on Biggish Data; this is the first Atlanta SQL Saturday that I actually had almost nothing to do with (as a chapter leader, I helped with some basic decision, but very little).  I’m excited that it’s continuing to thrive.  Says a lot about the infrastructure that PASS puts behind these events; they just need a little help from the local chapters, but they don’t rely on the same person getting burned out year after year.