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)
15,165 reads
This article will discuss geo-replication for an Azure SQL Database (PaaS) and the steps required for setup via the Azure portal and TSQL.
2016-06-27
1,558 reads
Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.
2016-04-26
3,088 reads
For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.
2016-04-21
1,609 reads
Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.
2015-09-17
3,693 reads
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
I am having Below Table i want to get Result as shown in the...
what I want is to apply some filter patterns to search the data. For...
Hi All, Using Tsql query I want to know currently running sql agent jobs...
Ask SSC