SQL Saturday 167
SQL Saturday #167 is just hours away. We have worked hard to get everything setup and in place and hope...
2012-09-07
580 reads
SQL Server vs. Oracle
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,021 reads
Azure Virtual Machine TempDb Placement
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually...
2012-09-06
2,078 reads
Introduction to Windows Azure SQL Database Services (Part 2)
In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows...
2012-09-06
1,251 reads
SQLskills joining Pluralsight is a good news for all
Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...
2012-09-06
1,084 reads
Meet Thomas Kejser in Aarhus
This is normally not a place where we advertise for events held by our friends, but today I’ll make an...
2012-09-06
764 reads
This is Big Data
I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.
A day.
That’s...
2012-09-06
979 reads
Demystifying SQL Server Differential Database Backups
Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...
2012-09-10 (first published: 2012-09-06)
2,812 reads
Stressed? Need training? Take a #SQLCruise!
I can’t tell you how many times I’ve sat in a training room, in the middle of a week long...
2012-09-06
983 reads
DBCC Cleaning CACHE – Memory
DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know...
2012-09-06
957 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