SQL Azure Reporting Automation
This article will talk about preparing a runbook in Azure to schedule the report of space usage of databases in Azure environment
2017-06-21
661 reads
Tushar Kanti
Identify Servers and the Databases Mounted in SharePoint
Identify the Database Server which is used to mount the database in Sharepoint 2010
2017-01-03
1,021 reads
Identify the Backup used to Restore the Database
This article will help us identify the backup which was used to restore the database. This may seem simple when the database backup is from the same server but the complications begin when the backup is not from the same server.
2014-02-27
3,614 reads
TempDB Deleted Accidentally
TempDB is the ALU of the SQL Server and if somehow this gets deleted Server cannot start. Here is a solution of how to get the server started when TempDB is deleted.
2011-05-04
12,583 reads
2010-09-03
3,261 reads
Finding Jobs
This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.
2010-05-05
6,031 reads
Blogs
Your First Databricks Notebook
By DataOnWheels
On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series....
SQL Clone Works with FILESTREAM
By Steve Jones
SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...
Fun and profit with UTF-8
When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...
Forums
Removing TDE from a Database: Level 4 Stairway to TDE
Comments posted to this topic are about the item Removing TDE from a Database:...
Valentino Sale Location
Landmarc (TriBeCa Valentino Sale Location) - Beyond kid friendly with amazing healthy menu sources...
SQL Deadlock
I have Simple SP to Insert Single Record from Application. When I executes it...
Ask SSC