Monitoring: The ROI of Build vs. Buy
The post Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application
The post How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application appeared first on SQLServerCentral.
Convert UNIX Timestamps to DATE/TIMEs in SQL Server – Part#1
tl;dr A complete and documented function is available at the end of the article. You don’t know what you’re missing though. « Thank You » Thank you, Mr. Steve Jones, for all the work you do for this wonderful community of SQL Professionals and for keepin …
T-SQL Tuesday #154 – SQL Server 2022, IS DISTINCT FROM
SELECT CASE WHEN 1 = NULL THEN ‘True’ Else ‘False’ end, CASE WHEN NOT(1 = NULL) THEN ‘True’ Else ‘False’ end The fact that both of these comparisons return False is confusing at times even to me, and I have written on the whole NULL comparison and nega …
Community Tools Month: Using sp_WhoIsActive to Catch ASYNC_NETWORK_IO
When your SQL Server’s top wait stat is ASYNC_NETWORK_IO, that indicates SQL Server is waiting on the app to ask for the next part of the result set. This is a real pain in the rear to troubleshoot because often these waits happen for really shor …
How to visualize Python charts in Power BI Part 2
Introduction In a previous article, named How to visualize Python charts in Power BI, we show some charts using Python in Power BI. We saw some lines, bars, and a special function, named eventplot, to draw multiple lines. Most of the examples were char …
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 …