Issues When Using Temporary Tables in Nested Stored Procedures

SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables.  One of the capabilities is to allow for stored procedures to call...

SSIS – Arithmetic overflow error converting IDENTITY to datatype int

I recently encountered a SSIS package that was failing due to an ‘arithmetic overflow error converting IDENTITY to datatype int’; Conversion/overflow errors aren’t that unusual – normally a data...

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