Microsoft SQL Server Utilities and Tools
Useful free and paid utilities and tools for Microsoft SQL Server - complete list of 275 Utilities
How to Add Help to PowerShell Scripts
PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to use? In this article, Greg Moore shows how to add professional looking help to your scripts that work just like the help in cmdlets.
Installing SQL Server 2019 using the Azure Cloud Shell
Introduction Microsoft released SQL Server on Linux, starting from SQL Server 2017. SQL Server 2019 (15.x) has the same underlying database engine on all supported platforms, including Linux. Therefore, many existing features and capabilities operate the same way on Linux. Platform File System Red Hat Enterprise Linux 7.3, 7.4, 7.5, 7.6, or 8 Server XFS […]
Sabotage at Work
Some of the work habits that might sabotage an organization appear to have been adopted by some of Steve's former employers.
Text Mining and Sentiment Analysis: Analysis with R
In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating a word cloud, word associations, sentiment scores, and emotion classification.
Azure DWH part 19: Backup and Restore SSAS
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
Crack that Encrypted Data
Ransomware is becoming an issue. Steve Jones notes DBAs need to be ready to deal with these issues.
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Member was not found in the cube when the string
Hey, I've not done a cube for many years but I find myself supporting...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers