I have been approached by my colleagues I used to work previous to previous employer. Two of my ex-Colleagues currently working as System Engineers contacted and looking for information if I have seen the error during SQL Server Installation. 162 more words
Tags » SQL Server 2008 R2
60 more words
Static Code Analyzer for T-SQL – MS SQL Server.
Plugs into MS SSMS and can also be run from command line.It reports useful clues which you can turn/on off to your liking.
The server principal "XYZ\USER" is not able to access the database "YourDBName" under the current security context
My Development team contacted me and said they are not able to access database “The server principal “XYZ\USER” is not able to access the database “YourDBName” under the current security context” 81 more words
Complementing the previous post about the new Management Packs updated after the release of Windows and System 2016 ( https://msincic.wordpress.com/2016/10/25/new-system-center-operations-manager-2016-management-packs/ ), Update follows.
The Preview of the new Management Pack for SQL has been released today from the 2008 to 2016 release. 371 more words
Quick one today:
A few days ago, there was a need to UPDATE a column in production environment to correct some values, as they were in incorrect status. 121 more words
Common table expressions are awesome. They work in at least Oracle and SQL Server.
You cannot nest them, but you can use them consecutively. Thanks… 33 more words