Wiki

TechNet Wiki

Visit a content portal to find information, resources, and help over a wide range of topics, projects, and issues.

Featured Articles

Small Basic: AutoUpdater Code Snippet

By Timo Sö
November 11, 2013

This snippet will check if a newer version of your program is avaible for download. And if there is a new version, it will download and install it. What do you need? You need... 1. SmallBasic, 2. the snippet, 3.a text file, 4.a file uploader, 5.the LitDev extension (alternative). This snippet will not work with every file uploader. The best way is to create an own website. There are many free providers like hpage and Oyla. If you find a file uploader...

SharePoint: Using PowerShell to Group Filter and Sort Documents by Metadata

By Matthew Yarlett
November 11, 2013

You can use PowerShell to group documents (or list items) based on metadata. You might want to do this to find documents that are duplicates, to find the most active authors for a certain metadata combination (i.e. group by author, then by document type), or to create a report on metadata combinations. Though some of this functionality can be produced using ListViews, there are scenarios where a ListView can't be used...

Query Power Pivot DMVs with VBA

By Olaf Helper
November 11, 2013

Power Pivot is designed to be compatible with the tabular / multidimensional database of SSAS. So also the DMV = Dynamically Management Views, as known from SSAS, are available here. The DMVs provide useful information about existing objects like dimensions and measures, as well as statistical information like memory usage. We can query a Power Pivot DMV with a SQL-like SELECT statement...

Structured Error Handling Mechanism in SQL Server 2012

By Saeid Hasani
November 8, 2013

The goal of this article is to provide a simple and easy to use error handling mechanism with minimum complexity. There are many questions in the MSDN forums and other Internet communities about Error Handling in SQL Server. These are the questions: Is there any structured Error Handling mechanism in SQL Server? Is it a good idea to use a general procedure as a modular Error Handler routine? What are the benefits of THROW...

More featured articles


Recent Activity
Loading activity...