Tags » SQL Server 2008 R2

SQL Server Installation - Non Canonical DACL Error

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

Microsoft

Static Code Analyzer for T-SQL - MS SQL Server. Plugs into MS SSMS and can al...

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. 

60 more words
Development

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

Sql Server 2005

SQL Server, Modulo, floats

SQL server % (modulo, not mod) operator doesn’t like floats (with reason).

You should get rid of the floats as they will give inaccurate results. 47 more words

Development

New Management Packs for SQL

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

System Center

Sql Server : Concatenate VARBINARY or Concatenate BINARY values

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

DBA

Common Table Expressions: no nesting, but consecutively usage - via Stack Overflow

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

Development