Archives: August 2013
I have been absent from this blog for the last few months. For those who have noticed, I’d like to offer my apology and also provide an excuse. I hope that co-authoring a book is a good enough excuse.
For the last few months, I have been working on the… Read more
I could tell you a story about Green Day's cover of John Lennon's classic "Working Class Hero" that you wouldn't believe. (It's too crazy.) But that doesn't really matter any way.
Here is something that does matter: there is nothing wrong with being a DBA.
I have encountered… Read more
It seems fitting with the anniversary of Martin Luther King’s “I have a dream” speech that I would write about discrimination this week in my piece “Stunned”. There’s a long discussion over at SQLServerCentral, and along with a phone call with a friend, I thought a bit about… Read more
Thanks everyone for attending my free webinar on Introduction to Power Query on August, 27, 2013. If you were not able join for the live event you can now watch the recording here. This was part of an ongoing webinar series by Pragmatic Works offers every Tuesday and Thursday… Read more
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction to SQL Server Performance Tuning training opportunity for you in Pittsburgh on September 13th. It will be given as a PreCon for SQL Saturday #250 in Pittsburgh. Konstantin… Read more
I am excited to be able to tell you about an all day seminar that I’ll be putting on prior to the Dallas SQL Saturday #255. The seminar will be on November 1, 2013. It’s called Query Performance Tuning in SQL Server. We’re going to cover the topic… Read more
I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an appropriate practice exam or two.
Just a point here. When I get a question wrong I review the SUBJECT I get wrong, I don’t just memorize that particular answer. I… Read more
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there is no corresponding setting to remove statistics that are no longer necessary. Unless explicitly managed by the DBA these statistics could be causing excess resource usage.
Create a… Read more
VMworld 2013 is this week in San Francisco, and some exciting details about the next version of the vSphere suite, version 5.5, are starting to trickle out.
From my perspective, the biggest announcements so far are as follows:
- The maximum size per VMDK and RDMv disk is now 62TB (up…
Every week I get a bunch of emails from recruiters about jobs that I am not qualified for (see Low-rate recruiters – The bane of my existence). Some obviously use keyword searches and just spam any person who has that keyword in their profile (i.e. I have Microsoft Dynamics… Read more
It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people had for learning Azure (and AWS for that matter) is that they had to register with a credit card and actually put their own money on the line to try… Read more
SharePoint SSRS “The permissions granted to user ‘Domain\User’ are insufficient for performing this operation”
Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with my SharePoint environment after a restore did go wrong. I was planning on blogging a bunch of it and thanks to time constraints I had to just get it backup… Read more
DBAs rarely use the full potential of sys.dm_exec_query_stats. It’s common to see the queries for looking at the most expensive queries according to any of the stats contained within the current cache, which is great to see. However, if you grab snapshots of this information the proper way then you… Read more
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one of the most powerful yet neglected products Microsoft has to offer. The ability to extend it with your own algorithms is in turn the most powerful yet neglected… Read more
This post explains the simple steps to identify a duplicate indexes in all the databases. The duplicate index are more than one indexes that differ only by it’s name but consist of identical fields internally. It generates overhead when performing updates, inserts or deletes, require lot of resources for rebuilds,… Read more
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and speak at the third annual SQL Saturday event there. I’ve been invited to speak at each of their three events, and I’ve been impressed with each one of them so… Read more
If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database Encryption Key (DEK). If you follow my instructions, then you have one.
If you didn’t make a backup, or you have just discovered a TDE database, make one now,… Read more
It’s Monday, it’s time for weekly round-up #46. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting. While these links aren’t the answer to life, the universe, and everything, they do… Read more