Tonight is the #RedgateRocks party at 1927 Events in Seattle. You’ll need to get a wristband from the Redgate Software booth in the exhibition hall to gain admission, so stop by.
Today’s your last chance.
And if you’re looking for someone to go to dinner with, come to our #sqldinner meetup in the Convention Center lobby at 5:30.
Tuesday was the first real day of the Summit for me, and a long, all day event. First, a lovely breakfast with Micky Steuwe, during which she presented me with a lovely glass art piece she made herself.
I’ll treasure this, as personal, thoughtful gifts are touching. Thanks, Mickey.
Then it was the annual SQL Saturday organizers meeting. I had a short, 5 minute talk about trying to create slimmer, more affordable events. I indulged myself with a couple snaps from the stage.
After that it was booth setup day. I’m not sure I did a lot, especially during the laptop setup since I don’t usually do the fine technical work here. I’m usually involved in carrying things, and with nothing to carry for awhile…
It’s something to see the raw exhibition hall, which is really a construction zone. People are everywhere, working to get various booths assembled.
When it comes together, things look really good and it’s a much different space. That’s good because I’ll spend most of Wednesday and Thursday in there.
I also got to go prize shopping for the #RedgateRocks event on Thursday. It’s fun to try and be creative and find things people might enjoy. I also got to see our SQL Prompt playing cards, which are really cool.
Then back to the convention center for the evening. Conversations with lots of old and new friends, and even a few selfies.
A very long day, and off to bed relatively early for me. Then up again this morning, a short working, and now time to head back.
One of the promotions this week at the PASS Summit from Redgate Software is a chance to run a year’s supply of coffee. This isn’t just any coffee, but the Death Wish Coffee, full of extra caffeine. Grant Fritchey loves this stuff, and that’s what one lucky attendee will get.
If you want to win, come talk to me or one of the other Redgaters at our booth in the Exhibition Hall. Then you’ll know how to submit your entry.
And if you don’t want coffee, we’ve got plenty of other fun giveaways.
Don’t forget to also pick up your wristband for the #redgaterocks party.
I had the chance to watch dbatools in action recently at SQL Saturday Cambridge. I watched a presentation from Chrissy LeMaire (@cl) that was impressive in how easy she made a number of DDL type changes between instances.
I decided to give some of these new cmdlets a try, since I was impressed with the work done. The first step in trying one is to get the dbatools module. If you go to the dbatools.io site and click the download link, you get great instructions.
The first thing I did was start a command line as an administrator, then run Powershell. From there, it’s a simple “Install-Module dbatools” command. As you can see below, you’re asked if you want to actually do the install. If you do, then things just work.
Let’s test.
First, I’ll type “copy-sql”, as shown here.
When I hit TAB, I get the first matching item. Hmm, I’ve never seen Copy-SQLAgentCategory. Not that I’d ever done this, but this is certainly going to be simpler than digging through DMVs or reading BOL.
Hit TAB again and get the next Copy-Sql command.
In fact, there are lots of Copy-, Export-, Test-, Get-, and more cmdlets. It’s a very handy list, and the types of things I’m stunned Microsoft just didn’t provide.
I’ll be digging in a bit more and looking at how some of these items work, as I suspect these will be invaluable for DBAs that need to manage and migrate various settings at any scale across systems.
