SQL Server: DATETIME vs DATETIME2
When it comes to a choice between data types for a field in a SQL Server database's table, an issue that is frequently discussed in popular forums is a...
2017-02-06
50 reads
Blog Posts
SQLPort V2
The new site of SQLPort is finally live. This is not just a redesign of the original site, published in...
2017-02-06
302 reads
Still Grateful to Rodney Landrum
So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had...
2017-02-06
440 reads
Dark Theme in Office 2013 & 2016
Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and...
2017-02-05
4,889 reads
Dark Theme in Office 2013 & 2016
Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk. As...
2017-02-05
144 reads
Dark Theme in Office 2013 & 2016
Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk. As...
2017-02-05
158 reads
Friend of Redgate – 2017
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective...
2017-02-05
702 reads
Friend of Redgate – 2017
I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2017-02-05
6 reads
I have been hacked
I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.
The post I have been hacked...
2017-02-05
601 reads
SQLite and the Performance Implications of Indexes
Indexes make an enormous difference in the read speed of a databases. I have previously mentioned that adding proper indexes...
2017-02-05
554 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers