-->
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 2019

How Do You Export A Database in Azure Data Studio

I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I received recently asked how to export a database from Azure Data Studio. It made me want to explore the topic of exporting a database as it relates to Azure Data… Read more

4 comments, 2,330 reads

Posted in The Scary DBA on 25 February 2019

Installing Extensions to Azure Data Studio

If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing a few extensions. Buck Woody has a great list that you should look through in this blog post. If you’re just getting started with Azure Data Studio, I have an… Read more

3 comments, 297 reads

Posted in The Scary DBA on 18 February 2019

Query Store and a READ_ONLY Database

What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The only way to find out how this works is to test it. So, let’s write some code: Executing that resulted in a small glitch in the Matrix: 8:00:54 AMStarted executing… Read more

2 comments, 1,745 reads

Posted in The Scary DBA on 11 February 2019

Combine Extended Events and TagWith to Monitor Entity Framework

I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is the bomb. It’s amazing. It does wonderful stuff. Entity Framework makes the developers lives and jobs easier. It makes my life… Read more

2 comments, 146 reads

Posted in The Scary DBA on 4 February 2019