Blog: Michael Swart

208 blogs updated: 66 min. ago
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...
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 (...
13-09-2017 04:51:39 Michael Swart SQL Server
Problem With Too Many version_ghost_records
We encountered a CPU issue which took over a month to understand and fix. Since then, it's been another couple months and so I think it may ...
12-09-2017 22:11:58 Michael Swart SQL Server
Remove SQL Junk (Brackets and Other Clutter)
Less is More. And we can apply that idea to SQL. If SQL is going to be maintained by a human, it's best to use a style that is easy on the r...
12-09-2017 15:37:10 Michael Swart SQL Server
10 Things I Learned While Working At D2L
Today marks my tenth anniversary working for D2L and it also marks ten years since I specialized in databases full time. I've never worked a...
16-07-2017 22:58:22 Michael Swart SQL Server
Converting from DateTime to Ticks using SQL Server
A .Net tick is a duration of time lasting 0.1 microseconds. When you look at the Tick property of DateTime, you'll see that it represents th...
06-07-2017 17:02:06 Michael Swart SQL Server
A Table Of Contents For the Data Industry
A review of Designing Data-Intensive Applications The Big Ideas Behind Reliable, Scalable, and Maintainable Systems by Martin Kleppman, publ...
24-05-2017 17:11:16 Michael Swart SQL Server
Drawing (again) with SQL Server
You have my permission to skip this post. This one's just for me. So I've been drawing again with SQL Server's spatial results tab, the firs...
05-05-2017 18:10:32 Michael Swart SQL Server
Find Your Dark Queries
If your monitoring solution relies heavily on the statistics of cached queries, then you may not be capturing all activity.
18-04-2017 18:07:13 Michael Swart SQL Server
It's difficult to say anything meaningful about this topic. I can't think of another topic that requires the phrase "it depends" more. And i...
24-03-2017 15:43:37 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.