Using Windows Security and Encryption with Flyway
The post Using Windows Security and Encryption with Flyway appeared first on SQLServerCentral.
Working with MySQL transactions
MySQL transactions provide an effective method for executing multiple statements as a single unit, making it possible to safely modify data, while preventing concurrent users from updating the same data or overwriting changed data. If any statements wi …
Why Are Y’all Changing the Compat Levels on Master?
One of the things I love about SQL ConstantCare® (which happens to be free this month, by the way) is that I can keep in touch with what y’all are actually doing on your production servers. Today’s lesson was a complete shocker to me: some …
Unmasking SQL Server Dynamic Data Masking, Part 3, Security Concerns
This is the third part of a series on SQL Server Dynamic Data Masking. The first part in the series was a brief introduction to dynamic data masking, completing solutions, and use cases. The second part covered setting up masking and some examples. Thi …
[Video] Office Hours: Almost Back in San Francisco
It’s back to lighter fog-friendly clothes as the ship pulls into San Francisco and I answer your questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:16 Pozzolan: Hey Brent, My companies budget for SQL li …
Calculating Prime Numbers With One Query
Introduction I want to share the solution to the problem of searching for prime numbers using T-SQL. The problem was proposed on a reputable educational web resource. The problem is defined as follows: write all prime numbers less than or equal to 1000 …
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.