|
|
|
|
|
Total Hits: 39 | Today: 0
|
Author: Alek Davis
|
Rating:
|
|
This article discusses:Automating database installation
Automating upgrades
Version management
Making install scripts generic...
|
|
|
|
Total Hits: 64 | Today: 0
|
Author: T.K. Anand
|
Rating:
|
|
Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.
Data integrity issues are common in relational databases, especially in operational (OLTP) systems. These issues are typically fixed by ETL (Extraction, Transformation and Load) jobs that load the data into a data warehouse. However it is not uncommon to have some integrity issues even in data warehouses.
SQL Server 2005 Analysis Services supports cubes built directly from opera...
|
|
|
|
Total Hits: 180 | Today: 0
|
Author: Hari Prasad K.
|
Rating:
|
|
The DMV’s; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine. These values will help the administrator to diagnose problems and tune the server for optimal performance. DMV’s are designed to be used instead of system tables and various other functions provided in SQL Server 2000. In this article I will be explaining only about the frequently used DMV’s.
Two types of dynamic management views:-
1. Server-scoped D...
|
|
|
|
Total Hits: 47 | Today: 0
|
Author: Jason R. Hall.
|
Rating:
|
|
You might be asking “What is SQL Server Notifications Services?”. Well, that is a good question and one that will I hope be asked by lots more people soon. This article is meant to answer that question, and to provide you with enough information to peak your interest in one of Microsoft’s newest services designed to run under SQL Server 2000, and to take advantage of the .NET initiative....
|
|
|
|
Total Hits: 151 | Today: 0
|
Author: Dima Sonkin, Thierry D’Hers, Kami LeMonds, Michael
|
Rating:
|
|
The Microsoft SQL Server Team had two main goals for the design of the new SQL Server 2005 management tools. The first goal was to provide a consistent management experience for all components of SQL Server. The second goal was to provide an innovative tool to make database professionals more productive at querying, managing, and administrating SQL Server. To achieve these goals, the team had to choose an environment that was easily extensible, user-friendly, and familiar to the database profess...
|
|
|
|
Total Hits: 118 | Today: 0
|
Author: Jasper Smith
|
Rating:
|
|
In this series of articles, I'll demonstrate how to use SMO (SQL Management Objects) to do a variety of common DBA tasks including Backups, Restores,Index Maintenance, Integrity checks and more. These are some of the operations available in the SMO database maintenance utility available on this site - ExpressMaint. In this article we will concentrate on how to build a SMO application and how to connect to a SQL Server and retrieve some server properties....
|
|
|
|
Total Hits: 23 | Today: 0
|
Author: Armando Prato
|
Rating:
|
|
I am trying to leverage the new SQL Server 2005 DMVs for performance analysis. While they're very useful, it would be nice to be able to see graphical representations of the data collected by the DMVs. Is there a graphical utility within SQL Server I can use as well? In SQL Server 2005 Service Pack 2, Microsoft introduced a new feature that affords DBAs the ability to run Custom Reports. This feature allows DBAs to run their own Reporting Services custom reports from within the SQL Server Manage...
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Sitaram Raju, Sachin Sinha
|
Rating:
|
|
SQL Server 2005 Compact Edition (SSCE) provides a powerful yet lightweight data storage engine for building a variety of application types. This paper introduces data storage concerns for client applications and small-scale server applications. It discusses the feature set of SSCE and how that feature set addresses data storage concerns. It covers different application architectures where SSCE might be a good fit, highlighting the attributes of the application types and how SSCE can meet the req...
|
|
|
|
Total Hits: 39 | Today: 0
|
Author: Robert Walters
|
Rating:
|
|
As today's computer applications continue to grow in complexity and in the amount of information they must store and manage, a stable and efficient database engine is a key ingredient for the overall success of any project. Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a lightweight and "free" database engine. It replaces Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). SQL Server Express is similar to SQL Server 2005 Workgroup Edition, but with some limitations on the m...
|
|
|
|
Total Hits: 35 | Today: 0
|
Author: Dan Burman
|
Rating:
|
|
Welcome to the first installment in a series of white papers in which I'll be examining many of the new features that are offered to developers within Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition Technical Preview. Throughout the series, I will take you through a step-by-step process where I will be constructing a sample application of a student activity registration. This application will allow students to sign up for activities and view a calendar of activities...
|
|
|
|
Total Hits: 40 | Today: 0
|
Author: Dan Burman
|
Rating:
|
|
The advent of SQL Server 2005 Express Edition provides a big boost to data integration in ASP.NET 2.0. SQL Server Express is a powerful, file-based, personal database that is built on the SQL Server 2005 code base. The intended use of SQL Server Express is for basic development, so it won't handle the traffic required of a production server. The advantage of using SQL Server Express is that it comes packaged with Visual Web Developer 2005 Express Edition and integrates seamlessly into the develo...
|
|
|
|
Total Hits: 11 | Today: 0
|
Author: Dan Burman
|
Rating:
|
|
This is the third installment in a multi-part series of building a simple, data-driven, student activity registration Web site using Visual Web Developer (under Visual Studio 2005) and SQL Server Express. We are constructing an application that will allow students to sign up for activities and view a calendar of activities in which they are enrolled. Administrators will be able to add new activities to the system and view the enrollment for each existing activity. There will also be a public are...
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Jackie Goldstein
|
Rating:
|
|
With the availability of ever more powerful programming tools and environments such as Visual Basic and Visual Studio.NET, as well as the availability of powerful database engines such as the free SQL Server 2005 Express Edition, more and more people find themselves having to learn the basics of SQL queries and statements. Sometimes they are professional developers who are experienced in other types of programming, and sometimes they are individuals whose expertise lies in other areas, but they ...
|
|
|
|
Total Hits: 228 | Today: 0
|
Author: Joe Chang
|
Rating:
|
|
A proper, technically correct system and storage sizing assessment of a SQL Server system and storage configuration needs to consider a broad range of CPU, memory and IO usage analysis. Fortunately, a reasonable set of system configurations can be arrived at without heavy technical analysis, driven mostly by the cost structure of the Windows operating system, SQL Server licensing, and the server platform. In cases where a large system with more than four processor sockets is required, it still d...
|
|
|
|
Total Hits: 38 | Today: 0
|
Author: Richard Tkachuk
|
Rating:
|
|
This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.Analysis Services offers a powerful server-based calculation engine. It's a spreadsheet on steroids that can do virtually anything. This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems.
This document assumes some familiarity with...
|
|
|
|
Total Hits: 46 | Today: 0
|
Author: Liu Tang and Paul Bradley
|
Rating:
|
|
This article discusses:Business Intelligence Development Studio
Creating and processing mining models programmatically with AMO
Using AMO to manage Analysis Services objects
emember the day you got your first big box of crayons—that colossal, multitiered package with an extraordinary number of colors? You needed every color to express your ideas more fully, down to every nuanced detail. For client-side developers, Analysis Management Objects (AMO) for SQL Server™ 2005 is a lot like that...
|
|
|
|
Total Hits: 39 | Today: 0
|
Author: Kimberly L. Tripp
|
Rating:
|
|
Table-based partitioning features in SQL Server 2005 provide flexibility and performance to simplify the creation and maintenance of partitioned tables. Trace the progression of capabilities from logically and manually partitioning tables to the latest partitioning features, and find out why, when, and how to design, implement, and maintain partitioned tables using SQL Server 2005...
|
|
|
|
Total Hits: 48 | Today: 0
|
Author: Richard Waymire
|
Rating:
|
|
In Project REAL we are using large volumes of real data and scenarios from real companies to implement business intelligence systems using early releases of Microsoft SQL Server 2005. In the process, best practices are being developed and potential problems uncovered. This article reports some of the lessons learned while working on the data extraction, transformation, and loading (ETL) portion of the first phase of Project REAL....
|
|
|
|
Total Hits: 53 | Today: 0
|
Author: Debra Dove
|
Rating:
|
|
Compare feature sets for the two Microsoft SQL Server 2005 Mobile Edition 3.0 (SQL Server Mobile) connectivity solutions, merge replication and remote data access (RDA), and understand which connectivity solution might be more beneficial for your project....
|
|
|
|
Total Hits: 111 | Today: 0
|
Author: Extreme Experts
|
Rating:
|
|
There are loads of features we can explore in SQL Server 2005. Here is one such feature that I personally would call it as the DBA's requirement. Here in this article we will take a snapshot to what DDL triggers are and how it can be extended to our needs. DDL Triggers are new in SQL Server 2005. Fundamentally SQL Server 2005 allows us to existing set of available triggers to the next level. In these trigger we can execute a trigger for all available DDL statements in the system....
|
|
|
|
|
|
