How To Identify The Grain

Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...

Searching for People

Inside Redgate Software, someone posted a picture and was asking if anyone knew who the person was. In this case, there had been a conversation at an event, and...

SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?

It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We ... Continue reading

T-SQL Tuesday #165: Database Job Titles Roundup

This month I prompted bloggers to talk about what database job titles mean to them. Thank you to all who posted on this topic! Don’t worry; if you still...

Fill Out The State of the Database Landscape Survey and Maybe Win

If you’re like me, you sometimes wonder how different other environments are from the one I work in. Well, the ones I used to work in. These days I...

SQL Server Patching

Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates...

Running SQL Server in Docker Swarm

I haven’t touched Docker Swarm for a looooong time but I was asked about running SQL Server in Swarm at a conference a while back…so here’s how it can...

Which Schema is Queried First?–#SQLNewBlogger

I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...

Remotely Copy Files To Multiple Destinations Using PowerShell

Remotely Copy Files To Multiple Destinations Using PowerShell

Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...

Remotely Copy Files To Multiple Destinations Using PowerShell

Remotely Copy Files To Multiple Destinations Using PowerShell

Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...