Editorials

SQLServerCentral Editorial

What Could Go Wrong?

It's the law of unintended consequences: things happening that you don't expect from a seemingly unrelated area. This article talks about a data center having leaks from carpet cleaning above. The concrete floor had aged and the carpet cleaners dumped water on the carpet to soak it through and it leaked. I'm not sure how people have data centers below office floors, but I know I've had a number of them at different companies where I've worked.

You rated this post out of 5. Change rating

2007-09-12

133 reads

Blogs

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

The Mysterious Empty Table

By

It seems like no matter how long you work with a system beyond a...

Choosing to not drive the Tesla

By

I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...

Read the latest Blogs

Forums

How Do You Change Data Type from uniqueidentifier

By Ahr Aitch

In the ss below you can see that I have a table (dbo.clan.spouses) with...

tabular model processed but wont deploy

By stan

hi i imported a tabular model from production into vs 2022,  changed the data...

Services SqlServer and SqlServerAgent don't start. How resolve??

By gpezzella

Hi I have just installed again on win 11 sql server express 2022 with...

Visit the forum

Question of the Day

Mixed Backups

I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).

BACKUP DATABASE [complex]
    FILE = N'thirdone'
 ,  FILE = N'thirdtwo'
 ,  FILEGROUP = N'second' 
 TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' 
 WITH NOFORMAT, NOINIT,  NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

See possible answers