Blog: Michael Swart

208 blogs updated: 76 min. ago
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
A Program to Find INSERT Statements That Don't Specify Columns
I've got a program here that finds SQL in procedures with missing column specifications. Table Columns Are Ordered Even though they shouldn'...
22-02-2017 14:51:21 Michael Swart SQL Server
Generate Permutations Fast using SQL
If you google "generating permutations using SQL", you get thousands of hits. It's an interesting problem if not very useful. I wrote a solu...
14-02-2017 17:43:24 Michael Swart SQL Server
What Does "monitorLoop" mean in the Blocked Process Report
Some trivia for your Friday. I recently got a question asking about what the attribute "monitorLoop" is in the blocked-process-report becaus...
10-02-2017 16:46:57 Michael Swart SQL Server
Case study: Troubleshooting Doomed Transactions
Another recap of a problem we recently tackled where we had to find out why a doomed transaction was still trying to do work. A doomed trans...
16-01-2017 15:18:36 Michael Swart SQL Server
That Time We Fixed Prod Without Admin Credentials
Merry Christmas readers! It's story time. This is about a problem I encountered a few weeks ago. We were looking at a production site using ...
22-12-2016 15:07:54 Michael Swart SQL Server
Learn About SQL Server in the Waterloo Region
I want to talk about a couple free talks coming up here in Kitchener Ontario. Drawing Conclusions, December 12, 2016 At D2L, we created a ne...
01-12-2016 16:46:32 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.