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
Blog Posts
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
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-04
23 reads
Top 3 Easy Help Queries for XEvents in Azure SQL
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
13 reads
Top 3 Easy Help Queries for XEvents in Azure SQL
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
14 reads
Top 3 Easy Help Queries for XEvents in Azure SQL
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
34 reads
What A Year That Was
If anything, 2020 is an asterisk. Some lost their jobs. Some lost their loved ones. Perhaps more books will be written about it. Pundits will keep the conversation going....
2021-01-04
18 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
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...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
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