Archives: February 2014
The role of PASS in the community has evolved a lot over the past few years. Back in 2006/2007 PASS was mainly about the Summit and trying to grow new chapters, not a lot of emphasis on doing more for chapters and not much interest in a day based event… Read more
I’m slightly behind here after holidays and some travel. Apparently my pop-up reminder for my own studies bears about as much… Read more
Come join me for this webinar on 3/13/2014 at 11:00 AM EST
The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and… Read more
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience is always a lot of fun to interact with before… Read more
A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… 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
- Cheating DBCC To Fix Index Corruption
- Do You Need A Log Recovery Tool?
- Automated Permissions Auditing With Powershell…
Why wait statistics are important and how you can start collecting them now!
Wait statistics have always been a very important tool in troubleshooting complex performance issues or monitoring the impact of changes on your SQL Server. I use wait statistics daily in helping clients troubleshoot performance issues they are…
If you work in IT, the office becomes your second home. It’s where we make a living, and most of us take a lot of pride in the work we do. We feel good when we’ve put in a successful day at the office, however we also have those days…
This is part of a series where I set up a virtual lab for testing and misc. work. The other parts in the series are here: Building a Virtual Lab with Hyper-V.
I have my disks set up, now it’s time to create my virtual machines. I’m going to… Read more
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.
Download the file and save as SSRSInventory.PS1.
It has five mandatory parameters
- InputFileName – Text File contains a list of SQL Servers -C:\Server.txt(Example)
- DirectoryToSave – Folder…
We covered three large project templates, including an end-to-end application and Data Warehouse, a SharePoint-list driven Data Warehouse, and an "Access Jailbreak"…
Tonight, at 9 PM Eastern, I’ll be participating in a #datachat on SQL Server security. It’s sponsored by Confio (now part of Solarwinds).
You can find more details about the #datachat here.
How can you participate? Simply open up a search for #datachat and participate in the community Q… Read more
Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in a distributed fashion (via MapReduce) across clusters of commodity hardware on a storage framework (HDFS). Hadoop uses a simplified programming model. The result is Hadoop provides a reliable shared… Read more
The first sign of spring in Florida is the leaves falling from the oak trees. Tons of leaves, leaves everywhere, definitely a pain to keep up with, yet it’s worth it for the next part – in the next week or so I expect – when the large oak in… Read more
I spend quite a bit of time writing about query tuning on this blog. I’ve written (re-written and am actively re-writing) books on query tuning. But what I like most is talking about query tuning. I love giving sessions at various events on different aspects of query tuning, but, what… Read more
I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for free per month so I can review it on my blog. This works in both ways of course: I get free eBooks while they’re still hot from the press… Read more
I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused or under used indexes (or even heaps). It would have to be in the top shelf of many DBA’s toolboxes. So I was alarmed when I came across this post Read more
If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes along with service pack 1 of Office 2013, which you can download here. There are two ways of getting this update:
- Downloading and installing service pack 1, aka the…
SQL Meetings are training events for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are… Read more