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...
2021-04-05
14 reads
Blog Posts
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...
2021-04-05 (first published: 2021-03-25)
268 reads
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...
2021-04-05 (first published: 2021-03-25)
314 reads
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...
2021-04-05
9 reads
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...
2021-04-04
798 reads
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...
2021-04-02
10 reads
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,...
2021-04-02 (first published: 2021-03-24)
368 reads
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...
2021-04-02 (first published: 2021-03-24)
182 reads
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...
2021-04-01
23 reads
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...
2021-04-01
20 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers