Creating Encryption Key Backup for SSRS 2008R2

Creating Encryption Key Backup for SSRS 2008R2 - r for taking backup of key -f for file location -i is the instance name of the Reporting Services   Are you sure you want to extract the key from the report server? Yes (Y)/ No (N) : Y SECURE THE FILE IN A SAFE LOCATION The … Continue reading Creating Encryption Key Backup for SSRS 2008R2

Advertisements

Copy one column to another sqlserver

UPDATE table SET columnB = columnA --This will update every row. UPDATE table_name SET destination_column_name=orig_column_name WHERE condition_if_necessary --This will update rows which satisfy the WHERE clause UPDATE table1 SET column1 = ( SELECT column2 FROM table2 WHERE table2.id = table1.id ); Whereby: table1 = table that has the column that needs to be updated table2 … Continue reading Copy one column to another sqlserver

How to prevent users from accessing SQL Server from any application or any login expect your main application & its login

The SQL Dude!

When a user who isn’t in the logon trigger exception list above tries to connect, they will get this error.

Cannot connect to SERVERNAME.

——————————

ADDITIONAL INFORMATION:

Changed database context to ‘master’.

Changed language setting to us_english.

(Microsoft SQL Server, )

image



image


View original post

Did You Know?? R Services is in Standard Edition of SQL Server 2016 — The SQL Herald

While my last post extolled the virtues of SQL Server Standard Edition, this week while doing some client testing with Microsoft, I learned about another key standard edition feature. The new SQL Server R services is supported in standard edition of SQL Server 2016. While you won’t get access to some of the cool functions […] … Continue reading Did You Know?? R Services is in Standard Edition of SQL Server 2016 — The SQL Herald

Kill All Sessions Coming from a Host in SQL Server

Kill Sessions by HOST SQL Server --Check no. of sessions coming from all hosts connected to DB -- SELECT hostname, COUNT(hostname) FROM sys.sysprocesses P JOIN sys.sysdatabases D ON (D.dbid = P.dbid) JOIN sys.sysusers U ON (P.uid = U.uid) WHERE hostname != '' GROUP BY hostname ORDER BY COUNT(hostname) DESC; -- Create Procedure to kill sessions … Continue reading Kill All Sessions Coming from a Host in SQL Server