Custom Quarantine PoSh Prompt
Since I’ve been quarantined at home and working in my office, every day is the same. I can’t go to the gym, or coach, or go to the restaurant,...
2020-05-29
19 reads
TIL: Get-DbaErrorLog
Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in addition to normal DBA stuff™ Today’s dbatools command is Get-DbaErrorLog, which is very similar to...
2020-05-29
45 reads
SOLVED! Untrusted SAS certs after SQL startup
If you've tried doing Backup to URL with SQL Server using a Shared Access Signature (SAS) certificate and received this error: Error: 18204, Severity: 16, State: 1.BackupDiskFile::CreateMedia: Backup...
2020-06-16 (first published: 2020-05-28)
391 reads
An Updated Version of the Power BI Enterprise Deployment Whitepaper is Available
A new version of the Microsoft whitepaper “Planning a Power BI Enterprise Deployment” is now available. Once again, Melissa Coates (b|t) and Chris Webb (b|t) are the authors. I...
2020-06-16 (first published: 2020-05-28)
311 reads
What I learned from “The boy who cried wolf”
I was thinking about the story The boy who cried wolf earlier today and realized that it has some lessons ... Continue reading
2020-06-12 (first published: 2020-05-28)
490 reads
Automate deployment of Azure services with ARM Template (video)
Automation is a useful thing. It allows to avoid many mistakes and saves a lot of time. However, you need to invest some time to get started. At least...
2020-05-28
14 reads
Automate deployment of Azure services with ARM Template (video)
Automation is a useful thing. It allows to avoid many mistakes and saves a lot of time. However, you need to invest some time to get started. At least...
2020-05-28
14 reads
Daily Coping 28 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-28
24 reads
Replicate permissions to new Login/User with dbatools
Continuing to share tips and tricks using dbatools like the Refresh databases that belongs to availability group using dbatools posted a few days ago, today I will share a...
2020-06-12 (first published: 2020-05-28)
3,037 reads
SQL Server Sample Databases
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] To start your learning of SQL Server and testing...
2020-05-28
48 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers