Shift calculations (or same time every day)
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. ... Continue reading
2022-03-15
4 reads
Blog Posts
Changing the Owner of a Database #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had an authorization issue with my account,...
2022-03-14
152 reads
Creating Dynamic LinkedIn Share Links with Power Automate
In this video, Devin wraps up this 3 part Power Automate video series by showing you how to make dynamics Linkedin share links so you
2022-03-14
62 reads
Daily Coping 14 Mar 2022
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...
2022-03-14
11 reads
Execution Plan Properties
I’ve watched several people recently go straight to XML when reading execution plans because they didn’t know about the execution plan properties in the first operator. Now, don’t get...
2022-03-14
34 reads
Expert Series Webinar – Optimizing SQL Server Data Protection
I’m thrilled to be presenting the second part of a four-part webinar series with ActualTech Media called “Optimizing SQL Server on VMware Data Protection and Disaster Recovery” this Friday,...
2022-03-14
27 reads
I’m writing a SQL Server security presentation and I need your help.
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going ... Continue reading
2022-03-14 (first published: 2022-02-24)
310 reads
Unable to Validate Source Query in Tabular Editor
I recently encountered the error, “Unable to validate source query” when trying to refresh the metadata for the tables in my tabular model using Tabular Editor. I immediately googled...
2022-03-14 (first published: 2022-02-22)
187 reads
Execute SQL Scripts on Snowflake using Azure Data Factory
Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers): the Script activity! This is not to be confused...
2022-03-13
40 reads
Azure Redundancy for Storage
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-11 (first published: 2022-02-23)
445 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?