I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to always get things done in an efficient manner, so I’m trying to learn more. One way is by reading, a lot. I’ve read a number of management and leadership… Read more
The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies of your database. Should there be a hardware or software failure that would cause the primary replica to go down, your database gets moved to one of the secondary… Read more
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to do a little extra work. This video (with bad lighting at the start) shows how to get the job done.
Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder when we’re going to start to see some of this cool stuff within SSMS. What cool stuff you ask? Well, let me explain. Let’s start with a query:
My adult years started with a pretty thorough education in physics thanks to Uncle Sugar and the Navy Nuclear Power School. The laws of thermodynamics were carved into our brains (along with… Read more
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my brain and relax a little. Instead of relaxation I found myself pacing back and forth in front of the television, gesticulating wildly, with a string expletives coming out… Read more
The greatest part of my job is that I get to travel all over the world to present different technical sessions. But, it’s not the presentations that make it cool. It’s the fact that I get to meet people. I get a chance to hang out with my #sqlfamily. I… Read more
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because of all the fantastic people writing and the topics that were covered. I reviewed Chapter 12 a few weeks ago and I’ve been meaning to get this chapter, Big Data for… Read more
I earned my nickname. I’m proud of it. I am the Scary DBA. I don’t really like to advertise my other nickname, Rant (get it, Grant shortened to another word). I earned that one too. I’m not proud of it at all. I got that one because I sometimes don’t… Read more
In just a couple of weeks I’ll be flying down to Richmond, VA to speak at SQL Saturday #187. I’ll be presenting two topics, Backups for the Accidental DBA and Query Tuning in the Clouds. It’s going to be a great event with a bunch of excellent speakers. If… Read more
Want to start a fight between a bunch of DBAs or database developers? Ask them where the comma should be placed between columns in a SELECT statement. It’s actually a little disturbing just how much emotional value people place in this. Almost as good, tell a database developer you don’t… Read more
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the world. I could go into a dark closet (a well-lit cube, but hang with me here) and hide from everyone (except the people in the cubes next to me, my… Read more
I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats. Nothing in a search directly against MSDN either. So, let me introduce you to a new DMO, sys.dm_db_wait_stats.
It’s a dynamic management view since it doesn’t require any input. The… Read more
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming SQL Saturday events (first one is SQL Saturday #177, Silicon Valley). If you scroll to the bottom of this previous post, I mentioned that there were clearly differences… Read more
In my previous post showing how to get to execution plans in the Database Management Portal, I showed that it’s pretty easy to put a query in a query window and get the execution plan. This allows you to understand query behavior in order to tune your T-SQL or your… Read more
I was very privileged to get the opportunity to write a chapter in a book with some of my friends and SQL Family, Pro SQL Server 2012 Practices
. Just as each of us took a chapter to write, each of us going to take a chapter to review. But,… Read more
I heard about this new law that was passed to prevent employers from asking for your social media passwords. After the laughter stopped, I realized that, maybe, this would be needed. Not because I need the government to help me manage my interactions with my employers and potential employers.… Read more
If you’ve been working with the Azure SQL Database portal, you know that you have a query window. Within the query window you can run queries against your server. You’ll get back results, timing, everything you need to observe behavior within the system. What’s that? You never heard of this?… Read more
I have lists. Lots of lists. I even have them in different locations sometimes. Some of them are carefully written down in my notebook, others are typed into OneNote and I’ve been experimenting with Remember the Milk and Trello (Trello is winning). These lists include ideas for presentations, blogs, articles.… Read more
By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a set of triggers. The triggers are defined as
- If 0 rows – Any data added leads to a statistics update
- If < 500 rows – 500 rows added causes a…