Tags » SQL Server

Installing multiple default instances on a single server

As you probably know, SQL Server allows only one default instance per server. The reason is not actually something special to SQL Server, but it has to do with the way TCP/IP endpoints work. 820 more words

SQL Server

Developer - 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 3 of 3)

I am very fortunate that I know John Sonmez in person. He is one of those individuals who understands the young mind of developers and depth of software development industry. 946 more words

SQL Authority

Still More Comments on Microsoft and Revolution Analytics

Three full business days post-announcement, and stories continue to roll in.

Stephen Sowyer of TDWI writes an excellent summary of what Microsoft will likely do with Revolution Analytics.   423 more words

News Analysis

Creating a comma separated list with FOR XML PATH and STUFF

I can’t really think of a story or tip that ties into creating a comma separated list, so I’ll just use one that’s completely unrelated.  It’s fun sharing experiences with loved ones, and fishing is no different.   705 more words


Find Last Date Time Updated for Any Table in SQL Server.

If a user wants to finds out when was the last table updated he can query dynamic management view (dmv) – sys.dm_db_index_usage_stats and easily figure out when was the table updated last. 55 more words


SQL Server Setup Issue : How to resolve Reporting Services Catalog Database File Existence Failed or Temporary Database File Existence failed

When you Uninstall SQl server some of the traces will be left behind one of them are Reporting serivces catalogs in order to fix this issue follow the screen shots below… 32 more words

Sql Server

SQL SERVER - The Basics of the SSIS Script Task - Notes from the Field #065

: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story.  1,037 more words

SQL Authority