I know a few people in the SQL Server community who have been involved in Scouting. A couple of them have taken or helped lead Scoutings leadership training program known as Wood Badge. It’s an amazing program. I won’t even attempt to tell you what Wood Badge has done… Read more
When I attend sessions at events, I try to mix it up. I’ll go to a session that, really, I probably will never use the information, just to expand my knowledge level a little. I also go to sessions by the masters so that I can try to expand my… Read more
Columnstore indexes are fascinating and really cool. Unfortunately, they’re adding an interesting new wrinkle to an old problem.
What’s the Cost Threshold for Parallelism set to on your server? If you just said “The whatsis of whositz?” then the value is 5. The cost threshold is the point at which… Read more
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international laws regarding SPAM. This has been something of an education, so anything I say wrong below, it’s because I’m wrong, but not malevolent (at least in regards to this… Read more
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that I included a chapter on it in my query tuning book (all updated for SQL Server 2014 by the way). Let me tell you why we need to pull… Read more
I heard about Connected from a show on NPR (Yes, I listen to NPR, why do people keep saying that?). It was right after another segment talking about how positivity affects your mood and your ability to think and act in a clear fashion. I’ve long been a believer in… Read more
No, that’s not a threat. It’s an offer to help out.
Redgate Software is very serious about the efforts we’re putting into creating the tools needed to support your Database Lifecycle Management (DLM) processes. DLM is a vital part of supporting both Agile development methods and moving towards an automated… Read more
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so far, little in the way of suggestions for how to take advantage of this information. That however doesn’t change my plans around working on positive thoughts and emotions as… Read more
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give me all the rows from this table and only those rows that match from the other table.
But, wouldn’t this logic work just as well:
Give me only the…
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those are the questions that make me stop presenting in order to take a note so I can try to answer the question later, usually in a blog post. Guess where… Read more
I finally got out to some community events last month and got to see a bunch of great speakers. Not that you don’t see great speakers at paid events, you do. It’s just that they’re usually professional speakers and I want to encourage others when I can.
The Speaker of… Read more
Let me start with an important note: I am voicing my opinion here as an individual, not an… Read more
It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two of you may have noticed that the SQL Saturday web site was down for a moment. Well, three days. Joking aside, this was a serious problem, but my… Read more
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on their 2014 instance in order to validate performance after an upgrade. The plan was to use query hash values. I was curious, so I set up a quick test. First,… Read more
I spend many of my evenings researching and writing. Sometimes it’s writing new books. Sometimes it’s fixing and rewriting old books. Occasionally it’s a blog post like this one. Lately, it’s been a series of articles for SQL Magazine that are all about the new functionality available in Azure SQL… Read more
The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one thing that I have to access regularly is the firewall settings for my Azure SQL Database. I do demos from all over the place. I never know what my… Read more
I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.
The concepts are simple and science based. Positive emotions help your clarity of thought. Further, your moods and actions extend out through your network to the third layer. With that in… Read more
If you’re starting the process of moving your databases in Azure SQL Databast to v12, you need to do one thing. Make sure you have SQL Server 2014 CU5 or better installed on your machine with Management Studio (current list of updates). Otherwise, like me, you’ll be looking… Read more
I’ve posted previously about how a foreign key constraint can change how a SELECT query behaves. Logically that just makes sense. But other types of constraints don’t affect execution plans do they?
Let’s take this constraint as an example:
ALTER TABLE Sales.SalesOrderDetail WITH CHECK ADD CONSTRAINT CK_SalesOrderDetail_UnitPrice CHECK…
One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them and I’ve gone to three (had to miss last year, scheduling conflict). It’s a fantastic event and Mark Ginnebaugh (b|t) does a great job putting… Read more