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)
336 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)
277 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
7 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
17 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
3 reads
Generate SQL Server Role Member Reports using dbatools and ImportExcel PowerShell modules
This was initial posted on SQL Server Central articles. As one of dbatools' first members, I've been using it for years and it's really my goto tool. This task...
2020-07-31
151 reads
TSQL Tuesday #127 – Non SQL Tips and Tricks – Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
13 reads
TSQL Tuesday
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
3 reads
TSQL Tuesday #127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
TSQL Tuesday 127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
1 reads
Blogs
Summit Launch Pricing Ends June 7
By Steve Jones
The PASS Data Community Summit is back in Seattle this November, the 14-17, 2023....
Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data
Information security and privacy are key in today’s data-driven world. Sensitive data needs to...
Tales From The Field Weekly Wrap Up for the Week of 05-22-2023 Microsoft Fabric Launch & Moving Home Offices
By SQLBalls
Hello Dear Reader! Sorry this is so late, moving houses has gotten me a...
Forums
Not wanting to use a Cursor, but...
Ok, need someone to talk me off the cursor ledge on this one. I...
Better Communication Through Less Messaging
Comments posted to this topic are about the item Better Communication Through Less Messaging
MuleSoft Integration with Azure Key Vault
Comments posted to this topic are about the item MuleSoft Integration with Azure Key...
Ask SSC