|
|
|
|
|
Total Hits: 315 | Today: 0
|
Author: Michael Benkovich
|
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....
|
|
|
|
Total Hits: 737 | Today: 2
|
|
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....
|
|
|
|
Total Hits: 182 | Today: 0
|
Author: Microsoft
|
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....
|
|
|
|
Total Hits: 281 | Today: 1
|
|
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...
|
|
|
|
Total Hits: 341 | Today: 0
|
Author: Michael Benkovich
|
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....
|
|
|
|
Total Hits: 322 | Today: 0
|
Author: Kimberly L. Tripp
|
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....
|
|
|
|
Total Hits: 250 | Today: 0
|
Author: Kimberly L. Tripp
|
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...
|
|
|
|
Total Hits: 284 | Today: 0
|
Author: Kimberly L. Tripp
|
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...
|
|
|
|
Total Hits: 429 | Today: 0
|
Author: Joe Stagner
|
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 ...
|
|
|
|
Total Hits: 764 | Today: 0
|
|
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...
|
|
|
|
Total Hits: 712 | Today: 0
|
|
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...
|
|
|
|
Total Hits: 731 | Today: 0
|
|
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....
|
|
|
|
Total Hits: 508 | Today: 1
|
|
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 ...
|
|
|
|
Total Hits: 328 | Today: 0
|
Author: Kimberly L. Tripp
|
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...
|
|
|
|
Total Hits: 274 | Today: 0
|
Author: Joe Stagner
|
Rating:
|
|

After analyzing the infamous SQL Injection attack in the first webcast, Joe Stagner discusses secure database design in this second webcast of the “Defending the Database” series. This webcast answers several common questions that developers ask about databases and security by providing solutions that work for different situations. You will learn about secure connections, .exp files, managed stored procedures, alerts, and monitors. In addition, this webcast compares SQL Authentication with Windo...
|
|
|
|
Total Hits: 588 | Today: 0
|
|
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, ...
|
|
|
|
Total Hits: 8 | Today: 0
|
Author: Jeffrey Hasan and Kenneth Tu
|
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...
|
|
|
|
|
|