Feeds:
Posts
Comments

Archive for October, 2010

SQL SERVER – StreamInsight and SQL Server 2008 R2

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on October 16, 2010 | Leave a Comment »

I was recently called into create POC (Proof of Concept) for a project which was being planned for use StreamInsight. When I was there, I was also asked to give overview of the this feature to their CTO (who had only 15 minutes to spare). Usually I do not like sudden change of plans but [...]

Read Full Post »

SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh

Posted in SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology, tagged on October 15, 2010 | 3 Comments »

I was recently working at customer location on PowerPivot project. It was quite complected as this is relatively new technology and we all are exploring what this technology can do and what it can bring to us on table in real life experience. During this implementation the project design document needed specification regarding Data Refresh [...]

Read Full Post »

SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed

Posted in SQL, SQL Authority, SQL Milestone, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 14, 2010 | 28 Comments »

This is my 1500th blog post. I am very happy. In my earlier 1400th blog post mile stone, I made a promise that I would explain why I have chosen SQLAuthority.com as my blog’s name. Let me share with you the story about how I came up with the name. In my earlier career days, [...]

Read Full Post »

SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology

Posted in Best Practices, Database, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on October 13, 2010 | 13 Comments »

Everyone always dream of visiting their school and college, where they have had studied once. It is a great feeling to see the college once again – where you have spent the wonderful golden years of your time. College time is filled with studies, education, emotions and several plans to build future. I consider myself [...]

Read Full Post »

SQL SERVER – Indexed View always Use Index on Table

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL View, T SQL, Technology, tagged on October 12, 2010 | 6 Comments »

This blog post is written in response to T-SQL Tuesday hosted by Shankar Reddy. I have been recently writing about Views and their Limitations. While writing this article series, I got inspired to write about SQL Server Quiz Questions. You can view the Quiz Question posted over here. In SQL Server 2005, a single table [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers