File Group Backups - Intro
What is File Group backup?
Backing up a portion of a database, say a File Group is termed as Filegroup...
2012-01-13
496 reads
Blog Posts
Friday SQL Nugget #1
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like...
2012-01-13
1,442 reads
HP DL980…now this is a server!
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
956 reads
Moving Database Files and Replication
Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database...
2012-01-13
691 reads
Re-blog – January 6 – January 12
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-13
651 reads
Bloopers from Dec 2012
The raw ones from podcasts in late Nov and Dec 2011.
Dec 2011 Bloopers
Filed under: Blog Tagged: Humor, syndicated
2012-01-12
1,124 reads
Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,668 reads
DBAs@Midnight 6 week roundup
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...
2012-01-12
692 reads
Fragmented Index – Rebuild or Reorganize ?
Introduction
In past, many times I have written on Fragmentation of Indexes and how to Defrag them. You can find some...
2012-01-12
15,600 reads
Missing Indexes
SQL Server has means built into it to track possible missing indexes. This used to be found through the use of the Index Tuning Wizard. The process has improved...
2012-01-12
6 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers