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.
Updated First Responder Kit and Consultant Toolkit for May 2020
My favorite new things are that sp_BlitzIndex @Mode = 2 now makes it even easier to do disconnected index tuning just purely inside a spreadsheet, and sp_BlitzCache runs faster on big servers.
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers