Use SQL 2008 Express As A Central Management Server
I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he...
2009-04-20
895 reads
Kendal Van Dyke
Full Text Catalog Scripting "Gotcha" in SSMS 2008
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
588 reads
Undocumented Trace Flag Improves Performance By Up To 25%
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
541 reads
Orlando .NET Code Camp 2009 Recap
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,450 reads
Launch Replication Monitor Without SSMS
I manage a lot of replication publications\subscriptions and when I get a latency or agent failure alert it always bugs...
2009-03-25
855 reads
Ada Lovelace Day – Celebrating Women In Technology
Today is Ada Lovelace Day, an international day of blogging to draw attention to women excelling in technology. I don't...
2009-03-24
743 reads
Data Mining With Google Insights For Search
I recently read a NYT article that highlighted how Google search data is being used to predict flu outbreaks at...
2009-03-23
855 reads
Upcoming Speaking Engagements
I've got three speaking engagements lined up in next two months:
Wed, March 11 @ oPASS: The Truth About Disk Performance & Configuration....
2009-02-26
1,409 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
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