SSWUG.ORG Author Content

Useful Undocumented Miscellaneous SQL Server 2008 DBCC Commands

In this article, Alexander Chigrik shows some useful undocumented miscellaneous DBCC commands that shipped with SQL Server 2008.

Robust print view for SharePoint list views

Nearly any intranet or extranet and especially Internet site will require to have a print view for pages or sections of the site. If you take a standard approach of modifying CSS you might be spending days trying to get details of list views acceptable for printing. Here we take a look at a solution that will potentially save you lots of time.

Combine Named Sets and Calculated Members in Analysis Services, Pt. 2

Part 2: Combine Named Sets with Calculated members to meet client and employer business requirements. Join BI Architect Bill Pearson as he leads hands-on exploration of Named Set / Calculated Member combinations in Analysis Services.

Improving BI Technology with MSSQL Server 2008

Not long ago, the Software giant Microsoft, dazzled the world with their utility products, namely Microsoft Office and Microsoft SQL Server. A bit later, with the improvement of SQL Server, Read this article about Improvement on Microsoft SQL Server 2008 with a list of functions explained in a few words.

Combine Named Sets and Calculated Members in Analysis Services, Pt. 1

Combine Named Sets with Calculated members to meet client and employer business requirements. Join BI Architect Bill Pearson as he leads hands-on exploration of Named Set / Calculated Member combinations in Analysis Services.

Useful Undocumented Informational SQL Server 2008 DBCC Commands

In this article, Alexander Chigrik shows some useful undocumented informational DBCC commands that shipped with SQL Server 2008.

SharePoint file filtering beyond out-of-the-box

Whether for audit or to enforce policy, file filtering in SharePoint is an excellent feature. Out of the box, you can specify the list of files you want to be blocked; not really do any audit on already uploaded files. Also, if user renames file extension � SharePoint can`t really detect the actual file type that is used and allow for bad content to be uploaded. Here we`ll check out some other options that prevent your server from becoming a distribution point for bad content.

SQL Server Tips for the SharePoint Administrator

There are several things to keep an eye on when you deploy you SharePoint installation with SQL Server. Here is a quick checklist of items that can help make working with your systems a bit more proactive.

Molecular MDX: Working with Time: First and Last Periods, Part 3

Part 3: 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.

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.

Changing SharePoint page layout type and schedule

Here is the scenario: you have deployed several SharePoint layouts and pages inheriting them. For example: one column layout, two column and three column layout. What if your portal users want to change the layout later? Here`s we`ll take a look at how to do that and also enable page scheduling after your page libraries have been deployed.

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.

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.

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.

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.

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 to pages. How do you limit users to be able to select only webparts particular to your site?

Database Snapshots

Database Snapshots first appeared in SQL Server with the release of SQL Server 2005. The quick once-over definition of what a database snapshot is can be covered in a simple statement: �A Database Snapshot is a read only copy of the database�.

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

Tips for using ASP.NET with SQL Server 2005 (Part 1)

Here you can find some useful tips to use ASP.NET with SQL Server 2005.

Customizing sharepoint page navigation using custom control

Navigation in SharePoint is not just a set of links that you can`t leverage; you can actually connect to a navigation DataSource and render your navigation depending on your custom logic or design requirements.

Archiving Partitioned Data to the Cloud

This article describes a solution to backup partitioned data to a cloud storage provider for long term retention. It also describes how to partition a table, partial backup concept, and cloud storage software.

Troubleshooting Replication subscribers not in sync

Have you encountered a situation where the replication monitor does not show any errors but the users accessing the subscriber table keeps complaining of missing records?

Tips for using SQL Server 2005 indexed views

Here you can find some useful tips to use SQL Server 2005 indexed views.

Validating CheckBoxList using CustomValidator

When creating user controls and aspx pages you probably make a heavy use of client side validators to ensure user has entered valid values before sending request to a server. Although this has been a standard approach for the longest time - some controls that are used very often, like CheckBoxList, don`t have out of the box client side validators. Here we take a look how to create one by yourself

Cloud computing and Database Part - 1

Cloud computing and Database

Prevent users from overwriting changes made by other users - PART III

Prevent users from overwriting changes made by other users

Custom SharePoint webpart property error messages

When creating webparts with properties in them to store custom data - you can never rely too much on users not making errors and typos. The best way to tell your site contributors that they have specified an invalid webpart property is to display error message right there is a webpart tool pane - here is how ...

Elemental MDX: More Basic Building Blocks, Part 3

Part 3: BI Architect Bill Pearson continues his examination of the basic building blocks of the MDX query, including tuples, sets, and axes. He then leads a hands-on introduction to three basic MDX operators: Braces, Comma, and Colon. Learn the syntax involved in putting each into action, and its practical use in helping us to achieve our query objectives.

Elemental MDX: More Basic Building Blocks, Part 2

Part 2: BI Architect Bill Pearson continues his examination of the basic building blocks of the MDX query, including tuples, sets, and axes. He then leads a hands-on introduction to three basic MDX operators: Braces, Comma, and Colon. Learn the syntax involved in putting each into action, and its practical use in helping us to achieve our query objectives.

Prevent users from overwriting changes made by other users - PART II