Search - Articles - Dev Forums - Favorites - Member Login  
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Friday, September 03, 2010

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

Build the right apps the right way with powerful development tools.
Visual Studio 2010. Learn more...

Home > Search > Knowledge Base > SQL Server
Search:
What's New - What's Hot
Listings for Administration Administration (6)
Listings for Articles Articles (54)
More Categories for Bugs and Fixes Bugs and Fixes (111)
Listings for Data Provider Data Provider (7)
Listings for Encryption Encryption (1)
Listings for Errors Errors (27)
Listings for Import & Export Import & Export (3)
Listings for Information Information (45)
Listings for Installation Installation (3)
Listings for Security & Login Security & Login (7)
Listings for SQL Mail SQL Mail (3)
Listings for SQL Server 2005 SQL Server 2005 (8)
Listings for SQLXML SQLXML (5)
Listings for Stored Procedure Stored Procedure (9)
Listings for Virtual Instance Virtual Instance (0)
Listings for Windows XP Windows XP (2)


How to Execute SSIS Packages in C# ASP.NET - Part I    Version: 0.00       Price: $0.00   
Total Hits: 20  |  Today: 0 Author: Vuyiswamb       Rating:  
Read Reviews | Write Review |   Your Rating: 

In this s Article I am going to explain the technology that came with Sql 2005. This is SSIS which stands for Sql Server Integrated Services. Recently I was working on a project for a client with large sum of Data and there was a need to process the data on a certain time frame. There were lot of technologies available at my Disposal, but this kind of Functionality needed to be streamlined and optimised. Of all the Technologies, i have chosen SSIS. In this Article I will demonstrate on how to ex...

How to: Execute a Stored Procedure that Returns Rows    Version: 0.00       Price: $0.00   
Total Hits: 48  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |   Your Rating: 

To execute a stored procedure that returns row, you can run a TableAdapter query that is configured to run a stored procedure (for example, CustomersTableAdapter.Fill(CustomersDataTable)).

If your application does not use TableAdapters, call the ExecuteReader method on a command object, setting its CommandType property to StoredProcedure. ("Command object" refers to the specific command for the .NET Framework Data Provider that your application is using. For example, if your application i...

How to find a SQL Server DBA Job        
Total Hits: 284  |  Today: 0 Author: Edgewood Solutions Engineers       Rating:  
Read Reviews | Write Review |   Your Rating: 

I am new to the SQL Server platform and want to break into the field. I have been doing IT work for a while now and I am looking to focus my career on SQL Server. Do you have any suggestions? Where should I start? What should I be prepared for during the interview process? Congrats and welcome to the field. It will probably be a long road, but one of the first decisions that needs to be made is exactly what you want to do. You could work as a DBA, Developer, BI developer, BI Admin or a com...

How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005        
Total Hits: 340  |  Today: 0 Author: Ray Barley       Rating:  
Read Reviews | Write Review |   Your Rating: 

We have chosen MOLAP storage in order to maximize the query performance of our cubes. Since we have a number of cubes we are now focused on coming up with a strategy for keeping the cubes up to date as the data in our warehouse changes frequently. Can you give us the details on how we go about implementing the Proactive Caching feature in SQL Server Analysis Services 2005?...

How To Use the Analysis Services Processing Task in SSIS 2005        
Total Hits: 311  |  Today: 1 Author: Ray Barley       Rating:  
Read Reviews | Write Review |   Your Rating: 

We are looking to automate the processing of our SQL Server Analysis Services dimensions and cubes. We'd like to add this processing to our existing SQL Server Integration Services (SSIS) packages which periodically update our data warehouse from our OLTP systems. Can you give us the details on how the Analysis Services Processing Task can be used in an SSIS package?...

How To Use the Analysis Services Execute DDL Task in SSIS 2005        
Total Hits: 307  |  Today: 0 Author: Ray Barley       Rating:  
Read Reviews | Write Review |   Your Rating: 

We are looking to automate some tasks to be performed on our SQL Server Analysis Services Servers. Can you give us the details on how the Analysis Services Execute DDL Task can be used in a SQL Server Integration Services (SSIS) package? The Analysis Services Execute DDL Task is a very useful one, allowing you to do just about anything with a SQL Server Analysis Services instance. For example you could backup a database, process a cube, create a partition, merge partitions, etc. You specify c...

How To Define Measure Group Partitions in SQL Server Analysis Services (SSAS) 2005        
Total Hits: 352  |  Today: 0 Author: Ray Barley       Rating:  
Read Reviews | Write Review |   Your Rating: 

We are anticipating building some very large cubes and would like to get a handle on how to partition our measure groups to provide flexibility in processing and administering our cubes. Can you guide us through the steps to define multiple partitions for a measure group and provide some explanations? The default behavior in SSAS is to create a single partition for a measure group. Creating multiple partitions for a measure group is definitely a best practice when you have very large fact tab...

How to setup SQL Server alerts and email operator notifications        
Total Hits: 375  |  Today: 0 Author: David Bird       Rating:  
Read Reviews | Write Review |   Your Rating: 

Setting up an alert to e-mail an operator with a message is a multiple step process. You can setup database mail, define an operator and an alert, but still no e-mail is being sent. So how do you send an alert to an operator? First setup database mail with a profile named SQLAlerts. The profile can be named anything but in these instructions, the profile name SQLAlerts is referenced. If you wish to use a different profile name just substitute accordingly. For procedures in setting up database ma...

Using DBCC UPDATEUSAGE to get accurate space allocation information in SQL Server        
Total Hits: 326  |  Today: 0 Author: Armando Prato       Rating:  
Read Reviews | Write Review |   Your Rating: 

Microsoft does not guarantee that table and database space allocation information will be maintained accurately. In a high transaction OLTP database or after a large bulk copy of data has been performed, this can lead to inaccurate database space reporting when using the system stored procedure sp_spaceused....

How to setup linked servers for SQL Server and Oracle 64 bit client        
Total Hits: 338  |  Today: 0 Author: Tim Ford       Rating:  
Read Reviews | Write Review |   Your Rating: 

We have two SQL 2005 64-bit clusters in our organization: a four-node production cluster and a two-node dev/test cluster. We recently migrated a database from SQL 2000 that relied on an Oracle linked server for some of it's computations. No big deal, right? Install the Oracle client software and create the linked server just like in SQL 2000 right? Be sure to repeat the process on both nodes for failover-sake, right? Wrong. In the case of 64-bit SQL instances we have a few extra steps we ...

Finding a SQL Server process percentage complete with dynamic management views        
Total Hits: 314  |  Today: 0 Author: Edgewood Solutions Engineers       Rating:  
Read Reviews | Write Review |   Your Rating: 

Some tasks that are run in SQL Sever take a long time to run and it is sometimes difficult to tell whether these tasks are progressing or not. One common way of determining that status is to look at the data returned from sp_who2 or sp_lock to ensure that things are still working and the process is not hung. With SQL Server 2005 several dynamic management views have been added, so let's take a look at some of these and how they can assist....

How to Find Keywords in SQL Server Stored Procs and Functions        
Total Hits: 293  |  Today: 0 Author: Tim Ford       Rating:  
Read Reviews | Write Review |   Your Rating: 

How many times have you had to troubleshoot or make changes to an existing database that is not documented properly or completely? Even need to look for a specific stored procedure that references a specific table or process? If you have intimate knowledge of the database then this may not be much of an issue for you. What happens if this database is from an external developer, a turn-key solution provider, or developed by another individual within your company? If you utilize the INFORMATIO...


DevASP.Net - Disclaimer - Privacy
© 2002-2010 DevASP.net