Becoming the dumbest guy in the group
“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I...
2012-04-19
780 reads
Why Isn’t There A Deployment Server Edition For SSIS Projects?
Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any...
2012-04-19
1,525 reads
More IMPORTANT miscellaneous info
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.
Okay,...
2012-04-19
1,282 reads
PowerShell: Using Exponents and Logs to Format Byte Sizes
In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to...
2012-04-19
3,997 reads
Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE...
2012-04-19
43 reads
SQL Server 2012 Performance Test: Gap Detection
Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...
2012-04-19
3,298 reads
Log shipping setup problem
Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping....
2012-04-18
2,635 reads
Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with...
2012-04-18
232 reads
Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers
If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is...
2012-04-18
2,189 reads
sys.sql_modules vs. INFORMATION_SCHEMA.Routines
Consider the following two queries meant to search for a keyword in SQL programmability objects.
select s.name +'.' + o.name, o.type_desc, m.definition
from sys.sql_modules...
2012-04-18
1,984 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