-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

Archives: February 2017

Determining the Cost Threshold for Parallelism

In the previous post, I showed how you can get full listings of your execution plan costs. Knowing what the values you’re dealing with for the estimated costs on your execution plans can help you determine what the Cost Threshold on your system should be. However, we don’t want… Read more

10 comments, 1,430 reads

Posted in The Scary DBA on 28 February 2017

SQL Clone

Today is the launch of SQL Clone, a great new tool that helps you quickly and easily provision SQL Server databases for development and testing.

Oh god, that sounds like marketing speak. To heck with that. Let me tell you why I’m so excited about SQL Clone and why… Read more

4 comments, 1,448 reads

Posted in The Scary DBA on 27 February 2017

I Don’t Understand

I suspect this may make a few people angry, but I felt the need to share.

I was recently asked to go through my contacts and put together calls with some technologists for a series of discussions. OK. I thought about what we’d need, compared it to a mental list… Read more

10 comments, 2,971 reads

Posted in The Scary DBA on 24 February 2017

Confusion of An Old Technologist

As someone who still actively pursues a career in technology, I’m a little on the older side. I got started in tech when a lot of the people I know were still in elementary school. So please understand that when I write the rest of this little… rant.

I read… Read more

10 comments, 249 reads

Posted in The Scary DBA on 23 February 2017

Estimated Costs of All Queries

One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty universally denigrated (well, not by Microsoft, but by most everyone else). However, what value should you set yours to?

What Do Your Plans Cost?

I have a question right back… Read more

10 comments, 2,245 reads

Posted in The Scary DBA on 20 February 2017

Export All Plans From Cache to a .SQLPLAN File

I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file. My immediate answer was, “I’m sure there’s a PowerShell script out there somewhere.” However, rather than do a Gingle search, I figured I’d quickly knock up an example.

The Script

Read more

2 comments, 671 reads

Posted in The Scary DBA on 13 February 2017

Does Query Store Pre-Allocate Space

I love the questions I get while I’m presenting because they force me to think and learn. The question in the title is one I received recently. The answer, now that I’m not standing in front of people, is easy. Of course the space is not pre-allocated. Query Store tables… Read more

4 comments, 1,242 reads

Posted in The Scary DBA on 7 February 2017

Still Grateful to Rodney Landrum

So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had to remove that post as a part of the cleanup (still ongoing). However, I couldn’t let that stand. I’ve used caching on the internet to track down the original post… Read more

0 comments, 255 reads

Posted in The Scary DBA on 6 February 2017

I have been hacked

I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.

The post I have been hacked appeared first on Grant Fritchey.

Read more

3 comments, 420 reads

Posted in The Scary DBA on 5 February 2017