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 > Support WebCasts > SQL Server 2000


Search:
What's New - What's Hot
Getting a SQL Server RowCount Without doing a Table Scan     
Total Hits: 538  |  Today: 0Author: Andy Novick      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sometimes there is a need to get record counts from every table in your database. One way of doing this is to do a SELECT count(*) on all of your tables, but this could create a lot of overhead especially for large databases and large tables. If you don't require an exact answer, it isn't necessary to use a SELECT count(*) query on the rows in a table to get the row count....

Counting Your Rows Before They Hatch     
Total Hits: 291  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

I gulped and left the room knowing that we were going to have to do some damage control when I got back. When I talked with the speaker, a well-known consultant in his own right, he said that this approach was a well-accepted way to deal with the problem of not knowing how many rows were going to result from a query. I disagreed and we agreed to disagree and leave it at that. However, so that you don't make the same mistake, let's take a closer look at the problem and how various approaches deal...

Integrating Microsoft .NET Development with Microsoft SQL Server 2000     
Total Hits: 530  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

During this WebCast, we will explore the ways to integrate assemblies and Web services written with the .NET Framework, for both tightly coupled and loosely coupled systems....

MSDN Webcast: SQL Masterclass: The New XML Data Type (Level 300)     
Total Hits: 751  |  Today: 0Author: Michael Benkovich      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this webcast, we show you how to use the new XML data type to simplify development and application processes and scalability. Learn how the XML data type represents a giant leap toward providing an open environment for extending the scalability and performance of your applications and system architectures....

MSDN Webcast: A Primer to Proper SQL Server Development (Part 10 of 10): Most Common Roadblocks to Scalability and Reliability (Level 200)     
Total Hits: 816  |  Today: 0Author: Kimberly L. Tripp      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is the final webcast in our ten-part series on proper Microsoft SQL Server 2005 development techniques. We conclude with a look at the ten most common roadblocks to scalability and reliability, and how to overcome them....

MSDN Webcast: A Primer to Proper SQL Server Development (Part 7 of 10): Understanding Plan Caching and Optimizing Procedure Performance (Level 200)     
Total Hits: 734  |  Today: 0Author: Kimberly L. Tripp      Rating:  
Read Reviews | Write Review |  Your Rating: 

This seventh webcast in our series on Microsoft SQL Server development focuses on ways you can optimize your stored procedures and how to make the most of the resources you have available. What happens when you execute a statement? If a plan is used, how long does it stay in cache? Can you control caching. or the length of time a plan is kept in cache, or even what plan is placed in cache? We compare and contrast dynamic string execution, sp_executesql, and stored procedures, and examine how eac...

Support WebCast: How to Effectively Use SQL Server Profiler     
Total Hits: 1417  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

May 18, 2000
This session will talk about what the Profiler is, and then tell you when, why, and how you should use. We will go into the details of various Profiler components and discuss their applicability to specific troubleshooting scenarios (with examples). We will also discuss the underlying extended stored procedures and how to use them outside of the GUI. In addition, we will look into the way Profiler works with other tools such as the Index Tuning Wizard. Finally, we will dis...

Support WebCast: Programming ADO SQLXML to Execute SQLXML Queries     
Total Hits: 1287  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

June 6, 2002

