Archives: January 2014
Day 14 introduces us to Windows Management Instrumentation (WMI). Since many people might not be familiar with WMI, the chapter spends… Read more
Today I woke up to find that Thomas LaRock (blog | twitter | linkedin) has added me to his SQL Server Blogger Rankings list. WOW! I’m completely honored to be listed among this world-class list of the best bloggers in the industry. He created a new section on… Read more
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more
Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He built it by grabbing the individual event feeds and I’m guessing some scraping to come up with a file that is useful. Kudos to Kendal for doing this, it fills… Read more
For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day (hosted by my company element61), I read the book Master Data Services 2nd edition by Tyler Graham.
I had almost no prior experience with MDS up to this… Read more
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of anything. It looked cumbersome, I didn’t always understand how sample scripts worked, and it was just easier to use the various other Windows tools to accomplish tasks.
However as… Read more
If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we could answer in the time left, will try to do some follow up posts in the next week or so to answer them (and feel free to post questions… Read more
I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that they all used Powershell. None of them had failed recently or been changed recently, and the same code executed fine on many other instances in the same time frame. Here… Read more
In my last post I showed a query to identify non-unique indexes that should be unique.
You maybe have some other indexes that could be unique based on the data they contain, but are not.
To find out, you just need to query each of those indexes and group… Read more
Today is the final day for the Power BI Contest voting and I could use your help to move on in the competition! Please take a moment and vote for my video here http://tinyurl.com/PowerBIDevin
Thanks for voting! Read more
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding Friday afternoon) and generally unwind. Your worries seem to drift off until there’s a bang on the door…there’s been an issue in Production and you need to investigate. You heave… Read more
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 41,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 15…
You may first notice this because Database…
SSDT 2010, 2012 with TFS integration brought about a couple of different options when you are looking to version your database projects. Before deciding on how you should version your projects, you first have to ask what you are trying to accomplish through versioning. Is this simply an audit trail,… Read more
Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class is being offered in Reston, VA, May 19-23 2014. Andy is one to the top guru’s… Read more
Andy Leonard (b | t | l | f), a good friend of mine from Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class is being offered in Reston, VA, May 19-23 2014. Come learn from the… Read more
SQL Server is a fairly big and complicated product. There are quite a few areas that you can study, the database engine, Analysis Service, T-SQL development, and many others. As you delve into each of these areas, how do you know when you’ve studied any area… Read more