SQL Server: What will REPAIR do?
So I had a corruption issue and I was thinking about running repair but I wanted to know what would...
2017-10-24 (first published: 2017-10-16)
2,082 reads
Permissions required for developing with Temporal Tables
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table...
2017-10-26 (first published: 2017-10-16)
1,843 reads
Using Backup-DbaDatabase for a Quick Backup
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-10-16
621 reads
How to Perform and schedule SSAS Backups ?
Steps to configure schedule SSAS Cube \ OLAP database backups :-
1. For each SQL Server Analysis Services Environment. In order to...
2017-10-16
1,425 reads
Non Profit Umbrella Org – Good Idea?
Note: Published too soon, so lots of edits from the first version. Sorry for any confusion.
I had a question from...
2017-10-24 (first published: 2017-10-14)
1,245 reads
More Notes on Non Profit Status
Following up on my post about forming a non profit here in Orlando, here are some notes that might help...
2017-10-14
447 reads
SQL Replication SubscriptionStreams setting
In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be...
2017-10-23 (first published: 2017-10-14)
6,998 reads
Your Name is Your Brand
Building your brand is not an overnight sensation. It does take a while and possibly a bit of luck here or there along the way. The one thing it...
2017-10-13
5 reads
Your Name is Your Brand
This topic is one that has been stewing for a while and finally this week it decided to boil over.
My...
2017-10-13
480 reads
Getting the Random Module in SQL Data Generator
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-12
592 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