The Scary DBA

How Do You Make DevOps Succceed?

• by Grant Fritchey

• The Scary DBA

I love going to SQLSaturday events because I’m always asked questions that make me think. I was just at SQLSaturday Indianapolis (a great event, if you weren’t there, you...

2019-08-19

2 reads

Profiler and Trace vs. Extended Events

• by Grant Fritchey

• The Scary DBA

It’s a running joke among the more experienced (read, older) Microsoft Data Platform specialists as to whether you’re #teamprofiler or #teamexevents. I’m very much #teamexevents, but I really don’t...

2019-08-19

10 reads

Announcing a New Book: Query Store for SQL Server 2019

• by Grant Fritchey

• The Scary DBA

I’m pleased as punch to be able to share with you the fact that I helped Tracy Boggiano write a whole new book on Query Store. It will be...

2019-08-12

17 reads

All Day Seminar on DevOps in Oslo

• by Grant Fritchey

• The Scary DBA

In just a couple of weeks, I’ll be presenting an all day session on DevOps for databases. It takes place on Friday, August 30th. You can click here now...

2019-08-07

1 reads

Running Containers In a Virtual Machine

• by Grant Fritchey

• The Scary DBA

The more you work with containers, the more you just want to work with containers. However, there are still reasons to have a virtual machine for some types of...

2019-08-15 (first published: 2019-08-05)

281 reads

Teaching DevOps in Indianapolis

• by Grant Fritchey

• The Scary DBA

There is literally nothing I like better than working on automation. Before we had all the cool toys that we have now, I was working on automating database deployments....

2019-08-01

3 reads

Sample Azure DevOps Pipelines

• by Grant Fritchey

• The Scary DBA

I’ve said it before and I will repeat myself on this because it’s an important concept: DevOps is about culture and communication, not tools Now, that said, to implement...

2019-07-29

92 reads

Importance of Testing

• by Grant Fritchey

• The Scary DBA

I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...

2019-07-22

7 reads

Implement DevOps One Step At a Time

• by Grant Fritchey

• The Scary DBA

In preparation for my upcoming DevOps training days (see the bottom of this post for details) and for some articles I’m working on, I’ve been building all new automation...

2019-08-02 (first published: 2019-07-15)

306 reads

sp_execute_external_script and SQL Injection

• by Grant Fritchey

• The Scary DBA

In order to take advantage of R and Python (and Java in SQL Server 2019) directly from your SQL Server scripts, you’ll be using the function sp_execute_external_script. When you...

2019-07-23 (first published: 2019-07-08)

594 reads