Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > SQL Server > Server Management


Search:
What's New - What's Hot
Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: Neeraj Nagpal      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the first article in the series, I explained the setup of a report that ensures that backups are happening as per the backup policy. In this article, I will explain how to monitor SQL Server errorlog, leveraging the capabilities of DTS. Just in case you have not read the first article, in this series, I am covering how to monitor three elements of Microsoft SQL Server:
1. Backup SLA (Service Level Agreement) Report — to find any database that has not been backed up in the last 24 hours....

Exporting SSIS Package Using SQL Server Management Studio  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Ashish Kumar Mehta      Rating:  
Read Reviews | Write Review |  Your Rating: 

Database Administrators sometimes need to export SQL Server Integration Services Package (SSIS) from one instance of SQL Server to another SQL Server Instance or a File system or a SSIS Package Store. In this article you will see the steps which you need to follow in order to export a SQL Server Integration Services Package that is stored as a File System in an instance of SQL Server to another SQL Server or a File system or a SSIS Package store using SQL Server Management Studio (SSMS)....

Publish SQL Server 2005 As Webservice     
Total Hits: 64  |  Today: 0Author: rilov      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, I will explain how we can publish a SQL Server 2005 stored procedure as a web service and access this web service from a Microsoft VB.NET Windows application. Microsoft started addressing the need of XML support for SQL Server from the release of SQL Server 2000 version. The initial version of SQL Server 2000 shipped with many XML features. Later on, Microsoft released SQLXML 3.0 which provided the facility to publish TSQL batch statement, SQL stored procedures and SQL functions...

Launching a default Project in SQL Server Management Studio     
Total Hits: 185  |  Today: 0Author: Tim Ford      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have a common set of scripts I rely on whenever I create a new SQL Server 2005 instance. I understand that I can group these scripts and connections into a SQL Server Management Studio Project, but is there an easy method for opening this Project by default when I launch Management Studio? The short answer to your question is "No". However, there are some different methods that have the net effect of accomplishing what you wish to do: open this project by default, when you choose to. The fi...

SQL Server Analysis Services - Dimensional Modeling Concepts     
Total Hits: 59  |  Today: 0Author: Nidal Arabi      Rating:  
Read Reviews | Write Review |  Your Rating: 

Building relational databases has evolved. However, building OLAP databases requires different skills. In this article, Nidal explains some building blocks of these kind of databases. He examines the concept behind Dimensions and Measures in detail with relevant screenshots. After introducing the UDM, we need to go more into the details of the Dimensional Modeling in order to understand how to build our UDM. We are going to talk about two main concepts: Dimensions and Measures....

Connectivity and SQL Server 2005 Integration Services     
Total Hits: 47  |  Today: 0Author: Bob Beauchemin      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 Integration Services (SSIS) exists to implement enterprise-level extract, transformation, and loading functionality (ETL) for SQL Server and heterogeneous data sources. As part of the SQL Server 2005 product, its main focus is to provide seamless integration between SQL Server–based online transaction processing (OLTP) systems and data warehouses, SQL Server Analysis Services cubes, and data-mining models. The rich variety of transformation and analysis functionality an...

SQL Server Management Objects     
Total Hits: 73  |  Today: 0Author: John Papa      Rating:  
Read Reviews | Write Review |  Your Rating: 

Not only must database developers query and manipulate data, but they must also perform administrative tasks on a regular basis. SQL Server™ Management Objects (SMO) offer developers a robust toolset for operations such as backing up and restoring databases, and issuing Data Definition Language (DDL) commands. Using SQL SMO you can also connect to SQL Server, iterate through a collection of database objects and perform a variety of tasks against them. In this column, I discuss how SMO can be use...

SQL Server 2005 Full-Text Search: Internals and Enhancements     
Total Hits: 142  |  Today: 0Author: Andrew Cencini      Rating:  
Read Reviews | Write Review |  Your Rating: 

The full-text search feature of Microsoft SQL Server 2005 delivers enterprise search functionality integrated into the database. Significant enhancements in the areas of performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size.

This paper is for database administrators and developers alike. An introduction to full-text search and its architecture is followed by details about important enhancements and new features....

Detailed locking view: sp_lock2     
Total Hits: 99  |  Today: 0Author: Alexander Chigrik      Rating:  
Read Reviews | Write Review |  Your Rating: 

As a SQL Server DBA, I often need a reference to information about locks. Microsoft recommends using the sp_lock system stored procedure to report locks information. The sp_lock stored procedure returns the information about SQL Server process ID, which lock the data, about locked database ID, about locked object ID, about locked index ID and about type of locking (type, resource, mode and status columns)....

Workaround for compiling SMO applications with SQL 2005 Express Edition     
Total Hits: 106  |  Today: 0Author: Jasper Smith      Rating:  
Read Reviews | Write Review |  Your Rating: 

