Adding a user to an Azure SQL DB from Blog Posts – SQLServerCentral
Creating a user is simple right?
Yes and no. First of all, at least in SSMS it appears you don’t have a GUI. I don’t...
Deploy SSRS Projects with Two New PowerShell Commands from Blog Posts – SQLServerCentral
I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig...
Hans-Juergen Schoenig: pg_squeeze: Optimizing PostgreSQL storage from Planet PostgreSQL
Is your database growing at a rapid rate? Does your database system slow down all the time? And maybe you have trouble understanding why...
[Solved] SQL Backup Detected Corruption in the Database Log from Blog Posts – SQLServerCentral
Summary: In this article, we will discuss about the ‘SQL Backup Detected Corruption in the Database Log’ error. It will also describe the reason...
Azure Stack and Azure Arc for data services from Blog Posts – SQLServerCentral
For those companies that can’t yet move to the cloud, have certain workloads that can’t move to the cloud, or have limited to no...
External tables vs T-SQL views on files in a data lake from Blog Posts...
A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between...
SQL Homework – December 2020 – Participate in the Advent of Code. from Blog...
Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect of life. And this...
Tom Swartz: Tuning Your Postgres Database for High Write Loads from Planet PostgreSQL
As a database grows and scales up from a proof of concept to a full-fledged...
Daily Coping 22 Dec 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
Power BI – Hungry Median from Blog Posts – SQLServerCentral
Introduction
Median is a useful statistical function, which first time appeared in SSAS 2016 and in Power BI around that year as well. There are...