2011-01-14 (first published: 2010-12-28)
1,586 reads
2011-01-14 (first published: 2010-12-28)
1,586 reads
I needed to run an ssis package / job on many dates that were not consistent and initially started creating dozens of job schedules before coming up with this idea...
2011-01-13 (first published: 2010-12-29)
1,283 reads
Consider you have 100+ tables in your database, you want to find a quick way to find no. of rows in each table
2011-01-11 (first published: 2010-12-22)
2,487 reads
It will display the multiple
rows values in one row value.Like if there are 5 rows with values then that will be displayed in single row with specified separator.
2011-01-10 (first published: 2010-12-23)
3,653 reads
This procedure creates insert statements for the given table and given range of values of primary key column.
2011-01-07 (first published: 2010-12-23)
3,032 reads
This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.
2011-01-06 (first published: 2010-12-23)
2,117 reads
2011-01-03 (first published: 2010-12-15)
3,013 reads
2010-12-30 (first published: 2010-03-18)
2,517 reads
Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.
2010-12-29 (first published: 2010-12-15)
1,533 reads
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
6,845 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby. Baru, Kota...
WhatsApp:0817819444 Jl. Brawijaya 79, Dusun Muncar Baru, Tembokrejo, Kec. Muncar, Kabupaten Banyuwangi, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers