Blog Posts

Blog Post

The Fun of Blogs

If you look at my blog roll Jeff Dunntemann is one of the ones recommend. Nothing about SQL Server there, but he...

2008-03-03

356 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

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...

Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022

By Noman072

Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...

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