Getting Row Numbers with Window Functions–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a recent post, I started looking at...
2021-07-14
137 reads
Blog Posts
Build a Blogging Habit with Reminders in Your WordPress App
Meet your posting goals on your site with this new feature in the iOS and Android apps.
2021-07-13
26 reads
Daily Coping 13 Jul 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-07-13
13 reads
Creating a Distribution List in SQL Multi Script
SQL Multi Script is a lesser known tool from Redgate Software that is designed to easily allow you to run scripts against many server instances with one click of...
2021-07-12
392 reads
Daily Coping 12 Jul 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-07-12
24 reads
Monitoring your Chatbot in Power Virtual Agents
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a guided, no-code graphical interface. In this video you will learn how
2021-07-12 (first published: 2021-06-30)
152 reads
Using Readable Secondary in Azure SQLDB
When using a Geo Replicated Azure SQL Database Readable Secondary there are a few things to consider when it comes to performance tuning. Check out this episode of Data Exposed:...
2021-07-12 (first published: 2021-06-30)
274 reads
Webinar on Data Security and Compliance
Tomorrow, July 13, 2021, I will be giving a webinar on data security and compliance. Here’s the sign-up link: SQL Server Data Security and Compliance sign-up (free, but registration...
2021-07-12
42 reads
RIP Brian Moran
When someone older than you dies, it’s sad, though I feel that I can cope. I hold memories dear, I appreciate the time I had with an individual, and...
2021-07-11
215 reads
AI is going to be everywhere and in everything
I recently was a part of GestaltIT’s AI Field Day and have been thinking heavily about artificial intelligence (and by extension, machine learning and deep learning) lately. I put...
2021-07-09 (first published: 2021-06-28)
256 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