Latest Blog Posts
The Azure Data Factory is a service designed to allow developers to integrate disparate data sources. It is a platform somewhat like SSIS in the cloud to manage the data you have both on-prem and in the cloud.
It provides access to on-premises data in SQL Server and cloud data… Read more
It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my browser. No, I’m certainly not looking to burn down my house. In fact, wait here while I clear my search history, just in case.
For the sake of argument, let’s… Read more
I really enjoyed writing this post last year and honestly still enjoy reading it myself. And since tomorrow is a holiday for a lot of people (I’m in America so I get to make that assumption) it seemed like a good time to bring it out again.…
“How did you like your convention?”
“How was your trip?”
“What did you learn?”
“Where did you go for a week?”
“Who did you meet?”
“Talk with the vendors?”
“What is PASS Summit?”
November 25, 2014 - Good news in Gotham! Well you asked for it! You wanted it! You waited for it! And now it's finally here! It gives me great pleasure to announce the return of SQL Saturday to New York City! Save the date, May 30, 2015! Just…Read more
A long time ago I worked in a large corporation where we managed lots of servers, each of which performed a variety of different functions. Some were Exchange, some SQL, some file servers, etc. and they would come and go at a frightening pace.
We had monitoring in place, but… Read more
sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The objective of this stored proc is to measure the amount of space consumed by database… Read more
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered:
Today we’re exploring fact tables… Read more
1. Do not change collation of TempDB from the SQL Server instance collation.
2. Do not change the TempDB database owner from sa.
3. Do not drop the TempDB database.
4. Do not drop or revoke the guest user from the database.
5. Do not change the recovery model from… Read more
The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.
Those who are facing severe issues with their environment, they can… Read more
The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.
Those who are facing severe issues with their environment, they can plan… Read more
Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.” Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and… Read more
Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So what does that do and why should we care? The primary effect is that if you put a stored procedure starting with sp_ in master you can call it directly… Read more
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data in one place. It can collect data from all of your machines either via SCOM or by using an agent. Once the data is… Read more
Recently, I caught a blog link on LinkedIn, of one SQL Server professional talking about his experience speaking at a SQLSaturday, and I thought I would not only share my own experience, but invite all of you who ever spoke at a SQLSaturday to share yours as well. In…Read more
Have you ever tried to hit a golf ball toward the pin, toss a dart at the bull’s-eye, or chuck a fly at a trout? If you’re like most people, your first attempt didn’t come anywhere close to hitting the mark. Your golf ball may have found the woods, your… Read more
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more