Category Archives: SQL

TFS 2012 Reporting Issue

When we open a report (Bug rate) from one of our TFS 2012 server, we have observed that the data is not getting updated till date and is showing the data till June only. Data warehouse update date pointing to … Continue reading

Posted in SQL, TFS | Tagged , , , | Leave a comment

SQL SERVER 2012

SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012 Microsoft VP Ted Kummert announced the official name of the next version of the SQL Server – SQL Server 2012. The version of the … Continue reading

Posted in SQL | Tagged | 1 Comment

JUNEAU

SQL Server Developer Tools, or SSDT (code-named “Juneau”), represents Microsoft’s continued commitment to providing integrated tools for developers targeting Microsoft SQL Server. This Project system and its related features provide the tools to edit, compile, refactor and publish databases to … Continue reading

Posted in SQL | Tagged , , | Leave a comment

Adding a new user to SQL Server

We faced an issue with SQL server login recently. The user is an Administrator in the SQL Server box, but don’t have access to the SQL Server. The user who have access to the SQL got disabled. How the Administrator … Continue reading

Posted in SQL | Tagged | 2 Comments

SQL Server 2008 – Error code 0x84B20001.

When we try to install a patch over SQL Server 2008, we received the following error message. Work Around: Open the registry and varify the value at HKEY_LOCAL_MaCHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState The values for all the keys under this should be … Continue reading

Posted in SQL | Tagged , , | 3 Comments