|
|
|
|
|
| | Total Hits: 105 | Today: 0 | Author: Mark Mathieson | Rating:  |
| | 
In this first part, we take a step-by-step approach to automatically generate a bar (or pie) chart from data stored in a database.
In the second part, we dynamically add hot spots to the bars/slices in our chart and link them to other pages.
This may seem like a tall order, but it can be relatively easily accomplished with the right tools and approach.... |
| | Total Hits: 45 | Today: 0 | Author: Venu Anuganti. | Rating: |
| |
Microsoft .NET is a set of Microsoft software technologies for connecting your world of information, people, systems, and devices. It enables an unprecedented level of software integration through the use of XML Web services: small, discrete, building-block applications that connect to each other as well as to other, larger applications via the Internet.... |
| | Total Hits: 51 | Today: 0 | Author: Andrew Novick | Rating: |
| |
In a recent article I showed how to create a User Aggregate function SQL Server 2005 using the .Net CLR. Recently I got a note from Joe Celko about producing the aggregate with SQL instead of resorting to CLR programming. Joe isn't enthusiastic about running non-SQL code inside of a relational engine and he explains some of the reasons in this article. When he read my article it responded with a way to create the Product aggregate that doesn't rely on using the CLR.... |
| | Total Hits: 104 | Today: 0 | Author: Denis Susac | Rating: |
| |
Data mining is the process of extracting valid, previously unknown and comprehensible information from conventional databases and using it to make crucial business decisions. It is one of the most exciting new features of Analysis Services in SQL Server 2000. Now you can use data mining with either relational data sources or OLAP cubes.... |
| | Total Hits: 168 | Today: 0 | Author: Scott Mitchell | Rating: |
| |
When displaying large amounts of data to a user, it's important that the information be presented in digestible chunks rather than slamming it all down their throats at once. For example, searching for "Microsoft" on Google returns approximately 2,190,000,000 results, but thankfully Google only shows me ten of those at a time. When providing paging access to particularly large result sets - tables with tens of thousands, hundreds of thousands, or millions of records - care must be taken in query... |
| | Total Hits: 289 | Today: 0 | Author: Baya Pavliashvili. | Rating: |
| |
After you have populated your dimensional database (as discussed in the previous article in this series), you're ready to build Analysis Services cubes (Analysis Services is free when you purchase SQL Server 2000). The tool that lets you build and manage cubes with Analysis Services is called Analysis Manager, which is similar to Enterprise Manager. The language used to query Analysis Services cubes is called MDX (Multi Dimensional eXpressions). Although simple SELECT statements in MDX resemble ... |
| | Total Hits: 129 | Today: 0 | Author: gotdotnet.com | Rating: |
| |
You can use the .NET Compact Framework to create and manage SQL Server CE databases on a Windows CE .NET device. This QuickStart shows you how to create a SQL CE database, connect to a SQL CE database, create a table in a SQL CE database, insert a row into a SQL CE database.... |
| | Total Hits: 351 | Today: 0 | Author: Jayaram Krishnaswamy | Rating: |
| |
As businesses may have more than one SQL Server holding their data, it is of interest to know the technique of connecting to mulitple servers through saving connection information in the configuration of the application. In fact, it is a recurring question in several forums. This tutorial addresses this question in detail.... |
| | Total Hits: 142 | Today: 0 | Author: Jeremy Kadlec | Rating: |
| |
This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective.... |
| | Total Hits: 203 | Today: 0 | Author: MSDN | Rating: |
| |
The top of the stack is the API or object library layer. Applications connect to Microsoft® SQL Server through either API functions or interfaces exposed by an object library. Examples of APIs used to access SQL Server include ODBC and DB-Library. Examples of object libraries used to access SQL Server include OLE DB, ADO, and ADO.NET. Because ADO ultimately uses OLE DB to communicate with the server, there are really just two object libraries commonly used by Windows applications to communicate ... |
| | Total Hits: 2231 | Today: 0 | Author: Roger Jennings | Rating: |
| |
Creating crosstab reports with T-SQL is a hot topic in the SQL Server community--and you'll probably need to design high-performance XML Web services that generate ad hoc crosstab reports. Roger Jennings shows you a new approach with ADO.NET and ASP.NET.... |
| | Total Hits: 0 | Today: 0 | Author: Karthikeyan Anbarasan | Rating:  |
| |
In this article we are going to see how to use the Character Map transformation control in SSIS Packaging. Character Map transformations are used to do some formatting for the columns based on users selection. The formatting can be like transforming Lower to upper case, Upper to lower case, Byte reversal, half width, Full Width etc. These transformations are used in the data flow process to maintain some standards across the application and to save some issues in the log based on the application... |
| | Total Hits: 0 | Today: 0 | Author: Karthikeyan Anbarasan | Rating: |
| |
In this article we are going to see how to use an Audit transformation control. Audit transformation helps the uses to build a package which requires about the environment on which the package runs like the computer name, the path where the package is running, name of the package and the operator by using the system variable available with these functions. Let's jump start into the example to see on how to use this control.... |
| | Total Hits: 1 | Today: 0 | Author: Karthikeyan Anbarasan | Rating: |
| |
In this article we are going to see how to use an Aggregate (Minimum) data flow transformation control in SSIS packaging. With this function operation we can get a number which is a minimum of a column. To start with this we should have the column to be of integer data type as specified in order to get the minimum. Let's jump into to the example on how to use this control in real time.... |
| | Total Hits: 0 | Today: 0 | Author: Karthikeyan Anbarasan | Rating: |
| |
In this article we are going to see how to use an Aggregate (Maximum) data flow transformation control in SSIS packaging. With this function operation we can get a number which is a maximum of a column. To start with this we should have the column to be of integer data type as specified in order to get the maximum. Let's jump into to the example of how to use this control in real time.... |
| | Total Hits: 1 | Today: 0 | Author: PIEBALDconsult | Rating: |
| |
SQL Server 2008 introduced the concepts of User-Defined Table Types (UDTTs) and Table-Valued Parameters (TVPs).
These allow you to pass a DataTable as a parameter.
There are a few articles about these here.
The articles I've seen pass DataTables to Stored Procedures, but you can use them in embedded SQL as well.... |
| | Total Hits: 0 | Today: 0 | Author: Madhu.b.rokkam | Rating: |
| |
At times we come across situations where we had to split data based on some conditions. And doing this is very easy in SSIS Conditional Split task.
The Conditional Split can be used to transfer data to different outputs depending on the condition specified and content of the data. This almost acts the same way as we have Switch Case statement in programming language. This too has the default option to redirect rows if non of the conditions met.
Let us consider a scenario where we h... |
| | Total Hits: 0 | Today: 0 | Author: Syed Shakeer | Rating: |
| |
This article will explains you how to delete and update a Child Table records implicitly when updating or deleting a Parent Table.... |
| | Total Hits: 2 | Today: 0 | Author: merlin981 | Rating: |
| |
In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ. LINQ is the new initiative of Microsoft to support Object-Relational Mapping concepts and design patterns. LINQ provides a full type-safety and compile-time checking of query expressions in order to minimize the object-relational concepts mismatch and enables managing relational data as objects providing an easy way to integrate data validation and busines... |
| | Total Hits: 0 | Today: 0 | Author: Sivaraman Dhamodaran | Rating: |
| |
SQL server provides different kind of data types that can be some times may be little confusing to make a correct choice among them. In this article, I will just cover different data types and I will leave the selection of those data types when you actually do your database design. It is to know that the available choices first.... |
|
|
|
|
|
|
|
|
|
|
|
|
|