Alter database owner to SA from any user details on all user databases
Alter database owner to SA from any other user details against all user databases
2019-05-03 (first published: 2015-01-13)
1,729 reads
SQl Hunt
- Interests: Like to make friendship with people.
Backup Database Size calculation Report - Monthwise
The script helps to calculate the size of the backup of the databases monthwise. This will help to understand the database growth rate from the backup file if we do not have any data collection utility to find the exact details of the DATA File growth.
2019-05-03 (first published: 2012-08-20)
1,499 reads
Backup Growth Trend Check
-- Backup Growth Trend Check To Understand how much disk space you need in future
2019-05-03 (first published: 2015-06-02)
1,220 reads
Capture the tasks performed in a text file
Creates a record of all or part of a Windows PowerShell session in a text file.
2019-05-03 (first published: 2015-09-17)
1,095 reads
Change datetime
If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.
2019-05-03 (first published: 2016-09-26)
495 reads
Check existence of a database
Check Status of a database. It will loop through all databases and will print message if the db is present.
2019-05-03 (first published: 2015-04-10)
1,269 reads
Check Existence of Server and find Instance Type
Execute the function and pass only the SQL Server Name to check if the SQL Instance is available and if yes, what is the Instance Type.
2019-05-03 (first published: 2015-03-26)
1,259 reads
Check running SQL Services
Check all the running SQL services in different servers.
You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.
2019-05-03 (first published: 2015-03-26)
2,013 reads
Check Up Size Of Each Folder In a Path
If you have any requirement to check the size of each sub-folders in a path, you can use my script.
2019-05-03 (first published: 2015-05-20)
1,554 reads
Cleanup Older than 30 days of Files & Folder through SQL Job
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2019-05-03 (first published: 2015-08-04)
2,289 reads
Blogs
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Product Review: DataVeil
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
The Last Price Bump for the Data Community Summit
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Forums
Error in SQL Server Management Studio launcher
Guys, good night! I have a situation in my SQL Server Management Studio where...
Just upgraded SSRS from 2016 to 2022
I just upgraded SSRS from 2016 to 2022. This is my first time doing...
Weekly sales report
I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...
Ask SSC