Daily Coping 5 Apr 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Moving Into Consulting 101 - Part 4 - The Process of a Consultant

This is part four in a five part series this week, Moving into Consulting 101. 
Today's topics give you a numerical advantage in consulting. All have a common theme: don't wing...

Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 4)

Let’s take a look at the final few steps of your initial server intake process and get your workflow up and running as you push toward performing regular server...

What perms does a user need to create a table variable?

This came up because a user had db_owner perms and it was only reading from a database and creating a table variable from it. I created a new user...

Get the schema of a temp table

I wanted to find out what data types SQL Server auditing was using, so I put the auditing file results into a temp table and executed tempdb..sp_help on that...

Daily Coping 2 Apr 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Moving Into Consulting 101 - Part 3 - The Hours of a Consultant

This is part three in a five part series this week, Moving into Consulting 101.  

Today's topics talk about why you were hired. How is your work likely to be quantified,...

The SQL Saturday Foundation Vision

A few things to start. First, this is about SQL Saturday events. Only. This is NOT about the future of the Summit. Redgate is working on that separately from...

Azure SQL – Saving Costs

When moving to a cloud model for your database stack no doubt you will be involved in a costing exercise. The good news is if you have Software Assurance...

Daily Coping 1 Apr 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...