Latest Blog Posts
Express editions of SQL Server Reporting Service, from SQL 2016 on down, cannot connect to Azure SQL Databases. Turns out, getting something for free does have some significant limitations.
For example, you'll see an error message…
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a person and in my career. And the many ways I saw other people grow.
Summit #1 – 2006: Gaylord,TX: I was a visa holding dba-developer at a small shop.… Read more
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out there) identify the exact location of the objects in the environment. The 4 part name follows the convention of <server>.<database>.<schema>.<object>. In most cases, you are only going to use the…
I was riding the elevator up from lunch today, at work. I am relatively new at my job and do not know several people at my workplace – yet. I live in a small town, and quite a lot of them know me as someone active in the local community.… Read more
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 decided to document a bit more about the database… Read more
You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you already had a place via your user group, or before you even started thinking about pulling an event together. Odds are, though, you have been inspired to put on an…
One of my favorite things about this event is the BBQ Crawl the organizers… Read more
I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What changed?
A simple but effective setting in SQL Server Management Studio is using custom colours to identify which server you are about to execute a query on. It’s simple to setup but not everyone who uses SSMS is aware of it so I thought I’d quickly run through the steps here. Read more
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re discussing some data visualization best practices
Data visualization is a hot topic right now, particularly because of the capabilities of Power BI and the… Read more
This is the 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need for Continuous Integration (CI), the central part that Git (my version control system of choice) plays in the whole process and an easy way to use Git in… Read more
In my role as a Data Platform Solution Architect (DPSA) at Microsoft, part of my responsibility is to keep up with all the Microsoft on-prem and cloud data-related technology and trends, as well as non-Microsoft technology and trends in areas such as Hadoop and NoSQL. I work with Microsoft clients… Read more