First day and last day of a week
This scripts calculates the first day and the last day of a given week
2015-11-10 (first published: 2015-10-12)
1,127 reads
Kamel AL GAZZAH
Make a list of all tables in all data bases with creation date
This scripts allows to store all tables names in all databases for the current server, it stores also the creation date, this script can be runned ins SQL Server 2000 or later
2012-07-02 (first published: 2012-06-25)
1,409 reads
Blogs
Recover database encrypted modules code with dbatools
This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments...
Azure SQL Offers Manual Failover for PaaS Resources
By John
Sometime having the right command in place opens up new doors to test things,...
Azure SQL Offers Manual Failover for PaaS Resources
By John
Sometime having the right command in place opens up new doors to test things,...
Forums
SSRS Query Designer not showing newly added measures
We have recently added new measures to our existing cube in dev and test....
Cannot restore DB using T-SQL script
Hello, I had a database called Training_01 and did a backup of it. It...
Transaction log used space
It's a little weird for me. I have a database (AdventureWorks2014; SQL Server 2014)...
Ask SSC