Checking the Health of your CLR
The Common Language Runtime (CLR) is the fundamental nerve center of the Microsoft .NET Framework. It is this nerve center that...
2018-01-16
1,011 reads
How To Split Table Partitions Automatically
Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if...
2018-01-16
973 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it’s not likely to erupt any...
2018-01-16
1,165 reads
Importing GeoJSON Earthquake Data Into SQL Server
A significant portion of Yellowstone National Park sits on top of a supervolcano. Although it's not likely to erupt any time soon, the park is constantly monitored for geological...
2018-01-16
15 reads
Using the AST in Pester for dbachecks
TagLine – My goal – Chrissy will appreciate Unit Tests one day
Chrissy has written about dbachecks the new up and coming...
2018-01-15
340 reads
SQL Server on Linux Series: Expanding LVM Drives
Next in our SQL Server on Linux series is one important question. On Windows, if you’re about to run out...
2018-01-29 (first published: 2018-01-15)
1,186 reads
Query Shortcuts in SSMS (Day 15)
There are several shortcuts that can be assigned to run a stored procedure. Known as Query Shortcuts, these can be...
2018-01-15
329 reads
Dissecting SQL Server, The Internal Structure of a Row
I’m sure that most of us know that SQL Server stores all it’s data in 8Kb pages. But what do...
2018-01-26 (first published: 2018-01-15)
2,002 reads
Reading GDPR
In case you’re interested, the GDPR law is actually not bad to read. You might be affected by this, so...
2018-01-15
474 reads
Getting Started in a SQL Server 2017 VM in Azure
You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!
Oh, you want...
2018-01-26 (first published: 2018-01-15)
1,220 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