Monthly Archives: May 2016

Running Multiple Threads Quickly

Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of work my system was doing by executing a number of queries simultaneously. There are a variety of ways to do … Continue reading

Posted in Blog | Tagged , ,

More Overloads

I was attending the SQL Nexus and SQL Bits conferences recently in Europe. These were launch events for SQL Server 2016, and the keynotes given by Microsoft included the overload of yet another SQL Server term. This time ACID was … Continue reading

Posted in Editorial | Tagged

The Lighter Side–Morning at the Redgate Office

I was chatting recently with someone about the coffee machines at Redgate Software. We have 4 of them, all located in the downstairs lobby, which provide a way for people to take a break from their desk or between meetings, … Continue reading

Posted in Blog | Tagged ,

Great Developers

This editorial was originally publised on March 12, 2012. It is being re-run as Steve is on vacation. Is a great software developer worth 100 average ones? On one hand I think there are some good arguments that it’s not … Continue reading

Posted in Editorial | Tagged ,

Just a week to SQL Saturday in Pensacola

Next week is  SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s free SQL Server training, and a great place to vacation. There are a couple pre-conference sessions available as well if … Continue reading

Posted in Blog | Tagged , , | 1 Comment

A Basic Recursive CTE and a Money Lesson

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. When I was a six or seven year old, my Mom asked me a question. She asked if I’d … Continue reading

Posted in Blog | Tagged , , | 8 Comments

Changing Your PASS Credentials

I got an email today from PASS, noting that credentials were changing from username to email. That’s fine. I don’t really care, but I know I got multiple emails to different accounts, so which account is associated with which email? … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Recharging

It’s that time of year when many people take vacation and get away from work for a bit. I’m going to join in, taking a few days off this week. I was off yesterday, with family in town for my … Continue reading

Posted in Blog | Tagged

The Clustered Index is not the Primary Key

I was reading through a list of links for Database Weekly and ran across this script from Pinal Dave, looking for tables where the clustered index isn’t the PK. It struck me that this is one of those facts I … Continue reading

Posted in Editorial | Tagged , | 1 Comment

What’s Your Test Plan?

I ran across a post on upgrading a SQL Server instance, where the original poster (OP) was asking about a document to upgrade from SQL Server 2008 to 2014. That’s a big ask, especially as not many documents tend to … Continue reading

Posted in Editorial | Tagged , ,