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
152 reads
Blog Posts
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
366 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
Box-and-whisker plot and data patterns with R and T-SQL
R is particularly good with drawing graphs with data. Some graphs are familiar to most DBAs as it has been...
2017-10-03 (first published: 2017-09-25)
2,662 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,124 reads
Haunted SQL
I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about...
2017-10-03
342 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
730 reads
Power BI Custom Visuals Class (Module 70 – Custom Calendar By Akvelon)
In this module you will learn how to use the Custom Calendar by Akvelon. The Custom Calendar by Akvelon is...
2017-10-03 (first published: 2017-09-25)
2,117 reads
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,824 reads
SQL Mirroring, Preserving the Log Chain During Database Migrations
This is a reblog of a post that I originally wrote back in January. After using this technique again last...
2017-10-03
146 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
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
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