2018-11-05 (first published: 2018-10-22)
886 reads
2018-08-08 (first published: 2018-07-22)
442 reads
2018-07-17 (first published: 2018-06-26)
931 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)
426 reads
Script out EXISTING database mail profile's settings
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
36,005 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)
758 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,486 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)
2,628 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)
781 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers