SQL RNNR

Blog Post

Deployed Session Settings

Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those...

2015-09-28

6 reads

Blog Post

The Extended Event GUI

In the previous article in this series I shared the basics around assembling an XEvent session. The method used in...

2015-10-01 (first published: )

2,638 reads

Blog Post

The Extended Event GUI

The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Related Posts:

Profiler...

2015-09-25

4 reads

Blog Post

Assembling a Session

With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Related Posts:

Short...

2015-09-24

1 reads

Blog Post

Freecon – Oct 27 in Seattle

It is well known that there is a wealth of information within Extended Events. One can tap plenty of information about performance issues, errors, or general interest type stuff...

2015-09-23

2 reads

Blog Post

Predicate Order is Critical

I want to drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining...

2015-09-23

45 reads

Blogs

Flyway Tips: AI Generating Migration Script Names

By

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

Another of our values: The facing page has this quote: “We admire people who...

Runing tSQLt Tests with Claude

By

Running tSQLt unit tests is great from Visual Studio but my development workflow...

Read the latest Blogs

Forums

No Defaults Passwords Ever

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No Defaults Passwords Ever

Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

By saum70

Hi, We have low latency high volume system. I have a table having 3...

The Long Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long Name

Visit the forum

Question of the Day

The Long Name

I run this code to create a table:Create table with unicode nameWhen I check the length, I get these results:Table with length of name shown as 132 charactersA table name is limited to 128 characters. How does this work?

See possible answers