Learn logical query processing to understand WHERE, SELECT aliases, grouped filters, and ordering without confusing syntax with execution.
SQL SERVER 2008 – Connect Visual Studio 2005 Patch Download
SQL Server 2008 could not connect to Visual Studio 2005 until now. Microsoft released the Visual Studio 2005 SP1 update for SQL Server 2008 support.
SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
Login failed, not associated with a trusted SQL Server connection? I hit it between SQL Server 2008 and 2005 and fixed it with a matching Windows user.
SQLAuthority News – TOP Downloads – Bookmark
My top downloads in one post to bookmark, since the sidebar does not show in RSS: SQL Server interview questions and answers and the SSMS keyboard shortcuts.
SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
I have seen developers confused many times when they receive the following error message. Incorrect syntax near. Let us learn.
SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
Two ideas with examples: transactions have no effect on local variables, and an UPDATE applies all its changes at once, which lets you Swap Variables in one go.
What Is a Database Schema in SQL Server?
A database schema is a namespace inside a database. What dbo really is, why two tables can carry the same name, how a schema makes permissions something you set once, and why naming it in your code saves you from odd bugs.