-->
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: December 2018

Redgate Reviews 2018, Predicts 2019

Our boss came to us and said, “We need one more webinar to round out the year.” Well, we’re just like you guys, counting down the hours until our holidays start like a short-timer in the military looking at that discharge date.  The boss wants an entertaining, engaging, informative webinar.… Read more

0 comments, 159 reads

Posted in The Scary DBA on 17 December 2018

Privacy and Protection in the Age of the GDPR

We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at long last, it’s pretty clear that privacy and protection is a growing thing. Add to this the fact that SQL Injection is still an issue along with all the other… Read more

4 comments, 237 reads

Posted in The Scary DBA on 10 December 2018

Database Fundamentals #20: Using the JOIN Operator, Inner Join

It is entirely possible to try to JOIN two tables on almost any field, as long as the two data types can, in some way, be made to reconcile to each other, you can try to join the tables. But, most database designs assume a much more directly relationship and… Read more

9 comments, 2,492 reads

Posted in The Scary DBA on 3 December 2018