Setting up Change Data Capture (CDC)
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
17,727 reads
Introduction to SQL Server replication
This time I'll talk about some basis with SQL Server replication, whether you need it for High availability (HA), Disaster...
2017-10-03
729 reads
VS Code: PowerShell and focusConsoleOnExecute
If you're used to the behavior of SSMS or PowerShell ISE where upon executing code in the script panel, your...
2017-10-03
499 reads
Always update your views
I last posted about changing a table without changing a view that represents the table and how this may affect...
2017-10-03
365 reads
Book Review: High Performance SQL Server
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
395 reads
The New CU Schedule
Is my math right? The new CU servicing schedule for SQL Server 2017 is:
1 CU per month for the first...
2017-10-03
1,083 reads
SQL Server Tracking Tempdb Size
Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...
2017-10-03
501 reads
3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week’s interview with Drew on YouTube.
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you’ve had...
2017-10-03
151 reads
3 Tips You Need To Know When Using PowerShell with SQL Server
Watch this week's video on YouTube
Have you ever had to perform repetitive tasks in SQL Server?
Maybe you've had to manually verify backups, script out all of a server's logins/groups/permissions,...
2017-10-03
14 reads
Deploy SSAS Cubes With PowerShell
Hello!
Recently someone got in touch with me about one of my earliest posts on my old blog. I realised I...
2017-10-03
1,121 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
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...
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