Category Archives: Blog

Finding the Attribute

I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working with XML is not my favorite. I know I can get the GUI in SSMS 16.x to show me events, … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Quick Tips–Using ii in #SQLPrompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself to use a few of these and not just start to type with your old habits. This quick tip looks … Continue reading

Posted in Blog | Tagged , , | Leave a comment

More Azure Database Creation in Powershell

I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at least from a cost standpoint. Since I’ll probably use this a bit more as I flesh out some CI/CD, I … Continue reading

Posted in Blog | Tagged , , | 3 Comments

Restaurants At Summit

At the PASS Summit this year, there won’t be a Thursday night party. I think that’s fine, as it never seemed like a highly attended event, and the costs are high. That means that Thursday night is open, and I … Continue reading

Posted in Blog | Tagged | 21 Comments

Quick #SQLPrompt Tips – Expanding Wildcards

I tend to try and get code on the screen quickly and then start to remove things. I’m a visual person, and it’s helpful for me to see some tables, joins, filters, and columns as I’m structuring a query. One … Continue reading

Posted in Blog | Tagged , , | Leave a comment

T-SQL Tuesday #82–Azure SQL Database

It’s T-SQL Tuesday time and this month we have Jeffrey Verheul giving us the topic of the cloud, or Azure SQL Database. It’s a good topic, given how many people are talking about working in the cloud. There are also … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Bringing Database Devops to DevConnections

Another alliteration post. Maybe I’ll make all my titles tongue twisters to test your talents? This is my new favorite session. I’m slated to deliver this at a few different conferences this fall, and hopefully you’ll come see it in … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Bringing DevOps to the Database

Abstract: DevOps is a hot topic in today’s software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can … Continue reading

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

Learning All About Always Encrypted at DevConnections

Like the alliteration in the title? I almost removed it, but decided it had a nice ring. Maybe that should be the title of my IT/DevConnections (Oct 10-13, 2016) session other than End to End Always Encrypted in SQL Server … Continue reading

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

Team Purple

This is Down Tools Week at Redgate Software, and I’m visiting the office. I had hoped to dive into a team and participate, but scheduling and other commitments mean that I’m only working with a team part of the time. … Continue reading

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