Latest Blog Posts
Are you a Social DBA? No I don’t mean that you are a DBA and attend a myriad of merry mixers, networking events, post SQLSaturday soirees, or PASS parties. (Yet that’s a great way to make connections, and build your professional database of career-complimenting contacts.) I’m talking about putting… Read more
You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking about deployed sessions again. And it may even be considered metadata as well. This time around, the metadata I will be discussing is a little bit different but will build… Read more
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it can be kind of hard to remember which connection is which. Fortunately all of the information you need is readily available.
Connections in the Object Explorer
Notice that for each… Read more
If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and me in the Washington, DC area for our 4-day Advanced SSIS classroom training course. This course will be held December 7-10 in Reston, VA (just outside of DC). I’ve… Read more
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report. You can get the scripts and reports here
This gives a quick overview of the… Read more
I've had this title before as an employer's standard, but lobbied against it. I instead prefer separating job titles from project roles.
"Architect" as an IT role descriptor carries an appropriate level of technical expertise and…
Last week I did something that many people have already done. However this was my first experience, and I really enjoyed it. We’ll see if I get to do it again.
We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim Ford – for participating, and congratulations to Jen, Ryan, and Tim for being elected. PASS surely can’t survive without volunteer leaders and it’s great to see that we continue… Read more
In the previous article in this series I shared the basics around assembling an XEvent session. The method used in that article was via TSQL script. In this article, I will introduce the Extended Events GUI. While I prefer to use TSQL to create and manage my sessions, the… Read more
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have the operator similar to ISNULL () in T-SQL. To be more exact, there was such an operator, but it works in… Read more
I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on Azure VM/SQL Server related topics.Here is the 1st post –
“Changing the size of a VM”
When creating an Azure VM to host your SQL Server, you have an… Read more
Here's the slide deck for my presentation, which combined two topics I wanted to talk about. The first, I Was Once…
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I ran across a question on Facebook, of all places, the other day. Someone had asked a friend how to return a value from a procedure and assign… Read more
Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is good reason for that. The components I have discussed are essential pieces of Extended Events and are critical to building useful sessions.
Previously, I only touched lightly on the… Read more
People ask me all the time how to become a DBA. This is a topic that so many colleagues of mine write about, and talk about in their professional development tracks. The more important question is once you “are” in the role of DBA, what to do next? Read more
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in comparison with Standard Edition. One of these improvements is Advanced Scanning, which allows multiple scans to share one physical read from… Read more
AlwaysOn Availability Groups is a great technology that centralizes the management of High Availability, Disaster Recovery and Scale-Out. However, in many cases, the good old Database Mirroring is just good enough (and in some cases, better):
Database Mirroring can work in Standard Edition
Database Mirroring is supported in both… Read more
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as it can ease some of the escaping of strings.
However, I normally use it for table/column names, and so hadn’t ran into a “gotcha” of this function until today. Read more
To help with this scenario (it is pretty specific):
You have a table that has columns that you do not know about when you create the dacpac, possibly you have a customer who modifies your schema after you deploy. If you deploy your dacpac those columns will be dropped which…
Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training, FREECON if you will, in Seattle as a prelude to the PASS Summit of 2015. You can read all about that here, with registration being here.
While I… Read more