Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security...
2022-03-02
229 reads
I like Extended Events and I regularly use the Session Properties window to create and explore sessions. I’m in the window all the time, noting it’s quirks & odd...
2022-03-02 (first published: 2022-02-15)
221 reads
Welcome to a new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-03-02
146 reads
I’m heading to SQL Bits this weekend, and will be in London most of next week for the conference. I’m excited. SQL Bits is my favorite conference, as I’ve...
2022-03-02
16 reads
In hindsight, I should have done this differently. In a previous post I discussed how I carved up 18TB of storage into various storage pools. Now that I have...
2022-03-02 (first published: 2022-02-18)
652 reads
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-01
11 reads
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. February became more of a work month for me, and...
2022-03-01
12 reads
In today’s blog posting I want to talk about Heap Tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have...
2022-03-01
395 reads
Welcome toa new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the xesmarttarget...
2022-03-01
287 reads
In my previous post, I discussed how to setup Kerberos constrained delegation and a limitation of using that method. This post will discuss how we can used resource-based Kerberos...
2022-03-01
244 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item 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?