Master Data Services: Changing a model with a subscription view
I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and...
2012-09-10
2,632 reads
Sleepless in Seattle – SQL in the City 2012
A few years ago I went to Seattle a few days before the PASS Summit started. I took my middle...
2012-09-14 (first published: 2012-09-10)
1,907 reads
No Full Outer Join in Access
Recently I needed to help a colleague with a small inventory true up task. We needed to know items that...
2012-09-10
797 reads
Have You Seen This Error?
location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...
2012-09-10
1,359 reads
Colorado SQL - September 2012
COLORADO SPRINGS SQL
September 19, 2012 at 5:30 p.m.
Meeting Location: Hyatt Place - Garden of the Gods, 503 West Garden of the Gods...
2012-09-10
875 reads
PASS ProfDev VC presentation recording available
Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...
2012-09-10
1,134 reads
Quick tip: Using DBCC SQLPERF(‘LogSpace’)
A lot of a DBA’s time is spent managing and investigating transaction log files.
A commonly used tool is the command:
DBCC...
2012-09-10
2,790 reads
Following good practice saves wasted time down the line.
TweetG’day,
Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this...
2012-09-12 (first published: 2012-09-10)
2,390 reads
EXECUTE AS USER = ‘Somebody else’
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
748 reads
Change file logical name for mirror database
Today I encountered a interesting issue when rename logical name for mirror database.
We have a database which has been setup...
2012-09-14 (first published: 2012-09-09)
3,076 reads
Blogs
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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...
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