Please, Call Me Richard
I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good....
2012-08-28
1,283 reads
The INSTALLSHAREDWOWDIR command line value is not valid.
I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly...
2012-08-28
1,585 reads
Say Seminar, Not Pre-Con for SQLSaturday
I read a note posted on the OPASS LinkedIn site today about our upcoming SQLSaturday and the two pre-cons by...
2012-08-28
1,031 reads
Enable Transparent Data Encryption
This is one of the things in my Encryption Primer presentation that I don’t demo. It’s really easy to do,...
2012-08-30 (first published: 2012-08-28)
4,068 reads
PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it
I recently had the need to script the execution of a command-line utility and thought it would be a good...
2012-08-29 (first published: 2012-08-28)
28,574 reads
A Novel Workaround for an Infamous SSAS Connection Error
For months I’ve been itching to get the latest version of SQL Server, thanks to the addition of new functionality...
2012-08-28
1,925 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. With proper planning and attention to...
2012-08-27
88 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data...
2012-08-27
3,898 reads
The Embarcadero – SQL in the City San Francisco
I love San Francisco. It was one of the cities that I thought I might live in someday. My kids...
2012-08-27
1,083 reads
PASS Election Season
Did you know that it’s election season for PASS? Did you know that you can pose questions to the potential...
2012-08-27
620 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