Log File Full–Availability Group Database
I run into an interesting issue with an Availability Group database recently. I was running a data load against a...
2012-09-26
5,007 reads
SP_HELPTEXT showing old Store Procedure name after rename, is it a Bug?
Question : Today morning, I received a call from one of my old friend, with an query for SQL Server. He...
2012-09-26
1,427 reads
Running a document database on Sql Server
Running a document database on Sql Server.
Since Microsoft is slow to come out with a product of their own to...
2012-09-26
14,753 reads
Excel 2013 – Trouble Installing Silverlight for Power View
Last week during my 24 Hours of PASS session on Choosing a Reporting Platform I fielded a question that appeared...
2012-09-26
1,299 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday April 24th at the Microsoft campus in Redmond,...
2012-09-25
9 reads
2013 North American PowerShell Summit
The date has been set for the next North American PowerShell Summit. It will be held Monday April 22nd – Wednesday...
2012-09-25
1,176 reads
Transferring Table Types
An interesting idea. I saw this question asked after I was playing with table types a bit. “Can you move...
2012-09-25
1,689 reads
Using a TVP instead of Dynamic SQL to pass a list into a SP
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,188 reads
Master Data Services: Resources
Here are some of my favorite Master Data Services (MDS) resources:
SQL Server Master Data Services Utilities: A set of useful...
2012-09-25
2,573 reads
SQL In The City: Austin
So, No SQL Saturday in Austin This Year.
I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in...
2012-09-25
1,048 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
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....
Forums
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
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
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers