2018-11-05 (first published: 2018-10-22)
831 reads
2018-08-08 (first published: 2018-07-22)
396 reads
2018-07-17 (first published: 2018-06-26)
873 reads
User access management on DB & object level
It will help to find and manage the users access on DB level
2018-07-05 (first published: 2018-06-26)
393 reads
Script out EXISTING database mail profile's settings
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
16,620 reads
Login restriction from selected applications and users
It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details
2018-04-11 (first published: 2018-03-29)
650 reads
DB Blocking Automated E-mail Alerting with Blocker SP ID & query's
It will Help DBA to monitor the instant blocking and can take the action immediately on blocker query and users.
2018-04-05 (first published: 2018-03-22)
1,071 reads
Grant Sp_who2, & who3 proc execution without granting sysadmin access
It will help to development team to find their developed & DB server status check.
2018-03-28 (first published: 2018-03-22)
1,353 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)
556 reads
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
Missord prom dress shops UP to $50 off is underway
A Christmas gathering with friends is an essential event. Typically, you'll meet formal dresses...
Track Insert/Update/Delete Operations in Sql Server DB Table
Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...
Microsoft SQL over IPSEC VPN TPLink routers - 2 locations
Hi Experts. We recently set up a second location. our software at our first...
Ask SSC