2019-04-16
674 reads
Logins
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)
389 reads
Generate Login Script(2008R2 And Older)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,701 reads
Prevent and Log Certain SQL Server Login Attempts
Aaron Bertrand presents a more elegant to prevent developers from attempting to log into production databases using application logins (and to log any such attempts).
2015-04-14
7,318 reads
2014-05-14
2,203 reads
2014-03-28
1,854 reads
2014-03-26
2,062 reads
Script Login Differences
Compare the logins and users on two instances and generate a TSQL script to make them the same.
2015-02-26 (first published: 2013-11-15)
2,628 reads
Script All Logins / Users / and Roles
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)
7,243 reads
2012-04-24 (first published: 2012-03-30)
1,803 reads
Blogs
The Azure-SSIS IR Startup Time
If you want to run SSIS packages in Azure Data Factory, you need the...
What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT...
Comparing Execution Plans
When you run a query twice, and get dramatically different run times, your first...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Row and Column wise Total in pivot table
I want row wise and column wise Total Create table #Sections (SecID int,...
Interesting query regression from more accurate cardinality estimation
I just completed a project deploying an application that is backed by SQL 2017....
Ask SSC