Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).
2017-02-02 (first published: 2015-08-20)
16,009 reads
SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.
2015-07-20
8,787 reads
2015-06-23
7,834 reads
2019-05-03 (first published: 2015-05-05)
2,343 reads
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2019-05-03 (first published: 2015-04-15)
1,161 reads
This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS
2015-03-31
1,326 reads
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,806 reads
2015-03-20
1,730 reads
Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.
2014-09-29
5,152 reads
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,592 reads
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
NO AI was used to generate this content. Grammarly was used to check and...
Hi, We are looking out to read parquet file directly from on premise shared...
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Comments posted to this topic are about the item Forward Deployed Engineers
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers