Friday/Saturday was a great day, got to meet lots of wonderful people from US/Canada at the Alberta’s first SQL Saturday. I delivered they Key Note
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
How to get orphaned logins for all databases?
Following script gives you all user database users, that do not have a server login mapped or where database user name does not match server
Microsoft SQL Server 2016 RC2 Released
In SQL Server 2016 RC 2, enhancements include: R Services setup – the setup process for R Services is much more integrated into SQL Server
Changing @@SERVERNAME causes SQL Server Backups to Fail for AlwaysOn Availability Group
One of customers changed the value returned from @@SERVERNAME. SQL Server works no problem, however an unexpected behavior appeared. Changing the value for @@SERVERNAME, caused
sys.foreign_keys does not have matching row in sys.indexes
Running DBCC CHECKDB you are getting following error message: Check Catalog Msg 3853, State 1: Attribute (referenced_object_id=194099732,key_index_id=7) of row (object_id=2040565179) in sys.foreign_keys does not have
SQL Canada (SQLCAN) 