Latest Blog Posts
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your boss on the idea and get registered. It’s only the largest Microsoft Data Platform event on the planet. There are over 200 sessions given by some of the most knowledgeable… Read more
Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events.
Having the opportunity to work alongside these vendors has been both a learning experience for myself along with forming new… Read more
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 at one of those areas when inserting data into tables. Read more
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) linked to my post Comparing Two Query Plans. Since I always find that interesting I followed the link and wound up at his post 3 Reasons to?… Read more
Most of the time, while working with SQL Server, the transaction log files usually grows due to numerous reasons. Out of which one such reason is that there is already existing allocated space to the file in the SQL Server. This can be caused due to natural increment in… Read more
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what happened. Can Query Store tell us?
My first blush response is, no. Not really. Query Store keeps aggregate performance metrics about the queries on the database where Query Store is… Read more
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who successfully landed his A320 jet on an icy river after losing both engines shortly after takeoff. I enjoyed the movie for its main story line but also for some of… Read more
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve been collecting a few links with examples and instructions I have been using to improve my skills.
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…