Feeds:
Posts
Comments

Archive for October, 2010

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners Rick A Morelan, Doug Fritz Link to Amazon Short Review: This is one book that provides a solid fundamental to the reader along with hands-on experience  and in-depth learning. Right now, an error-free book that is closer to real world scenarios is very much [...]

Read Full Post »

I was recently getting following error in my StreamInsight Application. Could not connect to  TCP error code 10061: No connection could be made because the target machine actively refused it. The solution was very simple, I had to enable exception of the my port in my windows firewall. The way I figured it out  was [...]

Read Full Post »

I have been on world tour on SQL Server Performance Optimizations Seminar. The latest seminar was conducted in Colombo, Sri Lanka on Oct 4 – Oct 5. I had previously written about this event over SQLAuthority News – SQL Server Seminar at Colombo Full. This event was oversubscribed and we could not accommodate the last [...]

Read Full Post »

There are times when I feel like writing that I am a day old in SQL Server. In fact, there are many who are looking for solution that is simple enough. Have you ever searched online for something very simple. I often do and enjoy doing things which are straight forward and easy for change. [...]

Read Full Post »

I have seen people running the following script quite often, to know the list of the tables from the database: SELECT * FROM sys.tables GO The script above provides various information from create date to file stream, and many other important information. If you need all those information, that script is the one for you. [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers