Every year, I spend the Sunday after SQL Saturday Rochester scanning & processing raffle tickets for our wonderful sponsors. Here’s how the system works:
Attendees get tickets (one ticket per...
2018-04-10
12 reads
(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:
SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...
2018-04-09
1,132 reads
I’ve been away a bit in the last week with personal and family commitments. As a result, I feel a...
2018-04-09
925 reads
I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...
2018-04-20 (first published: 2018-04-09)
3,446 reads
I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...
2018-04-19 (first published: 2018-04-09)
2,250 reads
# Not the GDPR News -t minus 10 days
There is ten days to go and there are still some seats left for...
2018-04-09
311 reads
(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...
2018-04-18 (first published: 2018-04-09)
2,927 reads
If you are working on SQL Server optimization delicately, you may get often queries that how to find if any...
2018-04-09
971 reads
It’s been 45 days since we released dbachecks
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances https://t.co/2dmUdKtgTQpic.twitter.com/N8W01KaKo9
— Rob Sewell (@sqldbawithbeard) February...
2018-04-18 (first published: 2018-04-08)
2,241 reads
Encryption is a good technique using which a particular data is obfuscated with a key or password. This makes the data useless until any decryption key or password is...
2018-04-07
13 reads
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Comments posted to this topic are about the item BIT_COUNT() V
Comments posted to this topic are about the item How We Reduced SQL Server...
Comments posted to this topic are about the item An Eventual Consistency Scam
What does this return on SQL Server 2025?
select bit_count(null)See possible answers