Alternating Group Colors
Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my...
2010-06-02
509 reads
BrianKMcDonald
Flipping a Table Sideways
Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table....
2010-05-28
1,600 reads
Using PATINDEX to Split Column Data
A colleague of mine received an Excel file that he needed to load into a table for future lookup values....
2010-05-20
1,186 reads
Using the Report Items Collection in Reporting Services
Using the Report Items Collection in Reporting Services
Sometimes, you may want to do calculations or use some value that has...
2010-05-12
491 reads
SSRS - Time Saver using Templates
Creating a Reporting Services Template
Many companies like to have a consistent look and feel across their applications. Some even make...
2010-05-12
582 reads
Running Totals Using Reporting Services
Sometimes one may need to see a running number that represents a quantity for a period of time. For example,...
2010-05-12
1,461 reads
SQL Saturday 38 Presentation
This past weekend was SQL Saturday 38 in Jacksonville Florida. It was a great event and the turnout was incredible....
2010-05-12
402 reads
Time Matters: Part 1
If you’re anything like me, you value every second of your day and you constantly try to find new ways...
2010-05-10
462 reads
Introduction to SSRS 2008 and SQL Saturday 38
In a few short weeks, another great event is coming to Jacksonville Florida at the UNF campus. There are many...
2010-04-26
358 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers