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

Database Fundamentals

One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to forget about the fundamentals. More importantly, in our pursuit of the latest and greatest things, it’s very easy for those of us who teach to forget to reach back and… Read more

7 comments, 2,744 reads

Posted in The Scary DBA on 31 May 2017

Technology Gender Gap By State

This is my first ever guest blog post. Take it away Hazel Garcia.

Though the gender gap narrows by the year, there remains a noticeable lack of balance in the professional workplace. This gap reflects in everything from gender-based pay scale discrepancies to the ratio of women to men… Read more

8 comments, 1,404 reads

Posted in The Scary DBA on 22 May 2017

MySQL and Backups As A Service

With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more exciting opportunities have presented themselves for companies to build and manage their information. According to the DB-Engines Ranking, MySQL is the second most popular data management system out there.… Read more

4 comments, 585 reads

Posted in The Scary DBA on 10 May 2017

General Notes on Security in Azure SQL Data Warehouse

I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you think that it’s just SQL Server, what’s the big deal. Then you start to understand the underlying architecture and things get complicated. Then you begin to understand the implications of… Read more

9 comments, 1,118 reads

Posted in The Scary DBA on 8 May 2017

Redgate Alexa Contest Winners!

A couple of weeks ago we had a small contest here to pick a skill for Alexa. The entries were all wonderful, but I could only pick five as winners with one of them being the top winner. Thanks everyone for playing.

In no particular order, here are the four… Read more

1 comments, 460 reads

Posted in The Scary DBA on 5 May 2017