SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a new system database was made available – the Resource...
2011-03-22
22 reads
SQL Resource
By now, I am sure that you are well aware of the Resource Database. Starting with SQL Server 2005, a...
2011-03-22
856 reads
Dynamic Management Quickie: Exploring SQL Server’s system views and functions as you work
There’s a lot of dynamic management and system objects to keep track of in SQL Server.
We all sometimes have the...
2011-03-22
1,367 reads
What Are Your Indexing Strategies?
A couple weeks ago, I got some pretty great new. The book proposal that I had submitted to Apress was...
2011-03-22
639 reads
SQL Server 2008 SP2 Cumulative Update 3
Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in...
2011-03-22
1,241 reads
SQL Server 2008 SP1 Cumulative Update 13
Microsoft has released SQL Server 2008 SP1 Cumulative Update 13, which is Build 10.00.2816.00. I count twelve fixes listed in...
2011-03-22
557 reads
SQL Server 2005 SP4 Cumulative Update 3
Microsoft has released SQL Server 2005 SP4 Cumulative Update 3, which is Build 9.0.5266. There are only five fixes listed...
2011-03-22
1,368 reads
SQL Server 2005 SP3 Cumulative Update #15
Microsoft has released SQL Server 2005 SP3 Cumulative Update 15, which is Build 9.0.4325. There are only six fixes included...
2011-03-22
691 reads
SSAS - Measures or Attributes in Multiple Display Folders
I had a client recently show me a neat little tip that I thought I would share.In the cube he...
2011-03-22
1,289 reads
SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.
When deploying or processing a cube or dimension you may encounter an error similar to this:
Errors in the metadata manager. The...
2011-03-22
1,271 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers