SQL Server 2017 in a Docker Container running on a Mac – Tips and Tricks
I started using a MacBook Pro at work, and the very first thing I did was configure SQL Server 2017...
2018-02-23
473 reads
SQLSailor.com
SQL Server 2017 running on Windows Containers!
One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is...
2017-05-10
2,257 reads
Google Cloud Spanner – Next big thing in the database world?
Last month Google announced the public beta for Cloud Spanner, and I would like to share few details around this...
2017-03-14
762 reads
Windows Server 2016 and SQL Server 2016 – A match made in heaven!
For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why...
2016-12-22
1,235 reads
When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config
Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error...
2016-11-07
1,043 reads
AlwaysOn Availability Group Database Level Health Detection – SQL Server 2016
SQL Server 2016 AlwaysOn AG got many improvements, and I’m pretty impressed with the log throughput improvements and redo improvements...
2016-07-08 (first published: 2016-06-30)
7,137 reads
Why you should think about upgrading to SQL Server 2016!
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide...
2016-05-01
3,040 reads
Curious case of SYS.MESSAGES
A strange error struck me last week, and this post is all about that.
What you normally expect when you run...
2016-03-15 (first published: 2016-03-07)
1,515 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
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
1,277 reads
SQL Server 2016 CTP 3 Setup – UI Improvements
There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making...
2015-11-11
782 reads
Blogs
Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic
By Devin-Knight
Welcome back to my series on Power Platform quick tips! In this episode you...
State of Database DevOps Survey
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...
HP is the 2019 Laptop Winner
By Steve Jones
This is for me, not necessarily for you, but I decided to go with...
Forums
Insert in batches using select coalesce option
Hi, I am trying to insert multiple tables data into one table using Insert...
Fastest Way to Calculate Total Number of records inserted per day
Hi, I need to show a number of records per day in the dashboard...
Fastest way to query Millions of records with Pagination and Total Record Count
HI, We had a table that contains a huge volume of data inserted per...
Ask SSC