The Power of Generate_series
The post The Power of Generate_series appeared first on SQLServerCentral.
Implementing Enterprise Data Security in Snowflake: Practical Concepts
As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed firsthand how challenging it can be to architect a robust security framework that balances protection with accessibility. …
Who’s Hiring in the Microsoft Data Platform Community? March 2025 Edition
Is your company hiring for a database position as of March 2025? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must incl …
Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especi …
How to Download and Restore AdventureWorks 2022 Database
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is designed to showcase SQL Server’s features, making it an excellent tool for learning, testing, and demonstrating SQL. In this …
SQL Server Backup or Restore using Network Share with SSMS
The post SQL Server Backup or Restore using Network Share with SSMS appeared first on SQLServerCentral.
MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization)
This is part of a series of posts from Chisom Kanu about using MySQL Shell in the management of MySQL. You can see the entire series here. So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and …
Office Hours: Unusual Beach Chair Edition
When you think ‘beach chair’, this probably isn’t what you think. I’m at a black sand beach on the south coast of Iceland, answering your top-voted questions from https://pollgab.com/room/brento. 00:00 Start 02:28 BoBo: Let us r …
Finding Out What Changed in a Cumulative Update
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We used to get full-blown knowledge base articles about fixes, but these days, we get a collection of footnotes with deceiving hyperlinks …
Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric
Did you know that Edgar F. Codd is considered the father of the relational model that is used by most database systems? He authored papers on both relational calculus and normal forms in the 1970s. It is especially important to know where the history …
Engineering a Lakehouse with Azure Databricks with Spark Dataframes
The post Engineering a Lakehouse with Azure Databricks with Spark Dataframes appeared first on SQLServerCentral.
Vertical Partitioning Is Almost Never the Answer. Here’s Why.
You’re looking at a wide table with 100-200 columns. Years ago, it started as a “normal” table with maybe 10-20, but over the years, people kept gradually adding one column after another. Now, this behemoth is causing you problems bec …
Beyond Single-Cloud: A Peek into Multi-Cloud
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology to how to effectively use it to drive business growth and innovation. Having recognized the power of the cloud in terms of agility, scalab …
Crazy number of Parameters… and a challenge
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X: So I replied: “Challenge Accepted”, well, actually I replied with a gif of Neo saying it, but the effect was the same. So, I decided to …
How to use the Azure Emulator to create blob containers, queues and tables
Introduction Sometimes, we need to test our apps in Azure and we do not have time to connect and work with Azure directly. We want a simple free offline solution to test our Azure without connecting to the real Azure Storage. This article will show how …