Daily Coping 6 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...

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