SQL Homework – October 2018 – Time for an upgrade
When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was...
2018-10-01
312 reads
Blog Posts
Missing Index Recommendations, These Are Not The Indexes You’re Looking For
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
147 reads
Missing Index Recommendations, These Are Not The Indexes You're Looking For
Picture the scene….. DBA Doug is sitting in his cubicle minding his own business when App Dev Allister gives him...
2018-09-29
163 reads
Azure Cognitive Services – Vision APIs
In this final post of my Azure Cognitive Services week of Azure Every Day, I’ll focus on the Vision APIs...
2018-09-28
314 reads
Don’t Just Rely on Query Execution Stats for T-SQL Execution
I recently had an incident where I was looking into the cause of a long running process for a client....
2018-09-28 (first published: 2018-09-18)
2,097 reads
Moving Objects to a New Schema
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-09-28 (first published: 2018-09-20)
6,640 reads
Native UTF-8 Support in SQL Server 2019: Savior or False Prophet?
(last updated: 2018-12-26 @ 16:20 EST / 2018-12-26 @ 21:20 UTC )
(NOTE: For recent update, please see “Update for CTP 2.2” section)
For some...
2018-09-28
10,758 reads
Off to #SQLSat Pittsburgh
I’ve never been to Pittsburgh. Actually, in all of my speaking and traveling, I don’t think I’ve even flown through...
2018-09-28
973 reads
Understanding a UK Keyboard for a US developer
One of the very interesting parts of my job is that I run into UK keyboards on a regular basis....
2018-09-28
1,015 reads
Azure Cognitive Services – Speech APIs
This week in my Azure Every Day posts, I’ve been focusing on Azure Cognitive Services and what these features can...
2018-09-27
331 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers