Docker Containers and Persistent Data
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-11-19
18 reads
Docker Containers and Persistent Data
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-11-27 (first published: 2019-11-19)
2,394 reads
Cursor Dynamic SQL
Today was working on SQL Server cursor standard cursor deification would be like this: sqlcursor from (Azure Data Studio) ———————————————————————————————————————– — Declare a cursor for a Table or a View ‘TableOrViewName’ in schema ‘dbo’ DECLARE @ColumnName1 NVARCHAR(50), @ColumnName2 NVARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT name FROM dbo.TableOrViewName OPEN db_cursor FETCH NEXT FROM db_cursor INTO @ColumnName1, @ColumnName2 WHILE @@FETCH_STATUS = 0...
2019-11-19
346 reads
How to get the Active Directory user password policy values
Recently I have had to troubleshoot quite a bit of SQL login issues and often times the issue was with the users active directory user account.I was aware the...
2019-11-18
1,163 reads
How do you use PowerShell toc check if an active directory user locked out, disabled etc.?
If your organization uses a password policy (there are very good odds these days that it does) and, especially stricter password requirement for administrative users, your might have experienced...
2019-11-26 (first published: 2019-11-18)
1,042 reads
Build a SQL Cluster Lab Part 4
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. […]
The post Build a...
2019-11-18
29 reads
Build a SQL Cluster Lab Part 4
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only...
2019-11-18
17 reads
Build a SQL Cluster Lab Part 4
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only...
2019-11-18
41 reads
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be ... Continue reading
2019-11-18
40 reads
SQL Undercover TV – Encrypting SQL Backups
In this episode, David looks at how we can encrypt our SQL Server backup files
2019-11-26 (first published: 2019-11-18)
260 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers