|
|
|
|
|
| | Total Hits: 164 | Today: 0 | Author: Robert Walters | Rating:  |
| | 
This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.... |
| | Total Hits: 494 | Today: 0 | Author: Baya Pavliashvili. | Rating: |
| |
Building a data warehouse involves several complicated steps (some of which I described in my previous articles for InformIT). After the data warehousing architect locates all data elements necessary to support the data warehouse, it is time to build a dimensional model. As data change in transactional systems, the data warehouse needs to have a way of tracking and reflecting such changes. Populating fact and dimension tables can take considerable amount of time if the population routines aren't... |
| | Total Hits: 852 | Today: 0 | | Rating: |
| |
The goal of clustering is to divide the data set in predetermined ("K") number of clusters around the average locations ("means"), so the algorithm is also known as the K-Means algorithm. Like other techniques it is applied mostly on people, to discover hidden grouping that can't be noticed at the first glimpse.... |
| | Total Hits: 11 | Today: 0 | Author: Microsoft Press | Rating:  |
| |
Microsoft SQL Server 2008 R2 Parallel Data Warehouse is an enterprise data warehouse appliance based on technology originally created by DATAllegro and acquired by Microsoft in 2008. In the months following the acquisition, Microsoft revamped the product by changing it from a product that used the Linux operating system and Ingres database technologies to a product based on SQL Server 2008 R2 and the Windows Server 2008 operating system. SQL Server 2008 Enterprise has many features supporting sc... |
| | Total Hits: 2 | Today: 0 | Author: Dinesh Asanka | Rating: |
| |
In a data warehouse, the most challenging thus interesting part is the ETL (Extraction, Transform and Loading) process. The challenge comes as you have to work on different databases which were not designed by you.... |
| | Total Hits: 117 | Today: 0 | Author: Edwin Sarmiento | Rating: |
| |
In a previous tip on Database Mirroring Automating Failover for Multiple SQL Server Databases, you've seen how you can failover all of the databases in a mirroring session if one database fails over. However, what happens if you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?... |
| | Total Hits: 259 | Today: 0 | Author: Jagadish Chaterjee | Rating: |
| |
This article is the second in a series focusing on retrieving SQL Server 2005 information using SMO along with Visual Basic 2005 and Visual Studio 2005. With the basics covered in the previous article, this one goes right into technical information.... |
| | Total Hits: 87 | Today: 0 | Author: Ernest Bonat | Rating: |
| |
Lookup tables contain, in general, a fixed list of data. This data doesn’t change very often in database business applications. Examples of this data could be a product list, category type, supplier list, state name, zip code, phone area code, etc. In Windows and Internet web business applications, most of these lookup tables are graphically implemented by using ComboBox, ListBox or CheckListBox read-only controls. These controls are loaded with data using two main columns, ID and Name. For exam... |
| | Total Hits: 789 | Today: 0 | | Rating: |
| |
A Data Mining application for Relational Databases (RDBMS) including Microsoft® Access®, Microsoft SQL Server® , Oracle® and Sybase ® databases. The attached articles in HTML and Microsoft Word gives a detailed step by step guide to the development of a Data Mining application.... |
| | Total Hits: 4270 | Today: 0 | | Rating: |
| |
The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This arti... |
| | Total Hits: 1262 | Today: 0 | | Rating: |
| |
This article outlines several main types of slowly changing dimensions. After showing how an online analytical processing (OLAP) server operates when reading dimension members, the article then offers ways to handle these and other real-world scenarios using Microsoft® SQL Server™ OLAP Services.... |
| | Total Hits: 10 | Today: 0 | Author: Karthikanbarasan | Rating:  |
| |
In this article we will see on how to Import data from SQL server using the wizard which is provide with the SSMS (SQL server Management Studio). Using SSMS we can perform many tasks like copying data from one server to the other or from one data source to the other in variety of formats. Here our task is to do Import data from SQL server to Excel using the Wizard.You can look into Part 1, Part 2 and Part 3 of my SSIS articles at the below urls... |
| | Total Hits: 7 | Today: 0 | Author: Paulo Condeca | Rating: |
| |
Microsoft put a great deal of effort into SQL Server 2005 and 2008 to ensure that that the platform it is a real Enterprise class product. I’m not going to write about all the new features in the OLTP Engine, in this article I will focus on Database Partitioning and provide a real world scenario. This article will cover the following points:
I. Benefits and Limitations of Partitioning (HEAPS/CLUSTERED/NONCLUSTERED).
II. Implementation Methodology.... |
| | Total Hits: 167 | Today: 0 | Author: Armando Prato | Rating: |
| |
I've read a lot of articles that talk about database pages and how they're used to store table data and index data. Is there some way I can actually look at this information? One of the worst kept secrets in the SQL Server community is the undocumented DBCC PAGE command which allows you to examine the contents of data and index pages. Some of this information is a bit cryptic and your favorite search engine is a good place to start to find a lot of the meanings behind the output it displays. How... |
| | Total Hits: 133 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
Discover best practices and suggestions for working with Microsoft SQL Server and Microsoft Analysis Services for analytic applications. These practices and suggestions have been compiled from answers to questions submitted by developers and customers, and cover topics ranging from dimensional modeling to designing OLAP cubes and writing MDX expressions. This is not an introductory paper.... |
| | Total Hits: 208 | Today: 0 | Author: Ron Talmage | Rating: |
| |
Moving a SQL Server database from one server to another is simple-initially. But there are various methods for moving a database, and some have more advantages than others. Investigating the types of moves ahead of time can make planning for a database migration easier.
It takes essentially three steps to move a database from one server to another: take the database out of production, copy it to another server, and then bring the copy back into production. While you can choose from many m... |
| | Total Hits: 126 | Today: 0 | Author: extremeexperts | Rating: |
| |
Database storage is one of the primary failure point in the database environment. Hence, making the storage architecture consistent and at the same time giving it maximum redundancy must be embedded within the design itself. When I call redundancy, I don’t specifically say implementing anything specific to RAID or SAN or other mechanisms. Redundancy must be achieved given your hardware and budget currently in hand – if it even means making just multiple backup copies at the simplest level.... |
| | Total Hits: 133 | Today: 0 | Author: Jasper Smith | Rating: |
| |
In this series of articles, I'll demonstrate a couple of different approaches to writing a maintenance utility that mimics some of the behavior of the sqlmaint utility that is included with SQL Server 2000. SQL Server 2005 Express Edition does not include such a utility, so these articles will show how we can easily create one ourselves using either TSQL or SMO (SQL Management Objects - the successor to SQL-DMO). Rather than dive into the code, these articles will demonstrate how to use these ut... |
| | Total Hits: 310 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
I have over night processes on a few different SQL Servers in my environment that are backup and restore related. I have used the scripts on MSSQLTips.com to check if the SQL Server Agent Jobs\Job Steps have run as well as the backup verification code. Some of the backup and restore processes I have written and others I have inherited. Some of the processes seem to be very reliable and others are not. I need a way to validate the restore processes have completed properly just like the SQL Se... |
| | Total Hits: 202 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
Discover best practices and suggestions for working with Microsoft SQL Server and Microsoft Analysis Services for analytic applications. These practices and suggestions have been compiled from answers to questions submitted by developers and customers, and cover topics ranging from dimensional modeling to designing OLAP cubes and writing MDX expressions. This is not an introductory paper... |
|
|
|
|
|
|
|
|
|
|
|
|
|