Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

Building a Data Center

Posted on February 5, 2025 by way0utwest

Most of you reading this have likely seen a data center, and maybe sat in one while connecting to a database, but how many of you have had to try and do some of the work to set one up? … Continue reading →

Posted in Editorial | Tagged | 4 Comments

Picking a Starting Table in Test Data Manager

Posted on February 5, 2025 by way0utwest

I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post on using your own backup. One of the things I didn’t show from my own database was that it had … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Picking a Starting Table in Test Data Manager

T-SQL Tuesday #183 Invite: Tracking Permissions

Posted on February 4, 2025 by way0utwest

It’s time for T-SQL Tuesday again and this month I’m hosting. I realized that I didn’t host in 2024 and since I run the thing, I ought to be a part of it one of these days. So, this is … Continue reading →

Posted in Blog | Tagged , | 7 Comments

Declaring a Complex PK in a CREATE TABLE: #SQLNewBlogger

Posted on February 3, 2025 by way0utwest

Recently I was talking with someone who had not named any of the primary keys (PKs) in their database. They used system generated names and when they ran comparisons, they got all sorts of drops and creates they didn’t expect. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Declaring a Complex PK in a CREATE TABLE: #SQLNewBlogger