Bruno Terkaly at Engineering Services
 |
CLR Development in SQL Server 2005 & Visual Studio 2005
-
Development and database skills are merging
-
DBAs need to learn development skills
-
Developers need to learn the database
-
A fast paced workshop can get you are a group of you bridge between these two worlds in just a day or two
-
As SQL Server 2005 rolls out DBA's are going to be forced to learn either C# or Visual Basic or both
-
Until now these were client side languages and not knowing them had little impact on your job
-
CLR Integration - The Big Picture
-
And much more (Debugging Stored Procedures, Visual Studio, User Defined Data Types, Triggers...
|
 |
IIS Log File Analysis
Create your own custom analysis tool. Import your log files into SQL Server 2000
or SQL Server 2005 and create your own custom algorithms. Hook into Excel Automation,
or Reporting Services. Automate the analysis of your log files. Setup custom alerts.
-
Top 10 Most Used URLs
-
Top 10 Slowest URLs
-
All Unique URLs Retrieved
-
HTTP Error Analysis
-
Errors Per Hour & Groups of Errors
-
Bytes Sent / Received Grouped Various Ways
|
 |
SQL Server 2005 - Service Broker
Five years in the making, this new product offers exciting new capabilities. Service Broker is a part of the Database Engine and
provides facilities for storing message queues in SQL Server databases. New Transact-SQL statements allow applications
to send and receive messages. Each message is part of a dialog: a reliable, persistent communication channel between two participants
Service Broker provides unique capabilities for both applications within a single SQL Server instance and applications that
distribute work across multiple SQL Server instances.
-
Within a SQL Server instance, Service Broker provides a powerful asynchronous programming model
-
Asynchronous programming allows database applications to improve response time and increase throughput by performing resource-intensive tasks as resources become available
-
Service Broker also provides reliable messaging between SQL Server instances
-
Service Broker supports the vision of applications architected as services
|
Contact me immediately for assistance at 415-336-5079
or Click
Here To Mail Bruno Terkaly
Upcoming Content
Language Enhancement for .NET 2.0
Upgrading your code, Best Practices, Optimizations
CLR Stored Procedures
When to Re-Write Transact-SQL
Eliminating Extended Stored Procedures
CLRs Are Object Aware
CLR Triggers
CLR User-Defined Data Types
Performance Analysis and Tuning
Design, Analysis, and Tuning
Solve Locking and Blocking
