Red Gate is constantly experimenting with technology. Because of a long history working within the Microsoft space, a lot of the new experimentation is in and around Azure. One new venture that could be online soon is SQL Lighthouse. It’s a mechanism for dealing with changing structures in an… Read more
I was presenting a session on how to read execution plans when I received a question: Do you have a specific example of how you can use the query hash to identify similar query plans. I do, but I couldn’t show it right then, so the person asking requested this… Read more
Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But, it’s actually hard to break into writing (not that hard, I did it after all). So, when you get the chance to work on a book, if you’re crazy enough… Read more
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM tools. Why do I say this? Because all the operators within a query execution plan serve a purpose. They are there to fulfill a task. Depending on where and when… Read more
When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes, Self, I’m pretty sure it is. Good, I thought so too, self. Yeah, me too.” After rebooting because of the runaway iterations on that thought, I had another, “Well… hold… Read more
Didn’t they just do this in the spring? Word is out that they’re expanding even more data centers. The cynical take would be that it’s really all about the expanded need for data because of XBox One. But I doubt that explains it all. What’s happening is that Azure is… Read more
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of the plan themselves are, in fact, estimates. But it goes further than that. The estimated values are based on statistics, or the lack thereof. Statistics themselves are also estimates. This… Read more
Getting started with new technologies can be a pain. That makes all the new labs that Microsoft just posted extremely useful. There are several that are going to be immediately applicable to your average data pro; Introduction to SQL Database, Connecting a PaaS Application to an IaaS Application with a… Read more
How we program, what we program and where we program is changing. All the time. This excellent article lays out a bunch of the trends that are going on within software these days. And one of the single biggest parts of this trend is the fact that more… Read more
This is my second post in what I hope will be an ongoing series. You can see the rules for this, such as they are, and the last winner here.
I didn’t travel this past month, so I’m pulling my speaker of the month from a session that was… Read more
I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess it up with dire circumstances to your server and your data. However, I absolutely recognize that dynamic T-SQL may be needed, and, in some situations, the best way to solve… Read more
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog post on Scott Guthrie’s blog. I’m interested in seeing how that automatic scaling on VMs works with SQL Server (if it works with SQL Server). Good times.
And yeah, the… Read more
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But the apps there are and the OS itself… wow! And the hardware is always charging forward. And evidently, this new acquisition from Microsoft suggests that it might charge forward in… Read more
Women, for the entire male half of the population, I apologize.
Those who know me well recognize, pretty easily, that I am hardly “politically correct.” My mode of address can be blunt and even rude. But… I think it’s also recognized that I’m very even-handed with my blunt statements. Female… Read more
When I present on Windows Azure SQL Database, one of the biggest concerns comes up around throttling. Just the concept that your queries might be shut down because they use too many resources tends to freak people out. I’m not sure why. I think we ought to have the same… Read more
I am excited to be able to tell you about an all day seminar that I’ll be putting on prior to the Dallas SQL Saturday #255. The seminar will be on November 1, 2013. It’s called Query Performance Tuning in SQL Server. We’re going to cover the topic… Read more
It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people had for learning Azure (and AWS for that matter) is that they had to register with a credit card and actually put their own money on the line to try… Read more
It was pointed out to me that since PASS is such a huge networking event, any employer would be crazy to send a good employee to the event. They’ll just come back and hand in their two weeks notice. You know, that’s entirely possible. But, let’s not confuse networking with… Read more
Not a big deal really, but they’re consolidating from the SQLCAT.COM to put everything on MSDN.
I love the SQL Customer Advisory Team. They tackle some of the hardest problems out there and then tell us about how they did it. That’s a resource you… Read more
Learning new things can be daunting. First, you have to come up with the spare time. Then you have track down resources. For computers, computing and programming, this is both extremely easy and extremely difficult. That difficulty is especially true when it comes to gathering resources for learning things that,… Read more