TSQL Tuesday 96: Folks Who Have Made a Difference
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
5 reads
Cláudio Silva
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
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
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers