Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario
Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server
2008 R2. You can download the Service Pack...
2012-07-27
2,581 reads
Licensing SQL Server Dev/Test Environments
I was recently at a client site and we started talking about SQL Server licensing, specifically for their development and...
2012-07-27
20,281 reads
SQL Server 2008 R2 – Service Pack 2 now available
SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.
All the details are here
Stay...
2012-07-27
1,407 reads
SSRS – Using Lookup Function for Multiple Column Join
When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple...
2012-07-27
4,387 reads
Retrieving Deadlock Graphs with Event Notification
Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps...
2012-07-26
2,921 reads
Capacity considerations while moving SQL workloads to a Virtual world !
One of the most basic capacity considerations involved while planning to move SQL workloads to a virtual environment is to understand the...
2012-07-26
839 reads
A Quick Guide to Expanding Database Files and IFI
This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very...
2012-07-26
1,110 reads
Last Call For Speakers for SQLSaturday Orlando
Our call for speakers for SQLSaturday #151 in Orlando closes on July 31, 2012. We’ve got room for a handful...
2012-07-26
613 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas
In the last 2 blog postings you have learned how to setup your first Availability
Group with SQL Server 2012. Today...
2012-07-31 (first published: 2012-07-26)
4,735 reads
Joining on NULLs
A problem I see on a fairly regular basis is that of dealing with NULL values. Specifically here, where we...
2012-07-26
1,812 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