Blog Posts

Troubleshooting “Could not obtain information about Windows NT group/user”

• by Gianluca Sartori

• SpaghettiDBA

This is one of those typical blog posts that I write for my future self, the guy who keeps fixing the same stuff over and over and forgets what...

2019-08-16

10 reads

Constructing a datetime from an integer date and an integer time.

• by Kenneth Fisher

• SQLStudies

Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date ... Continue reading

2019-08-15

112 reads

David's book: Putting Your Head in the Clouds

• by Gethyn Ellis

• The SQL DBA in the UK

I have had a few people contact me over the last few weeks asking if David’s ebook “Putting Your Head in the Clouds” is still available. The short answer...

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

207 reads

Get All Database Snapshots and Their Parent Databases On A SQL Server

• by davidfowler-42596

• SQL Undercover

This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...

2019-08-15

9 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

Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running.

• by Meagan Longoria

• Data Savvy

I have a client who uses MDS (Master Data Services) and SSIS (Integration Services) in an Azure VM. Since we only need to execute the SQL Agent job that...

2019-08-15

34 reads

Big fall conference – PASS Summit schedule is up!

• by Jen McCown

• SQL Awesomesauce

PASS Summit 2019 now has a schedule and learning tracks, and a letter to convince your boss you should go!
The post Big fall conference – PASS Summit schedule is...

2019-08-14

29 reads

Find queries with high memory grants – using Query Store

• by Matthew McGiffen

• Matthew McGiffen DBA

I had a server that looked like it had been suffering from memory contention. I wanted to see what queries were being run that had high memory requirements. The...

2019-08-14 (first published: 2019-07-31)

487 reads

How to really store a password in a database

• by Randolph West

• Born SQL with Randolph West

Recently I wrote: Don’t store passwords in a database. I stand by this statement. I expected a lot of flak because I didn’t explain myself. This post goes into...

2019-08-14

222 reads

Jenkins in a Container

• by Steve Jones

• The Voice of the DBA

One of the things I needed to do recently was get Jenkins running as a demo for a customer. We have some pre-built VMs to do this, but I...

2019-08-14

63 reads