Archives: October 2016
Not all selfies, and not enough, but lots of changes to meet people at the Summit this week.
The other Steve Jones (not sure who’s other)
And, of course, one from the Redgate SQL Clone party
Filed under: Blog Tagged: PASS, syndicated
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.
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… Read more
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… Read more
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… Read more
I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a quicker way to write code.
One of the things I think is great is to use the TRY..CATCH structure. I don’t do it enough, but I want to do this… Read more
If you are attending the PASS Summit, or even in the Seattle area, we have a SQL Server pro networking dinner tonight. This is at The Yardhouse on 4th Avenue. This is a buy your own event, but you’ll have the chance to meet with and network with other professionals. Read more
Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years. Once again, we’ve arranged for everyone in Seattle to come join in.
If you don’t have plans for Monday night, pick a time, and join us at the Yardhouse. We’ve… Read more
If you are attending the PASS Summit next week in Seattle, and want to attend a fun party on Thursday night, come by the Redgate Software booth in the expo hall for your #RedgateRocks bracelet. This is your ticket to admission Thursday night.
Walk down to 1927 3rd Ave between… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Suppose you want to audit logins for your SQL Server instance. There are multiple ways to do this, but Logon Triggers have a few advantages. First, they… Read more
I’ll be attending the 2016 Pass Summit as a part of the Redgate Software crew. I’m not speaking this year, so most of my time will be at the Redgate booth, showing you a few tricks and tips with products and maybe convincing you that we can help your company… Read more
One of the things I struggled with a bit was getting test results to appear in VSTS from my builds.
Here’s my original Build flow:
However, when I’d run a build, I got this in the Build summary:
That’s not great, and I knew this could work better, so I… Read more
This is part of a monthly… Read more
On Thursday night, Oct 27, 2016, Andy Warren and I are hosting a game night event at the Washington State Convention Center. This is a low-key, alternative fun event for those of you that might not be attending another party elsewhere.
This year PASS announced that Thursday night would be an open night at the PASS Summit, with no events scheduled. Typically Microsoft has sponsored a party at Gameworks, but not this year. PASS has a list of events at the Summit, if you want to browse. Many of these… Read more
I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want to be well prepared and ready for the events. It’s the least I can do for people who have spent money to attend an event.
I enjoy IT/DevConnections, and… Read more
I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet Manager. I’ll show you how this works.
When I type something, like “cl”, I get a list of things, as shown below..
I see CLOSE, which has “cl” in it,… Read more
This month is an interesting T-SQL Tuesday topic, and it’s brought to us by Andy Mallon, with the topic of the same old issues we’re still dealing with. I think that’s an interesting issue, since I do find myself answering the same old questions over and over.
If… Read more
On Monday, October 24, 2016, there will be a Free-Con in Seattle for those that might not be attending a pre-con before the Pass Summit. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day.
It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.
For those of you that haven’t come in the past, Andy and I aren’t buying you dinner. What we are doing is setting up a time and location for people to come…