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,861 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,614 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,282 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,124 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)
514 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,319 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,308 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,106 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,650 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,591 reads
Blogs
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
Forums
The AI Bubble and the Weak Foundation Beam
Comments posted to this topic are about the item The AI Bubble and the...
data type gets lost in data flow
Hi, in a simple oledb source->derived column->oledb destination data flow, 2 of my...
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it...
Question of the Day
The Read Committed Snapshot Isolation behaviour
I am currently working with Sql Server 2022 and AdventureWorks database. First of all, let's set the "Read Committed Snapshot" to ON:
use master; go alter database AdventureWorks set read_committed_snapshot on with no_wait; goThen, from Session 1, I execute the following code:
--Session 1 use AdventureWorks; go create table ##t1 (id int, f1 varchar(10)); go insert into ##t1 values (1, 'A');From another session, called Session 2, I open a transaction and execute the following update:
--Session 2 use AdventureWorks; go begin tran; update ##t1 set f1 = 'B' where id = 1;Now, going back to Session 1, what happens if I execute this statement?
--Session 1 select f1 from ##t1 where id = 1;See possible answers