There is an issue with the setup of SQL Server 2005 Express Edition with regard to the SMO assemblies required to compile SMO applications. Note that this does not affect the ability to run SMO applications, merely to compile them. The issue is that the required SMO assemblies are only installed in the GAC and are not available to be referenced when compiling an SMO application. Whilst I'm sure there has to be an easier way, the method below worked fine for me and it's a one time operation....

Retrieving SQL Server Column Properties with COLUMNPROPERTY     
Total Hits: 251  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server stores a lot of data about your database objects in various places and in various formats. When pulling data about table columns this data can be pulled directly from the syscolumns table. Some of this information is useful as it is, but some of the data needs to be interpreted to understand. In addition to pulling data directly from syscolumns you can also use the information schema view. If you query from INFORMATION_SCHEMA.COLUMNS you get a lot of data in a useful format, but th...

SQL SERVER Memory Management  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Manikavelu Velayutham      Rating:  
Read Reviews | Write Review |  Your Rating: 

In 32 Bit OS, Sql Server divides the memory into two parts, one will have the data pages and the other one will have the rest like indexes, compiled queries, results of joins and so on.
32 bit are enough to handle 4 GB at a time. Default configuration will be like, 2GB for operating system and 2 GB for application....

Use Role-Based Security in Your Middle Tier .NET Apps with Authorization Manager  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Keith Brown      Rating:  
Read Reviews | Write Review |  Your Rating: 

Authorization Manager in Windows Server 2003 represents a significant improvement in the administration of role-based security, making it more scalable, flexible, and easier to implement. Using Authorization Manager, you can define roles and the tasks those roles can perform. You can nest roles to inherit characteristics from other roles, and you can define application groups. In addition, Authorization Manager lets you use scripts to modify permissions dynamically, and it allows you to wrap you...

Create Your Own SQL Server Job Management System  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Robbe Morris      Rating:  
Read Reviews | Write Review |  Your Rating: 

Having had the honor of working for quite a few companies that did not have the resources to buy any of the nice SQL Server toys that exist out there, or were willing to put an email client on the servers, I have found myself spending a good deal of time each morning checking the status of the numerous jobs running on my servers. Not a hard thing to accomplish, but very time consuming when you are talking about dozens of servers with hundreds of jobs. Maybe it was just me, but no matter how muc...

How to Create a Comma Separated Delimited Text File Using SQL Server 2008  Version: 0.00     Price: $0.00  
Total Hits: 6  |  Today: 0Author: Ashish Kumar Mehta      Rating:  
Read Reviews | Write Review |  Your Rating: 

Database Administrators and SSIS Developers have always come across scenarios where you need to create a comma separated delimited text file for very large tables in SQL Server 2008. Once the delimited text file is generated the files can be compressed and they can be easily FTP to client locations. This is one among the fastest and easiest way to distribute the data. In this article you will see the steps which you need to follow to create a SQL Server Integration Services Package which can be ...

SQL Server Integration Services an Introduction - Part 3  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: Arshad Ali      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is part 3 of a 4 part series that introduces SQL Server Integration Services (SSIS). This article describes how to use the Import and Export Wizard....

New Features in SQL Server 2008 Management Studio – Part 1  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Ashish Kumar Mehta      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server Management Studio (SSMS) is a graphical tool which can be used by Database Developers and Database Administrators to perform development and administrative tasks on SQL Server 2008. SQL Server Management Studio (SSMS) tool was first introduced by Microsoft in SQL Server 2005. SSMS is a replacement for Query Analyzer, Analysis Manager & Enterprise Manager tools which were available in SQL Server 2000. Microsoft consolidated all those tools into a single tool thereby providing an integr...

Enterprise Data Management with SQL     
Total Hits: 76  |  Today: 0Author: Addison-Wesley Professional Books      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the beta history of the SQL Server 2005 release, significant emphasis has been put on the new features for developing applications. Let's just say that Microsoft loves developers. But what happened to the features for those who get paged in the middle of the night when mission-critical systems hang? This chapter looks at features for the unsung heroes of corporate IT—the database administrator (DBA). For the DBA, SQL Server 2005 will change everything about the way administration is accomplis...

Creating Native Web Services in SQL Server     
Total Hits: 48  |  Today: 0Author: Bipin Joshi      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you are a .NET developer, by this time you probably worked with ASP.NET Web Services. However, ASP.NET is not the only framework that allows you to develop web services. SQL Server 2005 and 2008, for example, allow you to create web services. SQL Server native web services can come in handy when you want to expose your application data over the web irrespective of the type of client applications that consume it. This way, you need not develop another layer of ASP.NET web services. This not on...

SQL Server Analysis Services Concepts     
Total Hits: 65  |  Today: 0Author: Nidal Arabi      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this series of articles, Nidal explains how Microsoft has done a great job in the world of business intelligence using Microsoft SQL Server Analysis Services (SSAS). The author deeply examines the concept of OLAP Services and Unified Dimensional Model. He also points out where SSAS fits in SQL Server and also the requirements to work with it in a step-by-step manner....


1  2  3  4  5  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net