Archives: September 2016
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
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.
A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following:
- Negative increments can be handy if your identity column has reached the max value of the data type. Reseed to 0 (assuming that is where you started) and set…
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is that a view shouldn’t have an inherent order. Just like any other query. If you want the data from a view ordered then you query the view with an ORDER… Read more
It’s not my fault. I had to be sarcastic. I had to mention the correct Read more
So to start, what’s a BACPAC?
Per the Azure documentation
When you need to create an archive of an Azure SQL database, you can export the database schema and data to a BACPAC file. A BACPAC file is simply a ZIP file with an extension of BACPAC. A BACPAC file…
This is nothing new but it’s still a fun idea.
- The vendor app we just purchased (and are told we must keep) requires the sa password.
- The vendor insists that sa is hard coded into the app and can’t possibly be changed.
- The sa account is the built…
I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers were awesome. There was an amazing amount of learning to be had by all.
My session was called The Accidental DBA, Developer Edition. It is an attempt to start… Read more