X-XMLA: vi. Processing and Out-of-Line Bindings in XMLA
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
804 reads
24 Hours of PASS
Tomorrow Brian Knight and I will kick off 24 hours of PASS with a session on Choosing a Microsoft Reporting...
2012-09-19
1,186 reads
Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2012-09-19
757 reads
Upgrade SQL Server 2005 Full-Text Catalog to SQL Server 2012……By Backup & Restore…….Part 1 of 2
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
The full database...
2012-09-19
926 reads
Database Recovery Advisor feature of SQL Server 2012
SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases...
2012-09-19
2,392 reads
To the cloud!
This last year or so I have been backing up my important files to cloud. I started using SkyDrive and...
2012-09-19
656 reads
Your Boss Wants You To Be Better at X
Imagine that you use a piece of software as part of your work, but it’s not what you consider the...
2012-09-19
705 reads
SQL Server – Understanding ‘Agent XPs’ Server Configuration Option
Today we got an escalation where on one of the servers ‘Agent XPs’ was in a disabled state. And when...
2012-09-19
423 reads
Lenovo–Three Strikes
Last Friday Lenovo told me my new laptop would ship this Monday, or “much much sooner”. Monday I called to...
2012-09-19
808 reads
SQL Server Quickie #3 – Allocation Units
Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in...
2012-09-18
611 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
Execute as failure
Security has long been a problem for me. Every time I think I understand...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers