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
There you sit, watching TV, when you hear it: “Analysts are predicting massive cold fronts this winter! Learn 12 tips to prepare for winter and the storm of the century tonight at 11!”
“Oh my gosh!” you think, “I’d better pay attention… Read more
What Is The Point of Versioning?
Now, I’m not talking about version control, I am talking about stamping your database with a version number so you can keep track of how many modifications may be made in an environment not completely… Read more
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have aligned. I am sitting in my hotel room in Seattle waiting for the Microsoft MVP Summit to start as a precursor to the PASS Summit later this week.
Just a few… Read more
Why Worry About The Server Name In SQL?
When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong.
Reporting services can break, Connections… Read more
What Are Database Triggers?
Triggers can be implemented to enforce business rules or referential data integrity in database applications.
There are even triggers that allow data modifications to multiple base tables of a view. I have actually used this in the… Read more
What is a Foreign Key?
A foreign key is a link between 2 tables that is used to enforce referential integrity in the database.
For example, if you have an order and a customer table, there is probably a logical relationship between the 2… Read more
I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.
For those that know what this whole MVP thing is there isn’t much more to say other than the headline:
I must be doing something right!
For… Read more
What is the RPO?
And why does it matter?
Join me as I walk through Jefferson Patterson Park’s Indian village and discuss the Recovery Point Objective and what it means is respect to SQL Server.
Location: Jefferson Patterson Park
More info: http://www.jefpat.org/Read the full article here
Recovery Time Objective (RTO)
What is it and why does it matter?
I am actually walking this time! Join me to walk & talk through what the RTO (Recovery Time Objective) is with regards to SQL Server.
Location: American Chestnut Land Trust – South Side Trail: Gravatt Lane (0.72 miles… Read more
Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools.
The simplest way is to select all results and then copy & paste them into whichever… Read more
I am hugely excited to have been selected to present at Live 360, November 17 – 21 in Orlando, FL.
Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current… Read more
Walk & Talk #001 – Unknown or Null Values
Ride with us in this video as we head to Richmond, Virginia to present to their user group.
This is the first official Walk & Talk, but you’ll notice we’re not exactly walking along.
Through this video we talk about and… Read more
Blacklist vs Whitelist
I think just about everyone is familiar to some degree with the concepts of a blacklist and whitelist.
If not, the easiest way I can summarize them is as follows:
A blacklist is a list of what can not access something you… Read more
Is a demo always needed?
One of my more popular presentations I have been doing as of late is my “The Spy Who Loathed Me – An Intro to SQL Server Security” one. What is intriguing as that is is completely demo… Read more
I had an idea a few years back about a training event unlike any other. One where you could bring family, all have fun, and yet still learn about SQL Server from top people in the industry. After years of working… Read more
I just heard that I was selected to present at SQL Saturday in Columbus! I’m excited to be going back, and add another tick mark to the list of events we have been to. In reviewing recent and upcoming events though, I have come… Read more
SQL Server 2014 was officially released in April 1st, 2014. You can download the 120 day Enterprise edition trial version here: http://technet.microsoft.com/en-US/evalcenter/dn205290
As with previous version of SQL server, there are three primary editions of SQL Server 2014 available.
As a some of you may already know, I am now offering SQL Server boot camps with the first one being this July in Washington DC. Over the last couple of weeks since I announced this I’ve had a few questions as to why I am offering a boot camp Read more
What would your reaction be if, one day, all that old data you’ve been holding onto for years suddenly got up and walked out?
I’m not talking about unsecured data being hacked, personnel issues, malware in your network, or even HVAC systems with too much access… Read more