Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable. The transport security involves encryption of packets exchanged between the...
2016-01-28
13 reads
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
2,202 reads
This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.
In...
2016-01-27
1,166 reads
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
507 reads
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...
2016-02-03 (first published: 2016-01-27)
3,375 reads
By Steve Bolton
…………The last installment of this amateur series of self-tutorials was the beginning of a short detour into using...
2016-02-02 (first published: 2016-01-26)
1,537 reads
Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ...
2016-01-26
533 reads
I’m happy to announce that my first public session of 2016 will be at SQLSaturday Chicago on March 5! I...
2016-01-26
432 reads
Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power...
2016-01-26
1,029 reads
No.
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a...
2016-01-26
518 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers