DELETE data on SQL Server HEAP table – Did you know…
Before I complete my question let me provide context. I've received an alert saying that a specific database could not...
2017-10-04 (first published: 2017-09-26)
2,683 reads
Cláudio Silva
- Website: https://claudioessilva.eu
DELETE data on SQL Server HEAP table - Did you know...
Before I complete my question let me provide context.
I’ve received an alert saying that a specific database could not allocate a new page (disk was full)
The message that you...
2017-09-26
9 reads
PowerShell Modules Central - Share with community - What PowerShell modules are you using?
Like the blog post title states this is all about sharing with others! My idea is to share with the community which PowerShell modules you are using.
PowerShellModulesCentral is a...
2017-09-19
2 reads
Generate Markdown Table of Contents based on files within a folder with PowerShell
Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository.
He wrote a cool blog post - Generating...
2017-09-18
7 reads
[PowerShell] From 20 minutes to 20 seconds - Change domain user password on multiple domains without login into each one
I’m working on a environment where I have to deal with multiple domains. The user’s password needs to be updated each 40/45 days (it depends on the domain).
Because I...
2017-09-14
10 reads
Someone is not following the best practices – dbatools and Pester don’t lie!
This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell (b | t) and we will "Let’s...
2017-09-12
717 reads
“Invalid class [0x80041010]” error when trying to access SQLServer’s WMI classes
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have...
2017-09-07
1,413 reads
'Invalid class [0x80041010]' error when trying to access SQLServer's WMI classes
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have on a bunch of hosts so I could confirm...
2017-09-07
39 reads
HTTP 403 error – PowerShell Remoting, Different Domains and Proxies
On my day to day work I use Nagios monitoring software. I want to add some custom SQL Server scripts...
2017-09-04
1,824 reads
Offline Microsoft Documentation? Download it!
On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip...
2017-08-30
3,092 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers