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
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers