-->
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: March 2017

Random Blogging Challenge Results

The winner is: Everyone.

Hey, the challenge was random. I didn’t promise a prize or a winner. Instead, I suggested everyone blog based on an image of the great Tom Baker:

In no particular order we have:

Persist and Aggregate Index Stats Across Server Restarts by Eric Cobb
Nice use… Read more

1 comments, 332 reads

Posted in The Scary DBA on 29 March 2017

Sharing With You In All Fifty States

I made a mistake the other day. For some reason I got it into my head that I was flying to Albuquerque when I was actually flying to Phoenix. I’ve no idea how or why that occurred, but I sent a tweet out on how excited I was to finally… Read more

1 comments, 263 reads

Posted in The Scary DBA on 28 March 2017

Why You Should Change the Cost Threshold for Parallelism

I’ve written several times about the Cost Threshold for Parallelism and it’s relationship to your execution plans, how to determine your execution plan cost, and even how to decide what value to set your Cost Threshold to. What I haven’t explicitly addressed in extremely clear terms is why you… Read more

7 comments, 2,530 reads

Posted in The Scary DBA on 13 March 2017

Help Me, Help You, Deliver DevOps

I believe in DevOps.

Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.

I have successfully worked within an environment that implemented a DevOps approach to development, deployment and maintenance. I also provide classes and consulting on how to approach DevOps from… Read more

2 comments, 1,618 reads

Posted in The Scary DBA on 7 March 2017

SQL Clone and a Little Competition

Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s your turn to get excited.

Our developers evidently had too much time on their hands after building SQL Clone. They created a skill in Alexa that lets you clone… Read more

10 comments, 1,510 reads

Posted in The Scary DBA on 6 March 2017

Random Blog Post Challenge

OK, for no particular reason at all or maybe because I had too much food at lunch or just because Jason Hall gave me the idea, here’s a blog post challenge for anyone who wants to take it up. Write a technical blog post that incorporates this image:

Link… Read more

10 comments, 277 reads

Posted in The Scary DBA on 2 March 2017