210 blogs updated: 28 min. ago
SQL Server (47)PostgreSQL (56)MySQL (27)Oracle (72)Mishmash (6)
SQL SERVER – Backup Error: 3636 – An Error Occurred While Processing BackupMetadata
Recently one of my old clients contacted me and informed that they are having an issue with database backup on the secondary replica. In thi...
19-07-2018 04:28:02 Pinal Dave SQL Server
Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5
Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert S...
19-07-2018 04:17:58 Simple Talk SQL Server
Speaking At DOAG 2018 Conference And IT Tage 2018
I will be speaking at the yearly DOAG conference in December as well as at the IT Tage in November. My talk will be "Oracle Optimizer System...
18-07-2018 23:00:05 Randolf Geist Oracle
Manual Tagging: The Stick in your Analytics Bicycle Spokes
Whenever you implement a complex process like web or mobile analytics, it can be challenging to figure out if it's working optimally, or eve...
18-07-2018 22:49:39 Heap Analytics PostgreSQL
New release of pspg - 1.2.0
This release can be fully configured from menu (themes can be selected from menu too). The setting can be persistent to file /.pspgconf:
18-07-2018 22:47:16 Pavel Stehule PostgreSQL
Spoofing Data Convincingly: Masking Continuous Variables.
In any real numeric data from a database , you are only rarely going to see any sort of normal distribution of the values. Sales data will r...
18-07-2018 21:27:03 Simple Talk SQL Server
pg_rewind and checkpoints: caution!
pg_rewind, introduced in PostgreSQL 9.5, is a powerful utility solving a particular problem: If you have a promoted a streaming replication ...
18-07-2018 18:43:15 The Build (Christopher Pettus) PostgreSQL
PGInstaller – A Step by Step Guide to install PostgreSQL
Here's a step by step guide to install PostgreSQL on your machine using PGInstaller. PGInstaller supports three modes of installation; Graph...
18-07-2018 17:27:04 2nd quadrant PostgreSQL
Recently someone mentioned the LOADHISTORY option of RESTORE. It's not horribly hard to find in BOL but it wasn't the ... Continue reading
18-07-2018 16:04:31 Kenneth Fisher SQL Server
A Quirk In Parallel Hash Join Plans
Bailing, Takes Me Away Both of these queries will return zero rows, in the 2010 version of the Stack Overflow database. [crayon-5b4f4747dda6...
18-07-2018 16:01:53 Brent Ozar 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.