MS Development Support - MS Development Help from MS Development Experts

Pie Chart Techniques ValentinoV10/29/2009, 12:00 AM Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips. This article explained how to optimize a Column Chart. Today I have returned to show you some Pie Chart implementation techniques. As usual, I will Topic: MS SQL ReportingTags: SSRS, SQL Server Reporting Services 2008, pie chart, reporting services, charting Views: 21870Comments: 12
Median, Mode, Skewness, and Kurtosis in MS Access matthewspatrick02/24/2010, 12:00 AM by Patrick G. Matthews Introduction Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance Topic: Microsoft Access DatabaseTags: Microsoft, Access, Statistics, Mean, Median, Mode, Standard Deviation, Skewness, Kurtosis, Sampling, Visual Basic, Visual Basic for Applications, VBA Views: 15728Comments: 23
Your First OLAP Report ValentinoV01/24/2010, 12:00 AM This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting Topic: MS SQL ReportingTags: SSRS, SQL Server, Reporting Services, mdx, olap, SSAS, Analysis Services, cube Views: 15583Comments: 12
Retrieving Data From Excel Using OPENROWSET() ValentinoV05/04/2010, 12:00 AM The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a significant amount of time has probably come into contact Topic: MS SQL ServerTags: import Excel, openrowset, SQL Server, SQL Views: 15468Comments: 6
MFC Feature Pack for VS 2008 and 2010 DanRollins12/19/2009, 12:00 AM In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008. These same feature are in the MFC libraries that come with Visual Topic: Windows MFC ProgrammingTags: VC++, Visual Studio, MFC Feature Pack, Win7, CMFCMaskedEdit, CMFCMenubar, CMFCButton, CMFCFontComboBox, Tear-off menus, Dan Rollins Views: 15030Comments: 7
AjaxControlToolkit’ TabContainer control’ Javascript functions. sand198002/25/2010, 12:00 AM In this blog we will start with a common requirement for the tab container control i.e. setting focus to a tab using javascript and later at the end of this blog we will also see some important javascript functions available with ASP.NET AJAX Tab Co Topic: Programming for ASP.NETTags: ASP.NET AJAX, TabConainer, ASP.NET Views: 14411Comments: 0
Calculating Distinct Counts in Access matthewspatrick02/08/2010, 12:00 AM by Patrick G. Matthews All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception. As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns t Topic: Microsoft Access DatabaseTags: Access, Query, Queries, SQL, Distinct, Count, Distinct Count, VBA, Visual Basic, Aggregate, Domain Aggregate Views: 13412Comments: 18
ASP.NET : Mobile Device Detection and Redirection amimpat01/19/2010, 12:00 AM This article explains approaches for ASP.NET mobile development to determine if an HTTP request is coming from a mobile phone and then redirecting the request to a page optimized for a mobile browser. Examples in below article are in c#.net Me Topic: Programming for ASP.NETTags: ASP.NET, Device Detection, Browser Detection, ASP.NET Mobile, Mobile Web Views: 11867Comments: 34
Use AJAX ModalPopupExtender in GridView or other data controls prairiedog04/08/2009, 12:00 AM AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays, Topic: Programming for ASP.NETTags: ASP.NET, AJAX ModalPopupExtender Views: 11657Comments: 2
Adding an Else to your Switch ValentinoV01/16/2010, 12:00 AM In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack. Those functions are IIF() and Switch(). And I'll be showing you how easy it is to add an Else part to the Switch function. T Topic: MS SQL ReportingTags: Reporting Services, SSRS, IIF, Switch, if, switch else, sql server Views: 10288Comments: 7
How to Mimic the T-SQL IsNumeric() Function in MySQL mwvisa111/21/2008, 12:00 AM In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number Topic: SQL Query SyntaxTags: MySQL, IsNumeric, RegExp, Regular Expression, Sorting Text and Numbers Separately, SQL, RegExp_Like Views: 9737Comments: 28
Hide/Show Validator Callout Control Using Javascript sand198004/06/2010, 12:00 AM In this article we will see how to show and hide a ASP.NET AJAX’ (AJAXControlToolkit) ValidatorCalloutExtender control using Javascript. Below is an .aspx page with a validator callout control. <%@ Page Language="C#" AutoEventWireup="true" CodeF Topic: Programming for ASP.NETTags: ASP.NET AJAX, ValidatorCalloutExtender, ASP.NET Views: 9706Comments: 16
Dynamic Pivot Procedure for SQL Server mark_wills05/15/2009, 12:00 AM by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively Topic: SQL Server 2005Tags: SQL2005 sql2008 PIVOT Views: 9595Comments: 16
Expanding a Hierarchical Data Structure mbizup06/20/2008, 12:00 AM Introduction One of the earliest concepts learned by database developers is parent-child (one-to-many) relationships. These relationships are integral in countless database applications. A purchase request containing one or more items ordered i Topic: Microsoft Access DatabaseTags: Databases, MS Access, Bill of Materials, BOM, Parts Lists, heirarchical, recursion Views: 8701Comments: 42
Chart Optimization Tips ValentinoV09/26/2009, 12:00 AM Here are some optimization techniques that can be used when creating charts in SQL Server 2008 Reporting Services. These tips will probably be already known to experienced chart developers, but freshmen charters may spent some time searching how to Topic: MS SQL ReportingTags: SQL Server Reporting Services 2008, chart, SSRS, Reporting Services Views: 8659Comments: 14
Simple Linear Regression in MS Access matthewspatrick04/03/2010, 12:00 AM by Patrick G. Matthews Introduction Linear regression analysis is a common statistical technique used to infer the possible relationships between a dependent variable and one or more independent variables. While Microsoft Access does not Topic: Microsoft Access DatabaseTags: Access, Microsoft, regression, regression analysis, linear regression, statistics, VBA, VB, Visual Basic, coefficients, r squared, standard error Views: 8189Comments: 13
Working with Modal Popup extender control. sand198008/08/2010, 12:00 AM This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal Topic: Programming for ASP.NETTags: ASP.NET, ASP.NET AJAX, Modal Popup Extender Views: 8168Comments: 24
Building a Formless WinForms Application with a NotifyIcon in VB.Net 2008 Idle_Mind03/24/2010, 12:00 AM This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru Topic: Microsoft Visual Basic.NetTags: ApplicationContext, NotifyIcon, WinForms, Visual Basic.Net Views: 8133Comments: 20
"Domain Aggregate" for Concatenating Values by Group in Microsoft Access matthewspatrick02/02/2010, 12:00 AM by Patrick G. Matthews A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query. For example Topic: Microsoft Access DatabaseTags: Access, VBA, SQL, query, domain aggregate, concatenate Views: 7941Comments: 21
Radio Buttons in MFC Dialogs DanRollins09/12/2009, 12:00 AM Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms. Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go. MFC has a very cool system for handli Topic: Windows MFC ProgrammingTags: MFC, DDX_Radio, C++, DoDataExchange, RadioButton group, enabling dilaog items, Dan Rollins Views: 7727Comments: 1
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error aelliso307/07/2010, 12:00 AM Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t Topic: MS SQL ReportingTags: SSRS 2008 SQL Server R2 User Access Control UAC Permission Error Views: 7595Comments: 6
Output an XML type attribute using DataContract williamcampbell08/31/2009, 12:00 AM This tutorial will show you how to add an attribute to an XML stream returned from a Windows Communication Foundation (WCF) Web Service. Some knowledge of WCF and XML is required; the code is in C#. Below is an XML sample of an attributed XML stre Topic: Web Services and WCFTags: DataContract Attribute, XML, C#, WCF Views: 7372Comments: 39
PIVOT Transformation - SSIS - Complete Tutorial reza_rad02/15/2010, 12:00 AM Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft : Mi Topic: SSISTags: PIVOT, PIVOT Transformation, SSIS, Tutorial Views: 6922Comments: 9
Analytical SQL : Where do you rank? mwvisa109/16/2009, 12:00 AM "Top 10 customers by salesperson" sound familiar? Yes! I would expect so, and am sure there are a number of other great business analyses with a similar principle now flowing through your mind. So, how do you query this data in your SQL system? Topic: SQL Query SyntaxTags: Analytical Functions, Row_Number, Rank, NTile, Dense_Rank, Over, MySQL, Oracle, MS SQL, MS Access Views: 6882Comments: 27
Delimited String Parsing in SQL Server 2005 and later BrandonGalderisi11/20/2008, 12:00 AM This article will describe one method to parse a delimited string into a table of data. Why would I do that you ask? Let's say that you need to pass multiple parameters into a stored procedure to search for. For our sake, we'll say that we wa Topic: SQL Server 2005Tags: parse, string parsing, delimited string, user defined function, sql server 2005, sql server 2008 Views: 6771Comments: 8
Covariance and Correlation in MS Access matthewspatrick03/24/2010, 12:00 AM by Patrick G. Matthews Introduction Access provides functions for computing several common descriptive aggregate statistics for column data, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance (StDev, Topic: Microsoft Access DatabaseTags: correlation, correlated, covariance, MS, Microsoft, Access, domain aggregate, Visual Basic, Visual Basic for Applications, VB, VBA Views: 6419Comments: 23
SARGable functions in SQL Server rob_farley02/24/2010, 12:00 AM This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou Topic: SQL Server 2008Tags: SQL Server, Indexing Views: 6357Comments: 6
Encryption - Decryption in SQL Server 2008 and backup database with encrypted data and restore it somewhere else. RiteshShah02/04/2010, 12:00 AM Long way back, we had to take help from third party tools in order to encrypt and decrypt data. Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, Topic: SQL Server 2008Tags: Encryption, decryption, backup database, restore database, certificate, symmetric key Views: 6344Comments: 13
Connect to your SQL Server angelIII10/28/2009, 12:00 AM If you are already familiar with all the terms, you can skip this section. Anyone else just read on for the quick introduction of the terms that are important to know and distinguish, when troubleshooting SQL server login issues. First, the pur Topic: MS SQL ServerTags: MS SQL Server, Database, Instance, Connect Views: 6228Comments: 20
Dlookup and the Domain Functions JDettman06/18/2008, 12:00 AM Applies to: All versions of Access Skill Level:Beginner One of the common questions we see in the Access zone is how to get a value from a table. One way to do that is with a set of built-in functions called Domain functions. These functio Topic: Microsoft Access DatabaseTags: "Microsoft Access" Access VBA Beginner Views: 6183Comments: 17
Updating a Splash Screen with Loading Progress in a VB.Net WinForms Application Idle_Mind09/08/2010, 12:00 AM Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties. A splash screen set in this manner is automatically created, displayed and closed by the framework itsel Topic: Microsoft Visual Basic.NetTags: VB.Net, Visual Basic, Splash Screen, Update, Progress, WinForms Views: 6127Comments: 14
Getting Your Application Kinect-ed kaufmed06/17/2011, 12:00 AM For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK for the Xbox 360 Kinect. If you don't know what a Kinect is, then I will assume you do indeed live under a rock. The Xbox 360 peri Topic: .NETTags: c#, .NET, VB.NET, Kinect, XBox Views: 5963Comments: 30
Migrating from VSS 2005 to TFS 2010 using VSSConverter -- Missing Instructions rscowden04/24/2010, 12:00 AM If you have have been using Visual Studio 2008 with VSS and are now migrating to Visual Studio 2010 and Team Foundation Server, you may need to migrate your VSS data to TFS. Microsoft has made VS 2010 TFS available to VS2008 with MSDN subscribers a Topic: Visual StudioTags: VSS, TFS Views: 5815Comments: 2
Speedier Execution of Stored Procedures in SQL Server Bobaran9807/30/2009, 12:00 AM I started a new job about six months ago, and with that job I inherited a mission-critical SQL Server 2005 database with over 800 stored procedures and tens of millions of records. I also inherited what appeared to be a growing problem: certain of Topic: MS SQL ServerTags: parameter sniffing, stored procedure, query, sql server, sql server 2005, sql server 2008, sql server 2000, t-sql, optimization, sql Views: 5710Comments: 35
Simple ASP.NET download page PaulHews03/11/2010, 12:00 AM Download the code and data for this sample application. There are times when you need to track downloads of a particular resource from your server. While IIS maintains logs of each HTTP request, it would be painful to use them to track downloads Topic: Programming for ASP.NETTags: ASP.NET 2.0, track downloads Views: 5649Comments: 10

Top Articles

Pie Chart Techniques

Median, Mode, Skewness, and Kurtosis in MS Access

Your First OLAP Report

Retrieving Data From Excel Using OPENROWSET()

MFC Feature Pack for VS 2008 and 2010

AjaxControlToolkit’ TabContainer control’ Javascript functions.

Calculating Distinct Counts in Access

ASP.NET : Mobile Device Detection and Redirection

Use AJAX ModalPopupExtender in GridView or other data controls

Adding an Else to your Switch

How to Mimic the T-SQL IsNumeric() Function in MySQL

Hide/Show Validator Callout Control Using Javascript

Dynamic Pivot Procedure for SQL Server

Expanding a Hierarchical Data Structure

Chart Optimization Tips

Simple Linear Regression in MS Access

Working with Modal Popup extender control.

Building a Formless WinForms Application with a NotifyIcon in VB.Net 2008

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access

Radio Buttons in MFC Dialogs

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error

Output an XML type attribute using DataContract

PIVOT Transformation - SSIS - Complete Tutorial

Analytical SQL : Where do you rank?

Delimited String Parsing in SQL Server 2005 and later

Covariance and Correlation in MS Access

SARGable functions in SQL Server

Encryption - Decryption in SQL Server 2008 and backup database with encrypted data and restore it somewhere else.

Connect to your SQL Server

Dlookup and the Domain Functions

Updating a Splash Screen with Loading Progress in a VB.Net WinForms Application

Getting Your Application Kinect-ed

Migrating from VSS 2005 to TFS 2010 using VSSConverter -- Missing Instructions

Speedier Execution of Stored Procedures in SQL Server

Simple ASP.NET download page

Top MS Development Experts