The Choice of SQL Server Version
Brent Ozar has his quarterly report on SQL Server versions and SQL Server 2022 isn't being used as much. Does that make sense to you? What versions are you installing?
2023-07-22
436 reads
SQL Server versions
Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click
The script includes these steps: STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLESPERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]
2020-05-22 (first published: 2020-05-13)
1,142 reads
Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click
The script includes these steps: STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLES\PERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]
2020-05-22 (first published: 2020-05-12)
2,487 reads
How to Programmatically Determine Which Edition of SQL Server is Installed
Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.
2017-03-02
3,772 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
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
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
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?