How to Download and Restore AdventureWorks 2019 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 …
[Video] Office Hours: Philosophical Questions at the Waterfall of the Gods
I’m in Iceland this week, land of fire and ice, a place I keep coming back to over the years. It’s one of my favorite places on earth with stunning scenery, nice folks, and great restaurants. I paused at Godafoss to take your top-voted ques …
Simple Talk on the Road In March
The holidays truly are over, and it is time to hit the road again here at Simple Talk. In March I have 3 events, all of which are basically back to back (and finishing off with a bit of vacation.) Familiar Territory – SQL Saturday Atlanta BI On M …
How Shortcuts affect Lakehouse’s Maintenance
I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided sample code about it. However, there is one problem: All the maintenance execution should be avoided over shortcuts. The …
Free SQL Server Spring Training Live Webcasts Start Next Week.
Starting next Tuesday, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: March 11: Fundamentals of Index Tuning March 18: Fundamentals of Query Tuning April 1: Fundamentals of TempDB April 8: Fundam …
Importing and exporting data in MongoDB Compass
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. When working with MongoDB, you’ll likely need to import or export document data from time-to-time. You can use MongoDB Compass fo …
Understanding the Logical Functions IIF and Choose in SQL Server 2022
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting specific values or performing complex checks, SQL Server offers several functions that simplify these tasks. Among them, …
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 …