Grant Fritchey

Grant
Fritchey
Product Evangelist,
Red Gate Software

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011.

Articles
The Myth About Estimated Execution Plans 3

How you name things matters. As Buck Woody said about the original SQL Server documentation, Books Online, “They weren’t books and they weren’t online.” There are even more horrific examples. As was pointed out to me by Mike Dimmick on my blog, the name for Estimated Execution Plans puts people off.

Query Store in Azure SQL Database

Have you ever had that moment when you realize that you’re dealing with bad parameter sniffing and you wish, “Oh, if only I could just quickly get another execution plan in place?” Yeah, you can use DBCC FREEPROCCACHE and pass it a plan handle to remove that plan from cache. You can quickly run the query with a good parameter so that you get a good plan. What if you could just substitute the plan for one that was working well in the first place? That exact scenario, is one of the many uses of the Query Store.

Indexes in Azure SQL Database v12

Since Azure SQL Database is just SQL Server when you get under the covers (although, you’ll never get under the covers), you’d think that it would just have the same rules and structures as SQL Server itself. Due to the nature of the shared servers, the distributed eco-system and probably a whole bunch of stuff that I just don’t know about since I don’t work there, they’ve had a different set of rules and indexes available for Azure SQL Database. That is until all the work that has come out with v12.

Gathering Data About Your v12 Azure SQL Database

One of the beautiful things about SQL Server has been the ability to more or less install it and let it run. Well, it’s a beauty until it becomes abject horror. Azure SQL Database takes the beautiful aspects of this and expands on them some since you no longer have to worry so much about the server you’re running on. You do still need to worry about what you’re doing to your database and how it’s interacting with the system. The good news, most of the tools you’re used to working with are available within Azure SQL Database, with a few exceptions.

CLR Assemblies in Azure SQL Database

I know a lot of DBAs that are adamant about the exclusion of CLR on their databases. There is no subtlety or nuance or discussion with the development team about the possibilities of a given solution actually running better in compiled CLR code. They just trot out the DBA's favorite word... NO. Prior to v12, that was also Microsoft's stance on Azure SQL Database. Not now.

Getting Started with Azure SQL Database v12

I realized that I’ve been talking about the wonders and glories of the new release of SQL Database when some of you might not even be prepared to work with it. Let’s remedy that. First of all, you’ll need an Azure account. There’s a free trial available. Go there and sign up. Better still, if you have an MSDN account you can take advantage of free credit on Azure.

PASS Business Analytics Conference 2015: Day 2

The PASS Business Analytics Conference 2015 is for Data Analysts, Data Scientists and Data Engineers who work primarily within the Microsoft set of tools, whether locally or on Azure. Today was the end of the second and final data of the conference. It was a very interesting event. I posted of my experience on the first day here. Day two was just as interesting.

PASS Business Analytics Conference 2015: Day 1

If you're involved in the analysis of data as a data engineer, data analyst or data scientist and you're using the tools from the Microsoft stack, chances are you are in Santa Clara California attending the 2015 PASS Business Analytics Conference. Just in case you've missed out, let me share my experience with the event.

Dynamic Management Views in Azure SQL Database v12

When the Dynamic Management Views (DMV) were introduced back in SQL Server 2005, we got our hands on some absolutely wonderful tools that allowed us to observe much of the inner workings of SQL Server using the language we use most, T-SQL. Prior to the release of v12 of Azure SQL Database, there were about 148 DMVs that were in the Earthed version of SQL Server that were not in Azure SQL Database. There were only about 13 DMVs in Azure that were not in the Earthed product. Things have changed.

Introducing Azure SQL Database v12

Those of you who are already hooked into Azure SQL Database know that v12 was in Public Preview in December of 2014 and has been available in most regions since February of this year, 2015. Despite Microsoft making a really big announcement about this release not that many people are aware of it. They really should be.

Comments
The Myth About Estimated Execution Plans
August 27, 2015

Absolutely correct. However, you're using RECOMPILE. As I said in the article, the one exception is when you have a recompile during execution.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
May 22, 2017
Sponsored

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017
blog

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More
Sep 15, 2016
Sponsored

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More

Sponsored Introduction Continue on to (or wait seconds) ×