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 2005


Search:
What's New - What's Hot
Insert data from Excel to SQL Server 2005 by using copy and paste commands     
Total Hits: 264  |  Today: 0Author: Kun Lee      Rating:  
Read Reviews | Write Review |  Your Rating: 

Loading data from SQL Server to Excel is a common practice in many automated and ad-hoc processes completed by DBAs on a daily basis. Traditionally loading data from Excel to SQL Server has been completed by DTS, SSIS, BCP, OPENROWSET, Import\Export Wizard, etc. Unfortunately, for a simple ad-hoc process this can be a time consuming task with a fair amount of clicks and\or coding. With all of the new features with in SQL Server 2005, are any new tricks available to streamline the Excel to SQL...

TechNet Webcast: SQL Server 2005 for the IT Professional (Part 8 of 11): Implementing Database Mirroring in SQL Server 2005 (Part 1 of 2) (Level 200)     
Total Hits: 208  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

Database mirroring was released for testing when Microsoft SQL Server 2005 shipped as a product. As we approach the first service pack, get prepared for the release of database mirroring for general production use and understand the barriers of what database mirroring will protect against. Attend this first part in the eighth webcast of the SQL Server 2005 for the IT Professional series to obtain better insight for when database mirroring should be implemented as well as what to expect moving fo...

MSDN Webcast: SQL Server 2005 Essentials: SqlClient and the New Data Types (Part 12 of 14) (Level 200)     
Total Hits: 218  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

With the advent of new features in Microsoft SQL Server 2005 due to the inclusion of the common language runtime (CLR) and improved XML support, the client application programming interfaces (APIs) must be enhanced to make use of the new features. This twelfth webcast of a 14-part series on SQL Server 2005 focuses on SqlClient provider, ActiveX Data Objects (ADO), and support of the new data types. We explore the enhancements available both in ADO "classic" and ADO.NET....

MSDN Webcast: Creating Analytical Multidimensional Expression (MDX) Queries (Level 200)     
Total Hits: 241  |  Today: 0Author: Mike Benkovich      Rating:  
Read Reviews | Write Review |  Your Rating: 

General-purpose tools can create standard Multidimensional Expressions (MDX) queries. In order to develop a custom application that answers serious business questions, you need to be able to create effective, analytical MDX queries. In this webcast, learn strategies for building powerful queries that not only display data, but also reveal the meaning of query results. Lab exercises include creating queries to calculate changes and exceptions, and parameterizing the queries so that you can includ...

MSDN Webcast: End-to-End SQL Server 2005 Reporting Services (Part 2 of 6) (Level 200)     
Total Hits: 207  |  Today: 0Author: Susan Wisowaty      Rating:  
Read Reviews | Write Review |  Your Rating: 

This second webcast in our series on Microsoft SQL Server 2005 Reporting Services covers the fundamentals of report design, and shows how to use simple design tools. We explore the Report Wizard and the building blocks of report design, report items and layout. The discussion covers grouping, lists, matrix reports, and defining drill-through reports. We also explain how to write custom code to extend formatting and apply business logic. The session concludes with a look at how to define queries,...

MSDN Webcast: SQL Server 2005 Essentials: SQL/CLR (Part 1 of 14) (Level 200)     
Total Hits: 217  |  Today: 0Author: Steve Muise      Rating:  
Read Reviews | Write Review |  Your Rating: 

As the first of a 14-part series, this webcast covers what it means to be a Microsoft .NET runtime host. Topics include how Microsoft SQL Server 2005 works with the .NET 2.0 application programming interfaces (APIs) to make loading and running code safe, reliable, and scalable. We conclude by showing you how to catalog and work with a .NET assembly inside SQL Server....

MSDN Webcast: SQL Server 2005 Essentials: Security Enhancements (Part 5 of 14) (Level 200)     
Total Hits: 236  |  Today: 0Author: Steve Muise      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 features the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. Since the CLR is hosted in the SQL Server engine, we are able to use the CLR security features. This fifth module of the 14-part SQL Server series covers the security enhancements in SQL Server 2005. This webcast examines how to use code access security (CAS) from within the SQL Server engine and how .NET types fit into the SQL Server permissions scheme....

MSDN Webcast: Applying SQL Server 2005 Data Mining to Enterprise Business Problems (Level 300)     
Total Hits: 218  |  Today: 0Author: Jamie MacLennan      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 offers a full spectrum of data mining capabilities. Still, knowing which tool or method best applies to your problem is not always obvious. This webcast shows you how to recognize the types of problems that you can solve with SQL Server 2005 Data Mining, including several examples of how various algorithms work, and solutions to practical scenarios....

MSDN Webcast: Introduction to SQL Server 2005 Reporting Services (Part 5 of 6) (Level 200)     
Total Hits: 152  |  Today: 0Author: Geoff Snowman      Rating:  
Read Reviews | Write Review |  Your Rating: 

This six-part series presents a comprehensive introduction to Microsoft SQL Server 2005 Reporting Services for developers. The fourth webcast in this series delved deeper into advanced reporting designs. This fifth webcast focuses on SQL Server Reporting Services extensibility. We demonstrate a custom data source for SQL Server Reporting Services that reads data that is not accessible through SQL queries. We also demonstrate techniques for including custom code in reports....

MSDN Webcast: A Primer to Proper SQL Server Development (Part 6 of 10): Mixed Workloads, Secondary Databases Wait States Locking and Isolation (Level     
Total Hits: 212  |  Today: 0Author: Kimberly L. Tripp      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 makes it possible to use snapshot isolation to accomplish everything within a single database, but this is not always your ideal choice. In Part 6 of our series on proper SQL Server development, we examine the variety of ways that are available in SQL Server 2005 to handle data analysis, and we discuss the benefits and drawbacks of each method. This session will help you get a feel for the right circumstances for using each approach in your application. Part seven conti...

MSDN Webcast: Applying SQL Server 2005 Data Mining to Enterprise Business Problems (Level 300)     
Total Hits: 240  |  Today: 0Author: Jamie MacLennan      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 offers a full spectrum of data mining capabilities. Still, knowing which tool or method best applies to your problem is not always obvious. This webcast shows you how to recognize the types of problems that you can solve with SQL Server 2005 Data Mining, including several examples of how various algorithms work, and solutions to practical scenarios....

MSDN Webcast: Intelligent Reporting: Charting in Depth     
Total Hits: 200  |  Today: 0Author: Geoff Snowman      Rating:  
Read Reviews | Write Review |  Your Rating: 

Increase the effect of your reports using Microsoft SQL Server 2005 Reporting Services. This component of SQL Server 2005 goes beyond text-based reporting, making it possible to include images and a wide range of chart types in your reports. In this webcast, you will learn about the different charting options available, various chart types, and techniques for grouping and categorizing data....

Table Constraints in SQL 2005  Version: 0.00     Price: $0.00  
Total Hits: 23  |  Today: 0Author: Sivaraman Dhamodaran      Rating:  
Read Reviews | Write Review |  Your Rating: 

Constraints are rules that decide what kind of data can enter into the database tables. SQL server has six types of constraints and we will explore all these constraints here with suitable examples. The constraints that we are going to explore are listed below:

1.

Primary Key Constraint
2.

Foreign Key Constraint
3.

Not Null Constraint
4.

Unique constraint...

Using Solutions and Projects to manage your SQL Server code     
Total Hits: 90  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When developing code for a project there is often more than one component that you need to work with for the entire project. The project may include new tables, table changes, new stored procedures, changes to stored procedures, etc... Keeping all of these components straight as well as logically grouped together is sometimes a challenge in itself. Are there are any built-in tools that allow you better manage project components vs. one big file?...

Execute Dynamic SQL commands in SQL Server     
Total Hits: 198  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL ...

MSDN Architecture Webcast: ADO and SQL Web Services (Level 200)     
Total Hits: 303  |  Today: 0Author: Thom Robbins      Rating:  
Read Reviews | Write Review |  Your Rating: 

ADO.NET 2.0 shifts the managed provider access model from an interface-based model to a class-based model. Since SQLXML 3.0, developers have been able to expose Microsoft SQL Server output directly as a Web service. Are you ready for the changes? Join this webcast as it covers hypertext transfer protocol (HTTP) endpoints and Web services inside the database. Now, with the tighter integration of SQL Server and XML, Microsoft SQL Server 2005 enhances the architectural possibilities of Web services...

MSDN Webcast: End-to-End SQL Server 2005 Reporting Services (Part 6 of 6) (Level 200)     
Total Hits: 309  |  Today: 0Author: Susan Wisowaty      Rating:  
Read Reviews | Write Review |  Your Rating: 

This concluding webcast in our series on Microsoft SQL Server 2005 Reporting Services addresses two areas: integrating Reporting Services into custom applications, and extending Reporting Services. Learn how to add code to a report, use the Reporting Services Web service as a data source, and create a custom data source. We show how Reporting Services is a flexible reporting tool that can easily be incorporated into different applications. We also examine Reporting Services as a robust and scala...

TechNet Webcast: Introduction to Security in SQL Server 2005 (Level 300)     
Total Hits: 256  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

Join this webcast to learn how security is implemented in Microsoft SQL Server 2005. We discuss security from the perspective of the server, the database, and database objects, and review the different options you can use at each level to help secure your data. We explain how SQL Server 2005 breaks security down into several distinct areas and describe the security concepts that are introduced in this release, such as user-schema separation. See how familiar security concepts such as encryption ...

TechNet Webcast: Microsoft Office Excel 2007 and SQL Server 2005 Analysis Services Integration Explained (Level 200)     
Total Hits: 304  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

Business Intelligence (BI) is all about business users making better and faster decisions based on the correct data. Getting accurate data into users' hands is crucial to any successful BI application. To that end, this webcast shows how to use Microsoft SQL Server 2005 Analysis Services and Microsoft Office Excel 2007 to build an enterprise-level data analysis solution. We show you how to develop server-side business rules and unified views of business data for one version of the truth, while a...

TechNet Webcast: A SQL Server DBA’s Guide to CLR Integration (Level 300)     
Total Hits: 225  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

While most webcasts on common language runtime (CLR) integration in Microsoft SQL Server 2005 are targeted at developers, this session answers the key questions that database administrators typically ask: "You want to put WHAT in my server?"; "Why would you want to do that?"; "How will it affect my server in terms of performance, security and stability?" This webcast also provides specific advice and recommendations for database administrators on their dealings with developers....


1  2  3  4  5  6  7  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net