Azure SQL Managed Instance – Cost Saving!
We all would like to save money when operating in the cloud, Microsoft has released a stop / start concept for SQL Managed Instances – preview mode! At the...
2023-01-12
50 reads
Blog Posts
Daily Coping 12 Jan 2023
Today’s coping tip is to write a list of things you feel grateful for and why. My wife – our relationship continues to grow, and I cherish this after...
2023-01-12
17 reads
Daily Coping 11 Jan 2023
Today’s coping tip is to do a kind act for someone else today to brighten their day This is one I’ve done before, but this tip reminded me to...
2023-01-11
10 reads
Power Automate: Sending Emails As A Different User
A common frustration when sending emails from Power Automate is how to force Power Automate to send your emails from a specific user. While there
2023-01-11 (first published: 2023-01-04)
440 reads
Running SQL Server on Apple Silicon
Last week I purchased a shiny new MacBook Air with an M2 processor. After I got all the standard stuff up and running, I set out to learn how...
2023-01-11 (first published: 2023-01-02)
757 reads
The Database DevOps SeQueL with SQL Solutions Group
Next week, on Jan 18, 2023, I’m doing another webinar with the SQL Solutions Group. This is the SeQueL to our first webinar on Database DevOps. You can register...
2023-01-11
13 reads
Daily Coping 10 Jan 2023
Today’s coping tip is to make time to do something kind for yourself. Learning to better take care of myself is something that I’ve been working on throughout the...
2023-01-10
12 reads
The Cost of not Following the Regulations Around Data
Brent Ozar shared in his weekly links this week a GDPR penalty tracker which makes for thought-provoking reading. Regular readers of this blog will know I have a keen...
2023-01-10
23 reads
T-SQL Tuesday #158–Implementing Worst Practices
Not that I’m looking to do this, but that’s the invitation from Raul Gonzalez this month. This is the monthly blog party where we write on a topic chosen...
2023-01-10
136 reads
Book Review – Designing Data-Intensive Applications
The book Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems by Martin Kleppmann was recommended to me by a colleague. The author has worked at companies...
2023-01-09 (first published: 2022-12-29)
210 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
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
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...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers