Daily Coping 10 Aug 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-10
20 reads
Blog Posts
Faster, More Flexible Editing of Your Sidebars, Headers, and Footers: Blocks for Widgets
Great news: the block editor you’re familiar with in pages and posts is now part of the widgets editor.
2021-08-10
17 reads
T-SQL Tuesday #141 Work/Life Balance
This month’s T-SQL Tuesday is hosted by TJay Belt (@tjaybelt). I find this month’s topic, balancing work and life, intriguing, and after a hiatus of non-blogging, I’m happy that...
2021-08-10
25 reads
Creating SQL Databases in AKS with PVC – Part 2
Last week I created the below with a dummy database and is something that I will do against SQL server but this time that has a persistent volume claim....
2021-08-09
50 reads
Daily Coping 9 Aug 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-09
13 reads
Data Mesh: Centralized ownership vs decentralized ownership
I have done a ton of research lately on Data Mesh (see the excellent Building a successful Data Mesh – More than just a technology initiative for more details),...
2021-08-09 (first published: 2021-07-23)
368 reads
How do I unlock a SQL Server Login using T-SQL (without changing the password)?
We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a ... Continue reading
2021-08-09 (first published: 2021-07-22)
810 reads
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric,...
2021-08-09
91 reads
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric,...
2021-08-09
4 reads
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to CPU, Memory, and network and disk IO using resource constraints, sometimes called Limits. You define...
2021-08-06 (first published: 2021-07-25)
1,021 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers