Latest Blog Posts
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
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s.
This is fantastic for anyone who works in SQL… 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
- Using Encryption To Protect Your Data From Alien Abduction
- Building (for FREE) a Virtual Server for SQL Demos
SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or Hekaton). In-memory OLTP lets you move tables from your traditional, disk based, storage and moves them directly into the memory (RAM) of your SQL Server instance. Traditional storage throughput and… Read more
Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I get down there at least once a year, and it’s been only once a year for the last few years. Far too busy, and I’m sorry for that, but I… Read more
In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download the materials from my presentation here:
The post The Truth About Index Fragmentation appeared first on .
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 going to review dimension tables in more depth.… Read more
The US government’s illogical screeds against better personal encryption for data and communications is well documented. Then comes this reported communication:
I’m hoping the quote given in the article is completely out of context. However, previous statements,… Read more
I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post
You can vote for me at the following URL:
Note… Read more
I agree. Continuous Integration has issues in the real world, at least it probably does in many companies. The more tests you have, the more likely you refactoring or changes will break something. The more things break, the more people will look to leave them alone, deferring the "fix"… Read more
My first speaking date of the new year is scheduled. I’ll be at the SQL Server Konference 2015, near Frankfurt, Germany. Red Gate arranged things, and I’m looking forward to heading over and renting a car to drive in Germany.
And speaking, of course.
I don’t know the agenda… Read more
I wrote about the Template Explorer, which comes with the SQL Server tools and is visible in Management Studio (SSMS). It’s handy, but there are limited code items in there. What if I want more?
That’s easy. Suppose I decide that I often need to create procedures with the EXECUTE… Read more
I have previously blogged about the Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference Architecture and Appliances). That was version 3.0 of the reference configuration that was for SQL Server 2008 R2. Released a couple of years ago was version 4.0… Read more
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject.
You all know I love examples so without further ado here we go:
Using data from AdventureWorks2014
So, enterprise data integration! Or…
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on SQLSkills.com or maybe you have used sp_blitz and received the Blitz Result: No SQL Server Agent Alerts Configured and like a good and conscientious DBA you have set them up. Read more
As a follow-up to my post on being at war, cyberwar:
If the experts are correct, this trend is only going to continue. Reading the article and others on the same situation, they all note that the unclassified email had been hacked, but not classified. That’s… Read more
Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful for to write a blog post and link back to his. With Thanksgiving on the way the picture is painted perfectly; I can hear now as family… Read more
I don’t care what technology or technologies you enjoy using in your daily job. If there’s an enthusiastic community behind it, you need to become part of it. Your job and career will be better as a result.
I’ll start this personal post with a mixed tale from my childhood.… Read more