dbatools - Exceptions
Who doesn’t like a good red and verbose exception? At PowerShell community we often call it a “sea of red” which we found as something that can be intimidating....
2022-06-27 (first published: 2022-06-07)
328 reads
Cláudio Silva
dbatools - Rich Datatypes
Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...
2022-06-13 (first published: 2022-06-02)
275 reads
A (big) SQLPackage caveat
Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just...
2021-12-29
5 reads
T-SQL Copy & Paste Pattern – Increasing a performance problem
Disclaimer: The title is my assumption because I saw it in the past happening this way. This blog post aims to make you remember something: something that is obvious...
2021-04-29 (first published: 2020-02-21)
1,259 reads
Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,469 reads
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,575 reads
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
5,819 reads
Recover database encrypted modules code with dbatools
This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it's simple to...
2020-09-22
14 reads
When one of your DBA colleagues leaves the company, what is your checklist?
Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. On the professional level, it can be purely technical like SQL Server...
2020-09-03
2 reads
Recover database encrypted modules code with dbatools
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
2,605 reads
Blogs
Daily Coping 31 Jan 2023
By Steve Jones
Today’s coping tip is to take a small step towards and important goal. One...
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my...
Forums
parameterizing a sql server connection
I am parameterizing an sql server connection. There are the following fields: username password...
'DATE' is not a recognized built-in function name
Please assist. I am getting the above error: CREATE VIEW DailyAccountBalances AS SELECT DATE(TransactionDate)...
SSIS Sort Alphanumeric?
Hello, I'm pretty new to SSIS, but I have an Excel source that I...
Ask SSC