Who Truncated That Table and What Do I Do Now?
This article describes a way to identify the user who truncated the table & how you can recover the data.
2015-02-20 (first published: 2014-06-05)
27,733 reads
Sujeet Singh
Instant File Initialization
This article describes a way to speed up various file operations performed by SQL Server.
2014-07-10
4,140 reads
Automating Database Restores
This article describes a way to automatically restore multiple database backups from a directory.
2014-04-21
5,775 reads
2012-09-17
2,705 reads
Blogs
Daily Coping 7 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do....
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
Forums
Common schema in different Databases
Hi, I need to include a very simple schema in all of my database...
Permissions to Run CLR Assembly
This is my first time dealing with CLR assemblies and we have setup some...
Convert date value
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC