(Navneet Singh Sahni) How to build a Report Studio report that allows the user to select from a prompt which columns to include in the report.
Other News
SQL Server Management Studio keyboard shortcuts – Part 1
(Arshad Ali) As responsibilities are growing every day, a DBA or developer needs to improve his/her productivity. One way to do this is to use as many shortcuts as possible instead of using your mouse and the menus. In this tip we take a look at common tasks you may perform when using SSMS and the
Keeping Current in a Rapidly Changing World
PowerPivot Expo – Today Thanks to everybody who signed up to attend our eight virtual sessions on PowerPivot! We’re kicking off the event at 9 a.m. Pacific, so if you forgot to register, come on in and join in all the Business Intelligence-focused fun. Sign up today Keeping Current in a Rapidly Changing World It’s time to take control of […]
SelecTViews – Interview with Brian Knight, owner and founder of Pragmatic Works
Video Programming for IT Professionals
All-In-One and One for All
PowerPivot Expo – Tomorrow At one of the largest Business Intelligence-focused virtual events of the summer, SSWUG.ORG is hosting eight sessions on PowerPivot! Learn from experts such as Mark Tabladillo, Brian Knight, Jen Underwood and others about organizing, connecting and manipulating tables of large data sets. If you want to attend, you should! After all, it’s free to attend the […]
Automatic XML Schema generation for Jersey WADLs
(Gerard Davison) I have been doing a little bit of work recently on Jersey implementation and one of the precursors to this has been to try to get the WADL that Jersey will generation by default to contain just a little bit more information with regards to the data being transferred.
Managing SQL Server Service Broker Environments
(Arshad Ali) SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applications
SQL Server 2008 R2 SP1–new table hint options for FORCESEEK and FORECSCAN
(Simon Sabin) Other than bad code plan stability is one of the main reasons for performance problems I see in client systems. This is often due to bad estimates, bad stats etc you can watch my SQLbits session on when a query plan goes bad for more information.
Use PHP with Identi.ca, Part 1
(Vikram Vaswani) Identi.ca is a popular free microblogging service that allows users to post status messages and news. Web application developers are able to create, access, and search these messages through the Identi.ca API.
Use Built-In XPath Functions
(Adam Heyman) In developing one of the Altova Online Training courses, I sorted a list of books by the authors. I realized that my author field was a string of the author’s full name, so the books were sorted by the first letter of the string, or the author’s first name.