New Resumable Online Index Create SQL Server 2019
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,230 reads
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,230 reads
SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for...
2018-12-12
316 reads
Data exploration and documentation can be cumbersome, classifying data can be one of those tedious but necessary things. With the...
2018-12-05
925 reads
Did you know compression can gain you more than just space on a disk, it can allow you to fit...
2018-11-13 (first published: 2018-10-31)
2,594 reads
Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping...
2018-11-01 (first published: 2018-10-24)
2,980 reads
At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I...
2018-10-17
326 reads
We all have the need to collect system and performance information regarding our SQL Servers. Some of us use third-party...
2018-10-17 (first published: 2018-10-03)
3,181 reads
I saw this again recently and see it too often in environments so wanted to take a second to remind...
2018-10-04 (first published: 2018-09-26)
2,600 reads
Quite often I see database administrators set SQL Server max server memory thinking everything related to SQL Server uses this...
2018-09-19
595 reads
Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we...
2018-09-11 (first published: 2018-09-05)
2,078 reads
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Comments posted to this topic are about the item SQL Server 2025 Build List
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Comments posted to this topic are about the item Is Data Modeling Common?
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers