Blog: Michael Swart


210 blogs updated: 76 min. ago
Are There Any System Generated Constraint Names Lurking In Your Database?
Names for constraints are optional meaning that if you don't provide a name when it's created or cannot afford one, one will be appointed to...
4
06-04-2018 16:43:31 Michael Swart SQL Server
T-SQL Options for Comparing "Distinctness"
I had the privilege of listening to Itzik Ben Gan talk about "distinctness" in a talk he gave at PASS Summit. Distinctness is a relationship...
8
26-03-2018 15:00:05 Michael Swart SQL Server
"Failed to initialize deadlock control, Key cannot be null" When Viewing Deadlock Graphs
I recently got this error in Management Studio when trying to view a deadlock graph that was collected with an extended events session: Fail...
12
15-03-2018 15:35:16 Michael Swart SQL Server
My Trip to the West Coast
I was at the MVP Global Summit last week in Redmond, Washington. I was excited to go because I hadn't been to the summit since 2014. Since I...
4
12-03-2018 17:44:14 Michael Swart SQL Server
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


© 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.