Automated Disk Space Alerts For Windows Server
PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...
2012-09-22
117 reads
Vacation and SQLSat149
When I was considering submitting some sessions to SQL Saturday 149 in Minnesota I thought I would have a difficult...
2012-09-22
805 reads
SQL Server: Part 2 : Approaching Database Server Performance Issues
In the Part 1, we have seen how quickly we can check the runnable task and I/O pending task on...
2012-09-28 (first published: 2012-09-21)
3,789 reads
Mac Daddy!
In my Three Strikes post I wrapped up the sorry tale of trying to get an X1 Carbon delivered from...
2012-09-21
791 reads
Notes from My 24 Hours of PASS Presentation
Quick notes:
Because it was scheduled for 7 am local I decided to do it from home. Good plan, except it...
2012-09-21
824 reads
Transact-SQL analytic functions in SQL Server can help solve problems quickly
Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical tasks. With the...
2012-09-21
1,537 reads
PASS Elections 2012
Yeah, it’s that time again. And we have a magnificent slate of people running. I mean truly amazing and wonderful...
2012-09-21
711 reads
Verify those Backups
It’s important that you backup your database. The most important thing you can do. However making backups isn’t enough: you...
2012-09-21
877 reads
SQL Server Data Tools (SSDT) – September 2012 update
SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225). The SSDT team...
2012-09-21
1,604 reads
SQLTreeo resurrection
I would like to inform you that I transferred all activities around SQLTreeo SSMS Add-In to couple of persons who...
2012-09-21
772 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
Execute as failure
Security has long been a problem for me. Every time I think I understand...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers