Understanding the System Function FILEPROPERTY()
The SQL Server system function, FILEPROPERTY(), is used to retrieve database file properties. I will show you use cases of this system function to understand how to use it to retrieve the properties of any database files. The syntax of this function FI …
Rollbacks, Undos and Undonts
The post Rollbacks, Undos and Undonts appeared first on SQLServerCentral.
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 …