Blog: Michael Swart


210 blogs updated: 48 min. ago
SHA1 Collisions in SQL Server
Takeaway: It's been frowned on for a while, but SHA1 is definitely broken for security purposes. In October of 2010, Michael Coles created a...
7
17-01-2018 15:35:08 Michael Swart SQL Server
100 Percent Online Deployments: Stage and Switch
100 Percent Online Deployments How to deploy schema changes without scheduled downtime Introduction Blue-Green Deployment Blue-Green Deploym...
10
15-01-2018 20:14:56 Michael Swart SQL Server
100 Percent Online Deployments: Keep Changes OLTP-Friendly
100 Percent Online Deployments How to deploy schema changes without scheduled downtime Introduction Blue-Green Deployment Blue-Green Deploym...
9
12-01-2018 16:23:35 Michael Swart SQL Server
100 Percent Online Deployments: Blue Green Details
100 Percent Online Deployments How to deploy schema changes without scheduled downtime Introduction Blue-Green Deployment Blue-Green Deploym...
4
10-01-2018 17:01:12 Michael Swart SQL Server
100 Percent Online Deployments: Blue-Green Deployment
100 Percent Online Deployments How to deploy schema changes without scheduled downtime Introduction Blue-Green Deployment Blue-Green Deploym...
6
08-01-2018 18:56:06 Michael Swart SQL Server
100% Online Deployments
100 Percent Online Deployments How to deploy schema changes without scheduled downtime Introduction Blue-Green Deployment Blue-Green Deploym...
10
05-01-2018 16:54:51 Michael Swart SQL Server
When Measuring Timespans, try DATEADD instead of DATEDIFF
Recently I tackled an issue where a DateTime field was getting updated too often. The query looked something like this: UPDATE dbo.SOMETABLE...
15
20-12-2017 18:39:45 Michael Swart SQL Server
Postponing Our Use of In Memory OLTP
Devops, Agile and Continuous Delivery Sometimes I get asked about work and our software development practices. Often these questions use wor...
16
11-11-2017 17:32:40 Michael Swart SQL Server
SQL Server UPSERT Patterns and Antipatterns
Upsert Patterns and Antipatterns Good ways and bad ways to update or insert rows The Setup AntiPatterns Vanilla Solution MERGE Statement Ins...
10
13-09-2017 11:32:40 Michael Swart SQL Server
Solve this Math Puzzle using SQL
IBM holds a monthly math/programming challenge called "Ponder This". This month's problem (July 2017) is an interesting one because it can (...
7
13-09-2017 04:51:39 Michael Swart SQL Server


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.