Scaling SQL Server Presentation from SQLSaturday #104 Precon
On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation...
2012-01-12
1,177 reads
Blog Posts
SQL Server – Logical Disk Read Bytes/sec and disk io
In the SAN environment , the Logical Disk Performance objects counters monitor the logical partitions.
I use the Logical Disk Read Bytes/sec ...
2012-01-12
1,860 reads
SSRS - Embedded Custom Code
When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting...
2012-01-12 (first published: 2012-01-05)
4,694 reads
Check Version of SharePoint 2010 Currently Installed
There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up...
2012-01-11
1,749 reads
Choosing the right professional
I’m writing this blog post from my bed, you may think that’s a little too much information there is a...
2012-01-11
484 reads
Houston Area SQL Server User Group Presentation
Thanks for everyone who attended my presentation “How To Make a LOT More Money as a Consultant” at HASSUG.
Here is...
2012-01-11
606 reads
Normalizing Your Database
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process...
2012-01-11 (first published: 2012-01-06)
5,085 reads
SQL Server – Backup to NUL trick - read throughput
A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's...
2012-01-11
962 reads
System Stored Procedures
I've been using 4 alerts for corruption now for about 2 years for Errors 823, 824, 825 and 9100. Basically...
2012-01-11
1,052 reads
Video/Voice conferencing and Microsoft Lync
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...
2012-01-11
1,025 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