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

I May Never Be a Data Scientist

Chances are extremely high that I’ll never put down Data Scientist as my job. Considering what you do and what you know, I’ll bet a healthy percentage of you are in a similar situation. That’s OK. You know why? You know a lot about data, data movement and data processing… Read more

2 comments, 122 reads

Posted in The Scary DBA on 22 November 2017

Get That Profiler Feel in Extended Events

I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.

Unfortunately though, I think a lot of what passes for issues and problems with Extended Events is actually a lack of knowledge about how they work. Let’s take an example and run with it.

No…

Read more

2 comments, 134 reads

Posted in The Scary DBA on 20 November 2017

Presenting Azure Vs. Working With Azure

I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and around the Data Platform. I truly believe that these are the subversive elements that are going to change how a lot of us get our jobs done with data. I’ve… Read more

1 comments, 110 reads

Posted in The Scary DBA on 15 November 2017

All Day Query Tuning Class at SQLSaturday Virginia

March 23rd, 2018, I’ll be teaching an all day class on Query Tuning Tools in Richmond Virginia. I hope to see you there. However, I have to warn you, there is very limited seating. If you want to take this class, I suggest you register for it as soon as… Read more

2 comments, 155 reads

Posted in The Scary DBA on 14 November 2017

The GDPR and You

Ever heard of the General Data Protection Regulation? If not, go and read the Wiki. I’ll wait.

I can already hear what you’re thinking. “Grant, this doesn’t apply to me because my company is in the <insert non-EU country here>.” How do I know you’re thinking that? Because every… Read more

6 comments, 117 reads

Posted in The Scary DBA on 13 November 2017

Extended Events and Profiler: XE Profiler

There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace Events). On the other, the “new” (they came out in 2008 with a full GUI in 2012, so…) Extended Events. Lots of people have picked sides on this, including Microsoft. Read more

14 comments, 158 reads

Posted in The Scary DBA on 7 November 2017