Latest Blog Posts
On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we will take a closer look at OLEDB waits to help you understand where they come from.
OLEDB or, Object Linking and Embedding DataBase, is a Microsoft…
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
- Which One’s Better?
- Don’t Get Slimed By Bad Parameter Sniffing
- Do You Need A Log Recovery Tool?
With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to display forecasts of World cup matches. An example:
I was wondering if something similar could be built using SSRS. And yes, it is possible and it isn’t… Read more
If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you have a several options. For example:
- You can grant all of the CREATE permissions either to the database itself or to all of the schemas.
- You can add the user…
Azure HDInsight Overview
HDInsight is a cloud based implementation hosted in the Microsoft Azure cloud. It enables you to quickly create, expand and delete a Hadoop cluster installation as your project dictates. For organizations just beginning to see how Big Data could be leveraged to solve business problems. A HDInsight… Read more
Technical conferences have always been a great venue for networking and increasing my knowledge base. Mile High Tech Con will be no different. I would like to invite you to be part of the inaugural Mile High Tech Con which will be held July 24 -26 in Denver, Colorado. Mile… Read more
A few months back I made the decision to leave the relative comfort and security of my permanent role and head into the world of contracting & consulting. Whilst a big decision and change for me, it is something that I’ve long wanted to do at some point during my… Read more
An SSIS question! How’s that for a change of pace? SSIS Column Export is, as you might well surmise, about the export column transform. I used it recently to export a kazillion or so images and thought it would be a nice, middle of the road question. Give it a… Read more
Last week ended up better than expected when PASS decided to release feedback to speakers (selected or not) who requested it. I imagine many did and the feedback on the feedback was surprisingly good – and that is good. That’s a good step and I hope it will be become… Read more
Here is an overview of the articles I published in the second quarter of 2014.
- MCSE Prep: The Integration Services Package and Project Deployment Models—Part 1
- MCSE Prep: The Integration Services Package and Project Deployment Models—Part 2
- MCSE Prep (SQL) – Using Parameters in Reporting Services Reports (Part…
Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. This month, Dev Nambi (blog | twitter) is hosting the party, and he has decided that the topic is to be on Assumptions. Specifically, he wants us to write about:
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community, this means a little party as many of you may already know. This is the TSQL Tuesday Party.
This month represents the 56th installment of this party. This institution was… Read more
Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We’ve been posting some really fun stories with, I hope, a kernel of useful information inside each. Chances are, if your DBA career has been like mine, your worst days don’t involve explosions… Read more
During a recent webcast, someone asked if, in an EXISTS query, it is better to use “SELECT *”, “SELECT ‘1’”, or some other variation. I promised a followup blog post to explore this and try to come up with a definitive answer. This is that post.
All of the examples… Read more
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can be certain that Dev Nambi(b/t) has decided to make Assumptions the topic of the 56th T-SQL Tuesday.
I generally like to start with definitions when discussing… Read more
Fiddler is a free program that will log HTTP and HTTPS requests on Windows. These instructions demonstrate how to use Fiddler to create an archive file (.SAZ) of these requests for troubleshooting purposes using the full version of Fiddler. As an alternative, there is a simplified version of Fiddler available… Read more
Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded to view later.
Database Administration VC
Date: July 9
Topic: How to be a great DBA– sponsored by Dell Software
Registration: You must register…