Monthly Archives: May 2016

Running Multiple Threads Quickly

Posted on May 31, 2016 by

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

Posted on May 31, 2016 by

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

Posted on May 30, 2016 by

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

Posted on May 30, 2016 by

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

Posted on May 26, 2016 by

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

Posted on May 25, 2016 by

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

Posted on May 24, 2016 by

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

Posted on May 24, 2016 by

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

Posted on May 24, 2016 by

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?

Posted on May 20, 2016 by

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 , ,