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,253 reads
SQLSailor.com
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 I’m super excited about this! With Windows Server 2016,...
2016-12-22
2 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,585 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 logs to see if there is anything out of...
2016-11-07
2 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,190 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 based on some of my test cases(A detailed blog...
2016-06-30
2 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,077 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 upgrade of SQL Server. Are you thinking of upgrading...
2016-05-01
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)
2,032 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 SELECT * FROM sys.messages? The query will return a...
2016-03-07
2 reads
Blogs
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
Forums
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Putting the Player with the Number
Comments posted to this topic are about the item Putting the Player with the...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers