Learning Tree: SQL Server DBA Skills Upgrade
I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...
2012-05-30
2,135 reads
The Standing Desk Experiment
I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow...
2012-05-29
1,960 reads
SQL Saturday in Rochester Exceeds Expectations
After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle...
2012-05-29
1,765 reads
The SQL in the City US Tour
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,791 reads
Oracle Date issues with PowerPivot
This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the...
2012-05-29
1,279 reads
Building a SQL Server Inventory – Part 1
Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with...
2012-05-31 (first published: 2012-05-29)
5,942 reads
The Rules of Gibbs
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
852 reads
Detecting Database Option Changes with DDL Triggers
One of the keys to managing a large production SQL Server environment is being aware of changes that are taking...
2012-06-05 (first published: 2012-05-29)
5,049 reads
Denali – Day 29: Resource Governor Enhancements (Database Engine)
Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql...
2012-05-29
1,662 reads
Books for Learning Transact SQL
I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months...
2012-05-29
1,124 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