Daily Coping 24 May 2021
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...
2021-05-24
13 reads
Blog Posts
Database Fundamentals #30: Create Foreign Keys With T-SQL
You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...
2021-05-24
10 reads
How to Repair a Database in SQL Server Management Studio
As a SQL database administrator, it’s your responsibility to maintain and secure the databases. However, you may still experience database corruption. If not handled correctly and on time, you...
2021-05-24
5,816 reads
How to Repair a Database in SQL Server Management Studio
As a SQL database administrator, it’s your responsibility to maintain and secure the databases. However, you may still experience database corruption. If not handled correctly and on time, you...
2021-05-24
22 reads
Running a SQL Server container from scratch
I’ve been interested (obsessed?) with running SQL Server in containers for a while now, ever since I saw how quick and easy it was to spin one up. That...
2021-05-24 (first published: 2021-05-17)
651 reads
SQL Server Admin Best Practices with DMVs at GroupBy Americas 2021
On Tuesday I'm looking forward to presenting again at GroupBy Americas on a topic that was voted on by the attending public. This presentation "SQL Server Admin Best Practices...
2021-05-24
41 reads
The Best of Both Worlds: WordPress.com Managed Hosting
How you can get the total freedom to create without the hassles that come with managing your own website. The open source WordPress project has given the world a...
2021-05-24
35 reads
A New Road Ahead…
Where I’ve Been Since January 1, 2012 I’ve been the principal consultant at Centino Systems. Jokingly, I refer to myself as The Centino of Systems. I learned a lot...
2021-05-22
25 reads
A New Road Ahead…
Where I’ve Been Since January 1, 2012 I’ve been the principal consultant at Centino Systems. Jokingly, I refer to myself as The Centino of Systems. I learned a lot...
2021-05-22
4 reads
Career: Talk To References
As we try to get through these strange times in the world, I am starting to see a bit more career movement in 2021 than I saw for much...
2021-05-21 (first published: 2021-05-14)
181 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers