Find DataBase Backup Modes
This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.
2007-05-18 (first published: 2007-05-07)
410 reads
Find the database by table name
Here's the scenario: 1. You have been given a script to run.2. You do not know the database name.3. You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer. This query will check every database on the server and return the name of the database with […]
2007-04-26 (first published: 2007-04-04)
452 reads
Blogs
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors...
SSAS Tabular – Process Add memory consumption
For me it’s a bit surprising how little information can be found regarding the...
Forums
Migration sandbox
Inherited about 190 2008 servers I need to migrate. Was going to build 2014/16...
Linked server and SQL Server 2019
Hi, I searched the infomation but I didn't found it so... Is Linked Server...
Ask SSC