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
345 reads
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
21 reads
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
17 reads
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-13 (first published: 2021-01-04)
210 reads
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
40 reads
PASS will close down their websites on 15 Jan 2021. That’s just a couple weeks away, and if you’re someone that paid for a year of PASS Pro access,...
2021-01-08 (first published: 2021-01-04)
283 reads
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
23 reads
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
35 reads
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)
997 reads
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
20 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers