Featured Article(s) Useful Undocumented Maintenance SQL Server 2008 DBCC Commands In this article, Alexander Chigrik shows some useful undocumented maintenance DBCC commands that shipped with SQL Server 2008. Webcast Today – Register Now Measure Twice, Develop Once One site-collection or two? Subsite or List? The answer to these questions guides the decisions of many deployments. When mistakenly answered organizations quickly […]

Virtual Event University – What Options Are There? How does your company offer training to your customers? The happiest customers are the most knowledgeable. Deliver them the information they want and need the most professional way. Invite your training department to this event on how to accomplish your online training goals. The event is Thursday, and it’s free. Click here […]

Featured Article(s) Molecular MDX: Working with Time: First and Last Periods, Part 2 Part 2: Join BI Architect Bill Pearson as he introduces a subseries of articles focused on the retrieval of data from the perspective of time. In this article, we explore the OpeningPeriod() and ClosingPeriod() functions to select “first” and “last” time periods to meet various business needs. […]

Featured Article(s) Do You Use Like? Here are some tips that can help When using the LIKE clause in your TSQL, there are things you can do to make it more efficient, and things you can do to make it work much harder than needed. Here are some tips to help address these issues. Ethics Revisited Within the last few […]

Featured Article(s) Molecular MDX: Working with Time: First and Last Periods, Part 1 Part 1: Join BI Architect Bill Pearson as he introduces a subseries of articles focused on the retrieval of data from the perspective of time. In this article, we explore the OpeningPeriod() and ClosingPeriod() functions to select “first” and “last” time periods to meet various business needs. […]

Featured Article(s) Tips for using ASP.NET with SQL Server 2005 (Part 2) Here you can find some useful tips to use ASP.NET with SQL Server 2005. Virtual Conference Starts Today – Still Time to Register The SSWUG.ORG Virtual Conference gets underway today – there is still time to register and attend (that’s the cool thing – we bring it to […]

Featured Article(s) Hide unused SharePoint webparts Here is the scenario: You deployed your SharePoint solution and applied your specific themes for all of the webparts and components to look exactly how you wanted them to look. Few weeks later, your users report some pages look different. You discover that out of the box webparts you haven`t styled have been added […]

From the editor… Due to an error in the newsletter process, the editorial and featured content was not included in today’s email newsletter. We’re re-sending the newsletter with these portions included. Thanks for all the email about the missing bits! Featured Article(s) Database Snapshots Database Snapshots first appeared in SQL Server with the release of SQL Server 2005. The quick […]

Only a couple of days left to register! Want to Stay Up To Speed with SQL Server? Oct 21, 22, 23 – SSWUG.ORG Virtual Conference [Register Here] 75+ sessions, expert speakers, time is running out to register. Oct 26, 27, 28 – Smart Database Design Class with Paul Nielson In-person, hands-on class about best practices, approaches and more. Seats VERY […]

Featured Article(s) Sharepoint Installation Part III Part three of the multi-part Sharepoint installation series. This part covers how to upgrade a stand-alone installation to a server Farm Understanding Business Intelligence I wanted to pass along a couple more thoughts on understanding Business Intelligence and Business Insight. Here’s what Jason had to say: "American Heritage Dictionary definitions: intelligence: the capacity to […]