Exporting a Reporting Services report to multiple Excel tabs

weblogs.sqlteam.com — Short demonstration on how to create a report so that it will export to more than one Microsoft Excel worksheet. read more...

add a comment | category: Database | Views: 4

XNA Game Studio 3.0 is Here

submitted by gavinjoyce 20 days, 15 hours ago

creators.xna.com — XNA Game Studio 3.0 expands on all the offerings of earlier iterations to include additional functionality to appeal to game developers of every level and enable them to create games to distribute through Xbox LIVE Community Games on the Xbox 360 as part of the New Xbox Experience. read more...

1 comment | category: XNA | Views: 11

Transaction and Local Variables - Swap Variables - Update All At Once

submitted by pinaldave 29 days, 14 hours ago

blog.sqlauthority.com — Summary : Transaction have no effect over memory variables. When UPDATE statement is applied over any table (physical or memory) all the updates are applied at one time together when the statement is committed. read more...

1 comment | category: Database | Views: 8

ALT.NET Podcast Episode 12: More jQuery in ASP.NET

submitted by powerrush 1 month, 4 days ago

altnetpodcast.com — In this episode Chris Brandsma, Rick Strahl, Dave Ward, Bertrand Le Roy, and Scott Koon conclude their discussion of Microsoft’s jQuery in ASP.NET announcement. Continuation or Episode 12. read more...

add a comment | category: ASP.NET | Views: 7

SQL Server Support in a Hardware Virtualization Environment

weblogs.sqlteam.com — Link to a PSS blog posting where Microsoft's Bob Ward elaborates on support for running SQL Server in a virtualized environment. read more...

add a comment | category: Database | Views: 1

SQL Server 2008 - Cheat Sheet - One Page PDF Download

published 1 month, 11 days ago, submitted by pinaldave 1 month, 12 days ago

blog.sqlauthority.com — Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy. I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked. Let me know your opinion and if you find this useful. Bookmark it for future use. read more...

2 comments | category: Database | Views: 595

Using Covering Indexes to Improve Query Performance

weblogs.sqlteam.com — Link to a Simple-Talk article that discusses how you can include columns in the leaf nodes of nonclustered indexes to improve query performance. read more...

add a comment | category: Database | Views: 4

SQL SERVER - 2008 - Interview Questions and Answers - Download PDF

published 1 month, 28 days ago, submitted by pinaldave 1 month, 29 days ago

blog.sqlauthority.com — Interview is very important event for any person. A good interview leads to good career if candidate is willing to learn. I always enjoy interview questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is very large subject and not everything is usually asked in interview. In interview what matters the most is conceptual knowledge and learning attitude. I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the question please send me mail or write a comment. Bookmark this first ever set of interview questions and answers. read more...

2 comments | category: Database | Views: 273