SQL Sequence vs Identity Column
Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you...
2017-10-04
5,253 reads
Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...
2017-10-04
317 reads
Limiting resources available to containers
One question that I get asked regularly is, “can you limit the host resources to individual containers?”
This is a great...
2017-10-04
457 reads
What Do You Get if You Unpack an Ispac?
I’ve spent what feels like a lifetime working on automating SSIS deployments, more specifically SSIS packages that have been created...
2017-10-04
2,858 reads
How the gym made me a better database bloke…..
A blog post about how many reverse bicep curls or Romanian DeadLiftsI can do…? As Rob Farley (t | b | w)...
2017-10-04
493 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 Recovery (DR), load balance your applications or any other...
2017-10-04
29 reads
tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
628 reads
tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
87 reads
tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which...
2017-10-03
95 reads
tSQLt Test Adapter for Visual Studio 2017
So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which lets you run tSQLt tests from within Visual Studio...
2017-10-03
16 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