Run SQL/T-SQL scripts on folder
What to do when you have several sql scripts to run in your DB? Put all in a folder and use this...
2018-02-09 (first published: 2018-01-24)
2,219 reads
Scripts
Remove Database Encryption Key on all user databases
Below script will remove database encryption key, database certificate and master key on all the user databases.
For tempdb database, you need to restart the SQL Server Instance to complete the process.
Note: It is advisable to take transaction log backup before this activity is performed.
2018-02-08 (first published: 2018-01-29)
2,202 reads
All Link servers working status check and failure alert over E-mail
This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :-
exec proc_check_linked_servers 'profiler name','E-mail ID'
2018-02-07 (first published: 2018-01-30)
774 reads
2018-01-26 (first published: 2018-01-18)
12,512 reads
Compare MS SQL Agent jobs on two servers
During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.
2018-01-25 (first published: 2018-01-20)
3,486 reads
Insert data into a SQL Server Table using Powershell using Invoke-SQLc
How to insert data into a SQL Server Table using Powershell using Invoke-SQLcmd Commandlet
2018-01-24 (first published: 2018-01-11)
31,234 reads
Database maintenance progress
Often we need to know on which stage is a maintenance operation such as: backup, restore, check database. You can get this information using my script.
2018-01-17 (first published: 2018-01-12)
620 reads
Difference between dates displayed in days, hours, minutes and seconds
Show the difference between two dates (from, to) in format #d HH: MM: SS
2018-01-03 (first published: 2017-12-18)
495 reads
Powershell Script for regular DBA activities_GenerateScripts
Powershell utility for
generating scripts for db tables with / without identity columns.It can also produce scripts for fixed number of rows
2018-01-02 (first published: 2017-12-18)
1,156 reads
2017-12-29 (first published: 2017-12-27)
1,657 reads
Blogs
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
How AgentDBA Diagnoses SQL Server Issues Fast
By Arun Sirpal
Not every production incident is a database in RECOVERY_PENDING or a corrupted event (like...
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
BCA KCP Pulogadung Trade Centre Tlp:0817839777
WhatsApp: 0817839777 Kw. Industri Pulogadung, Jl. Raya Bekasi Km. 21, Ruko No.A2/18-19, RW.3, Wil,...
Alamat Kantor BCA KCP Klender Tlp:0817839777
WhatsApp: 0817839777 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit,...
Question of the Day
Changing the Schema
I set up a few users on my SQL Server 2022 instance.
CREATE LOGIN User1 WITH PASSWORD = 'Demo12#1' CREATE USER User1 FOR LOGIN User1 GO CREATE LOGIN User2 WITH PASSWORD = 'Demo12#2' CREATE USER User2 FOR LOGIN User2 GO CREATE LOGIN User3 WITH PASSWORD = 'Demo12#3' CREATE USER User3 FOR LOGIN User3 GOI then created a schema that one of them owned. Under this schema, I added a table with some data.
CREATE SCHEMA MySchema AUTHORIZATION User1
GO
CREATE TABLE Myschema.MyTable(myid INT)
GO
INSERT MySchema.MyTable
(
myid
)
VALUES
(1), (2), (3)
GO
SELECT * FROM MySchema.MyTable
GO
I granted rights and verified that User2 could access this table.
GRANT SELECT ON Myschema.MyTable TO User2 GO SETUSER 'USER2' GO SELECT * FROM MySchema.MyTable GOThis worked. Now, I move this schema to a new user.
ALTER AUTHORIZATION ON SCHEMA::Myschema TO User3; GOWhat happens with this code?
SETUSER 'USER2' GO SELECT * FROM MySchema.MyTable GOSee possible answers