SQL Homework – January 2020 – Create an End of Year/New Year checklist.
It’s a brand new year and hopefully it will be better than last year. While that may be particularly true ... Continue reading
2021-01-05
6 reads
Blog Posts
Stellar Repair for MS SQL - Product Review
Stellar Data Recovery has an amazing product designed for the Microsoft SQL Server platform to provide data recovery solutions where databases or backups get corrupted, login passwords are unknown,...
2021-01-05
241 reads
Stellar Repair for MS SQL - Product Review
Stellar Data Recovery has an amazing product designed for the Microsoft SQL Server platform to provide data recovery solutions where databases or backups get corrupted, login passwords are unknown,...
2021-01-05
7 reads
Syncing SQL databases
There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use...
2021-01-05 (first published: 2021-01-04)
903 reads
[MSSQLTIPS] Rookie of the Year Candidate – Vote for ME
Welcome to the New Year of 2021. For some people I know, they might prefer to forget most if not all of 2020. Personally, I am not one...
2021-01-04
20 reads
2020 Year in Review
Yeah, so…that was a hell of a year, wasn’t it?
Short-Form Reviews of Year 2020 Reviewer #1: 👎
Reviewer #2: ★✩✩✩✩, would not recommend
Best Laid Plans… The year started out really...
2021-01-04
4 reads
Daily Coping 4 Jan 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-01-04
10 reads
Simple Method to Add A Network in SQL Configuration Manager
In this article I have demonstrated a fairly simple method to help you modify your network adapters that are presented to SQL Server.
The post Simple Method to Add A...
2021-01-04 (first published: 2020-12-28)
555 reads
Splitting up the Mission of PASS
Following up on Should There Be A Successor to PASS? I have a couple more thoughts. One of the many complaints about PASS over the years was about perceived value....
2021-01-04 (first published: 2020-12-28)
543 reads
SQL PowerShell to check and repair Ad-hoc distributed queries Vulnerability
Introduction Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to connect to remote data sources that use OLE DB. As the name suggests, ad-hoc distributed queries should...
2021-01-04
315 reads
Blogs
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...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers