Data Visualizations for Excel Multi-Chart Sets with SQL Server Data
The post Data Visualizations for Excel Multi-Chart Sets with SQL Server Data appeared first on SQLServerCentral.
[Video] Office Hours: Hotel Balcony Edition, Part 2
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered: …
[Video] Office Hours: Hotel Balcony Edition, Part 1
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered t …
How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES
The post How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES appeared first on SQLServerCentral.
SQL Ledger: Protecting Data in Azure SQL
Here in Malta, there are many I-Gaming companies. The I-Gaming business creates an important movement for the Maltese economy. In the I-Gaming business, one good example of the need for data security is the customer wallet. The customer wallet involves …
Community Tools Month: Choose Your Character
This month on the blog is Community Tools Month, and I’m going to be talking about some of the most useful and influential tools out there. You can’t learn them all – *I* can’t learn them all – because there just aren …
Synapse Analytics: When you should use (or not use) Synapse
Synapse is a great data lake house tool. This means in a single tool we have resources to manage a data lake and data warehouse. The Synapse Serverless Pool is great to manage data lakes and for a great price: around us$ 5,00 for each TB of data querie …
Office Hours, Short Text Answers Edition
Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, like these: F’legend: Hi Brent, in reply to a question talking about database restores for 1TB+ you a …
Metadata Functions in SQL Server and Their Use Cases
The post Metadata Functions in SQL Server and Their Use Cases appeared first on SQLServerCentral.
Managing Datasets for Database Development Work using Flyway
The post Managing Datasets for Database Development Work using Flyway appeared first on SQLServerCentral.
The Uses of Dependency Information in Database Development
The post The Uses of Dependency Information in Database Development appeared first on SQLServerCentral.
SQL WAITFOR Command to Delay SQL Code Execution
The post SQL WAITFOR Command to Delay SQL Code Execution appeared first on SQLServerCentral.
Manage Your Business Rules in T-SQL Query
Motivation At some point in the carrier, we have come across the problem of hard-coded values in SELECT or WHERE clauses. And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot …
SQL Server 2022 Build List
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlserve …
Who’s Hiring in the Database Community? September 2022 Edition
Is your company hiring for a database position as of September 2022? 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 …