The objective of this session is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. You will learn about the underlying architecture of using ADO to execute SQLXML queries. Code walkthroughs will be presented to illustrate how to execute different types of SQLXML queries (FOR XML AUTO, Templates, Updategrams, XPath queries against annotated map...

Support WebCast: Microsoft SQL Server 2000 Analysis Services: How to Connect to Analysis Services over the Internet     
Total Hits: 1315  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

December 4, 2001

In this session, we will discuss how to configure and troubleshoot an HTTP connection to Analysis Services over both the Internet and an intranet. We will show you how to configure Microsoft Internet Information Services (IIS), and discuss the different security options for IIS in regard to Analysis Services. We will also talk about the client connection string and performance issues that may arise while using the HTTP connection....

Support WebCast: SQL Server 2000 Database Recovery: Backup and Restore     
Total Hits: 1345  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

December 5, 2000
In this session, we will discuss the new SQL Server recovery models, as well as the enhancements made to backup and restore on the newly redesigned SQL Server 2000. We will also talk about the enhancements and challenges you may encounter while deploying log shipping on SQL Server Enterprise Edition. We will also talk about the directions you can use to deal with, and be prepared for, disaster recovery and compare those with previous versions....

Support WebCast: Integrating Microsoft .NET Development with Microsoft SQL Server 2000     
Total Hits: 1132  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Thursday, July 18, 2002: 10:00 A.M. Pacific time (Greenwich mean time - 7 hours)

During this WebCast, we will explore the ways to integrate assemblies and Web services written with the .NET Framework, for both tightly coupled and loosely coupled systems. We will first discuss the loosely coupled systems that implement URL queries, templates, and ADO.NET classes to send and receive XML documents. We will then explore the SQLXML 3.0 interface used for automatic exposure to SOAP, and ...

Suspect SQL Server 2000 Database - Part 2     
Total Hits: 530  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

In your recent tip (Suspect SQL Server 2000 Database) you outlined a suspect database scenario. I took a look at the script and tried to run it in my environment. Unfortunately, this did not resolve my issue. Are you aware of other causes of SQL Server 2000 suspect databases? We have been working through a SOX audit and have been changing permissions at the file system level for our SQL Server. Could this type of change cause a suspect database? The timing of the permission change and the ...

Talk to Your Data     
Total Hits: 279  |  Today: 0Author: Dino Esposito      Rating:  
Read Reviews | Write Review |  Your Rating: 

Unless you've spent the best years of your life formulating SQL queries on such things as how to ask for a cup of coffee, chances are that trying to analyze a sophisticated SQL string leaves you a bit baffled. On the other hand, SQL was not intended to be the language for casual conversation. SQL was designed to make the conversation between a program and a database management system (DBMS) easier and more effective. Unfortunately, as developers, we are just the ones deputed to govern such a dia...

Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP     
Total Hits: 223  |  Today: 0Author: Jeffrey Hasan and Kenneth Tu      Rating:  
Read Reviews | Write Review |  Your Rating: 

Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting...

.NET Development with Microsoft SQL Server 2000     
Total Hits: 663  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

During this WebCast, we will explore the ways to integrate assemblies and Web services written with the .NET Framework, for both tightly coupled and loosely coupled systems.We will first discuss the loosely coupled systems that implement URL queries, templates, and ADO.NET classes to send and receive XML documents. We will then explore the SQLXML 3.0 interface used for automatic exposure to SOAP, and how to create SOAP request. We will then look at different methods and cases of invoking managed...

MSDN Webcast: SQL Server MasterClass: User-Defined Types (Level 200)     
Total Hits: 768  |  Today: 0Author: Michael Benkovich      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server provides the database administrator and the developer with a lot of functionality out of the box. In SQL Server 2005, there is a new feature that helps you to define new data types for your applications. Join this webcast to find out what is required to create and use the new user-defined types. Learn how these new types can help make you a more effective developer....

MSDN Webcast: A Primer to Proper SQL Server Development (Part 9 of 10): Profiling for Better Performance (Level 200)     
Total Hits: 773  |  Today: 0Author: Kimberly L. Tripp      Rating:  
Read Reviews | Write Review |  Your Rating: 

Now that your database is in production, is it actually doing what you thought it would? This webcast, part nine in our series on proper Microsoft SQL Server 2005 development, focuses on the Microsoft SQL Server 2005 Profiler and its capabilities. The SQL Server Profiler allows you to audit and analyze virtually all of the events that occur during the period of time you specify. It records all activity in SQL Server, and can send its output to a file, a table, or to the display window. We examin...

MSDN Webcast: A Primer to Proper SQL Server Development (Part 8 of 10): Data Loading and Aging Strategies (Level 200)     
Total Hits: 794  |  Today: 0Author: Kimberly L. Tripp      Rating:  
Read Reviews | Write Review |  Your Rating: 

Loading large amounts of data into your database can take time and may cause fragmentation and blocking issues. How can you load data quickly with minimal impact on your production data? Part eight in our series on Microsoft SQL Server 2005 development shows you how to use batch strategies to make data loading and aging more efficient. Learn about the Bulk Copy Program, the Bulk Insert task, the effects of recovery models and an introduction to Microsoft SQL Integration Services. Part nine offer...

MSDN Webcast: Security Best Practices: Hardening Your SQL Server (Level 200)     
Total Hits: 1066  |  Today: 0Author: Joe Stagner      Rating:  
Read Reviews | Write Review |  Your Rating: 

Writing secure code is only one layer of security for your data. We need to understand how hackers approach our data and how to build a secure database server on which we can predicate secure applications. This webcast helps developers and system administrators "harden" their Microsoft SQL Servers. Hardening involves removing any services that don't contribute to the function of the server, reducing the number of possible vulnerabilities available to the would-be hacker. Join us to find out the ...

Support WebCast: Microsoft SQL Server 2000 Transactional Replication: Queued Updating Subscription     
Total Hits: 1282  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Tuesday, June 11, 2002: 10:00 A.M. Pacific time (Greenwich mean time - 7 hours)

This WebCast will introduce the new subscription option (queued updating) in Microsoft SQL Server 2000 transactional replication. It will discuss the benefits of using this option, requirements and special considerations to be aware of before implementing it, and show its workflow. The WebCast will also describe the differences between Transactional Replication with queued updating, immediate updating, ...



Disclaimer - Privacy
© 2002-2017 DevASP.net