There are actually a couple of ways to create a primary key with T-SQL. You can use the ALTER TABLE script to add a primary key to an existing...
2020-08-06 (first published: 2020-07-28)
521 reads
2020-08-01
115 reads
I’m excited to be able to announce that the AWS Community Builders, a new program for those who help out with AWS technologies, has been launched. You can read...
2020-07-30
13 reads
I’m at the just barely scratching the surface level of getting started with AWS Deployment Pipelines. Of course, the first thing I want to do with them is get...
2020-07-20
62 reads
Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...
2020-07-20 (first published: 2020-07-14)
342 reads
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is our smaller, focused sessions. This one is about the concept of how DevOps, or, more...
2020-07-16
43 reads
I asked this question myself: Is there a way to use Extended Events to capture the T-SQL of a prepared statement? Why would I be concerned with prepared statements?...
2020-07-15 (first published: 2020-07-06)
338 reads
One of the things I love the most about Platform as a Service offerings is the fact that it makes it so I don’t have to do silly things...
2020-07-09 (first published: 2020-06-29)
320 reads
There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful...
2020-07-06 (first published: 2020-06-22)
682 reads
Redgate published a report that many of you helped with by providing information. First, thanks! Your info really helped. Second, do you want to see it? You can. Go...
2020-06-22
14 reads
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Environment: SQL Server: 2019 Enterprise (15.0.4430.1) OS: Windows Server 2022 Standard (Build 20348) Virtualization:...
I am trying to create a filter on a SQL Server audit to capture...
I've come across what appears to be a strange deadlock anomaly. As seen in...
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers