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
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
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.
Changed database context to ‘master’.
Changed language setting to us_english.
(Microsoft SQL Server, )
Twitter is a popular social network where users can share short SMS-like messages called tweets. Users share thoughts, links and pictures on Twitter, journalists comment on live events, companies p… Source: Mining Twitter Data with Python (Part 1: Collecting data)
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 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