2017-02-28 (first published: 2015-06-22)
2,115 reads
Scripts
Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
1,549 reads
2017-02-02 (first published: 2017-01-30)
805 reads
2017-01-30 (first published: 2017-01-26)
19,608 reads
Query details about objects allocated in TEMPDB.
TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.
2017-01-30 (first published: 2016-12-29)
2,238 reads
Powershell Script to find a SQL\Windows login in SQL Server
This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server
2017-01-26 (first published: 2017-01-24)
653 reads
TDE Decryption Timer Script
Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.
2017-01-24 (first published: 2017-01-18)
456 reads
Generic, parameterised, create DB script
A script to be used as part of development deployments where new databases are required, so as to provide standardisation.
2017-01-23 (first published: 2017-01-18)
470 reads
Backup databases in an Availability Group
Use this script to backup databases based on their role in an availability group
2017-01-12 (first published: 2017-01-07)
687 reads
Powershell Script for regular DBA activities
This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db
It takes care of all the possible failures during these operations, while done manually.
2017-01-11 (first published: 2017-01-09)
1,754 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
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...
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...
Alamat Kontak BCA KCP Comal Tlp,Cs:0821-8154-393
WA:08218154393 Grand Comal Residence, Jl. Raya Ahmad Yani No.20 Blok EA A19, Dusun II,...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers