Primary Replica Jobs
This post talks about having primary replica jobs. That is, jobs that will only run on the primary replica of...
2018-04-02
961 reads
Blog Posts
SQL Homework – April 2018 – Indexes
This month we are going to look at a topic near and dear to both database developers and database administrators...
2018-04-02
313 reads
Database Superhero Adventures, April 2018 Edition
Chicago O’Hare AirportI had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold....
2018-04-01
265 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also...
2018-04-01
12 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may...
2018-04-01
404 reads
Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.
This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating...
2018-03-31
700 reads
Azure SQL Database Manage Instance
Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database...
2018-03-31
736 reads
Geometry Objects in SQL Server using Latitude/Longitude coordinates
(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in...
2018-03-31
3,709 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven,...
2018-03-30
869 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
397 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers