|Total Hits: 533 | Today: 0||Author: Andy Novick|| 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....
|Total Hits: 286 | Today: 0||Author: Microsoft Corporation|| 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...
|Total Hits: 526 | 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: 747 | 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: 812 | 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: 731 | 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: 1407 | 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: 1283 | 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: 1305 | 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: 1337 | Today: 0|| 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: 1122 | Today: 0|| 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: 526 | Today: 0||Author: Edgewood Solutions Engineers|| 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 ...
|Total Hits: 275 | Today: 0||Author: Dino Esposito|| 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...
|Total Hits: 218 | 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...
|Total Hits: 659 | Today: 0|| 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: 764 | 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: 769 | 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: 790 | 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: 1062 | 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: 1274 | 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, ...