Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller
This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
Part...
2015-04-29
2,134 reads
Blog Posts
DataZen Dashboards Update
I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think...
2015-04-29
1,405 reads
DataZen Dashboards Update
I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think...
2015-04-29
699 reads
Excel in T-SQL Part 1 – HARMEAN, GEOMEAN and FREQUENCY
Today’s blog will be the first in a multi-part series on replicating Excel functions in T-SQL, starting with HARMEAN, GEOMEAN...
2015-04-29
2,310 reads
MySQL TinyInt treated as Boolean
When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the...
2015-04-29
2,859 reads
Outlier Detection with SQL Server, part 6.2: Finding Outliers Visually with Reporting Services Box Plots
By Steve Bolton
…………Throughout this series of amateur mistutorials in using SQL Server to identify outliers, we have repeatedly seen that...
2015-04-29
2,442 reads
Rebuild Indexes of database with fragmentation more than 30%
Rebuild of indexes is the prime job of a DBA as heavily fragmented indexes can degrade query performance and cause your application...
2015-04-29 (first published: 2015-04-18)
17,720 reads
Running Powershell scripts remotely.
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of...
2015-04-29
1,602 reads
They Can Do What? – SHUTDOWN - WaterOx Consulting
Reading Time: 1 minutesMany times the DBA is faced with the dilemma of granting excessive...
The post They Can Do What?...
2015-04-29
981 reads
Tracking Table Usage and Identifying Unused Objects
One of the things I hate the most about “old” databases is the fact that unused tables are kept forever,...
2015-04-29 (first published: 2015-04-20)
16,767 reads
Blogs
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....
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...
Forums
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
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers