March OPASS Meeting Recap
We had a great turnout of 25 people for last night’s OPASS Meeting sponsored by Quest Software.
We started the meeting...
2010-03-10
377 reads
More posts coming soon...
Haven't been around for a while, but doing some interesting work with Database Refactoring and Effective Dating...more posts coming soon....
2010-03-10
596 reads
PASS Summit to Stay in Seattle
PASS has released the survey results as well as its decision about where to hold future Summit events. The decision...
2010-03-10
1,986 reads
Help Us Update the PASS Blog Directory
We put this together last year and we’re up to 270 blogs listed, but I’m sure we’re still missing some,...
2010-03-10
515 reads
The Key at SQL Saturday #33
For the handover of SQLSaturday to PASS, Rushabh Metha, President of PASS, came to the Charlotte SQL Saturday, where Andy...
2010-03-10
917 reads
SQLIse A Powershell Based SQL Server Query Tool
SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of...
2010-03-10
1,977 reads
How to Easily Log SQL Server 2008 Instance Level Metrics
If you want to record the results of some useful, instance level DMV queries somewhere where you can easily query...
2010-03-09
1,177 reads
Happy Belated International Woman's Day - C'est Votre Jour Les Femmes !
Yesterday was International Woman’s Day – Let’s take the time to honour a few great women at the top!
Firstly, to Her...
2010-03-09
1,032 reads
Using a CTE with a T-SQL Pivot Statement
During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a...
2010-03-09
9,615 reads
My Adventures with the SQL 2005 Security Cache
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
506 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
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....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers