Building a Kimball Data Warehouse
Introduction I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was pretty cool. With the advent of ‘Big Data’, the various cloud offerings, Big Table, Hadoop, python, Atlas/Atlas SQL, etc., the question arises: is the tradit …
The SQL Server Advice You Don’t Wanna Hear
One of the big principles of our SQL ConstantCare® monitoring product – which happens to be free this month – is that we only wanna tell you things you’re actually gonna take action on. Anytime we email you advice, there a few “ …
Poll Results: Are You Going Back to In-Person Events?
Last week, I asked if y’all had been to in-person regional events before, and whether you were going back. I wanted to know because Data Saturdays and SQL Saturdays are starting to happen again, but … attendance seems way down from pre-COVI …
Manipulating Data In PostgreSQL: Learning PostgreSQL with Grant
So far in the series I’ve shown how to create databases, tables, constraints, indexes and schema. Now, it’s time to put some of that information to work and begin the process of manipulating data within the database. After all, a database i …
Flyway for SQL Server Data Tools Users
The post Flyway for SQL Server Data Tools Users appeared first on SQLServerCentral.
T-SQL Scripts to generate the HTML-formatted database storage report
This article explains the T-SQL scripts that can be used to manage and monitor the disk space on the database server. The T-SQL script contains queries to populate the following details. List of drives, size of disk, and percentage available space Data …
Multiple Relationships on the same Table in a Power BI Data Model
The post Multiple Relationships on the same Table in a Power BI Data Model appeared first on SQLServerCentral.
A Guide to INSERT, UPDATE, and DELETE Statements in Oracle
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE. These commands are used to insert new data into tables, update existing data, and delete data from tables, respectively. In this arti …
Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders
The post Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders appeared first on SQLServerCentral.
PostgreSQL Copy
Article Overview In this article, we will discuss the ‘COPY’ functionality of PostgreSQL database which is one of the most important and often used features in practical world. There are two variants of ‘COPY’ statement, copy a database and copy a tabl …
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
The post Data Transfer from Snowflake to Azure Blob using Synapse Analytics appeared first on SQLServerCentral.
30%-off health checks and self-service via credit card – no waiting!
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget approval, just click and go! Once you purchase the health check, you get access to our health check pac …
[Video] Office Hours at Sea: Leaving Juneau
I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:42 Dirty_Pages: You mentioned recently how much you swear, what is your favorite swea …
Unmasking SQL Server Dynamic Data Masking – Part 2 – Setting up Masking
This is the second part of a series on SQL Server Dynamic Data masking. The first part in the series was a brief introduction to dynamic data masking, including use cases. The focus of this blog will is setting up masking and some base examples. Config …
[Video] Office Hours in Glacier Bay, Alaska
Thankfully, we didn’t hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:29 gb DBA: Hi Brent, I have over 200 …