Managing Static Data in Flyway Database Development
The post Managing Static Data in Flyway Database Development appeared first on SQLServerCentral.
SQL WHERE Tutorial
The post SQL WHERE Tutorial appeared first on SQLServerCentral.
How to Use PowerShell to Set Secure SA Passwords in Bulk
Introduction In this article, I will help you how to set secure SA passwords for bulk servers. Sometimes we have many SQL server instances in the company environment, with the count being in the hundreds. For security requirements, you may need to ensu …
Most DBAs Say They’re Encrypting Personally Identifiable Data. Most.
Despite the continuous stream of data breaches, ransomware, and GDPR violations, some companies still aren’t encrypting personally identifiable information (PII) inside our databases or backups. I see this all the time when working with clients, …
[Video] Office Hours: Ask Me Anything About SQL Server and Azure
Got questions about the Microsoft data platform? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Today’s episode finds me in my home office in Vegas: 00:00 Intros 02:10 GeorgeDAX: Hello Bren …
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: …