Want to make sure you don’t have errors, validate performance, and save money while making changes with Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon...
2020-09-11
33 reads
SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...
2020-09-10 (first published: 2020-09-02)
1,626 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-10
14 reads
There’s been an update of the SSIS extension for Visual Studio 2019. There are some bug fixes and deployments are blocked to Azure-SSIS if the target server version is...
2020-09-10 (first published: 2020-09-02)
592 reads
In the previous parts, we explained How we can Troubleshooting the Performance issue using built-in reports in SQL Server and How we can collect SQL Server logs using PSSDIAG...
2020-09-10
80 reads
In the previous parts, we explained How we can Troubleshooting the Performance issue using built-in reports in SQL Server and How we can collect SQL Server logs using PSSDIAG...
2020-09-10
14 reads
Warning, this is a longer post from me than usual. The title is a mouthful and so is this post. In the past I have linked to blog posts...
2020-09-09
318 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-09
21 reads
SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log...
2020-09-09 (first published: 2020-09-01)
646 reads
This week we’re looking at how the database engine stores the XML data type in SQL Server and Azure SQL Database. If you would like to read about storage of...
2020-09-09
167 reads
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
In all recent versions of the database you can call DBMS_UTILITY.EXPAND_SQL_TEXT to get the...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers