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,765 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,540 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,233 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,102 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)
496 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,277 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,267 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,027 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,557 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,412 reads
Blogs
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Forums
The Marked Transaction
Comments posted to this topic are about the item The Marked Transaction
What happens when we drop a column on a SQL Server table? Where's my space?
Comments posted to this topic are about the item What happens when we drop...
Sort comma delimited string in column
I have a column that contains comma separated values. I'm trying to figure out...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers