| Home : Databases : SQL Server |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
SQL Server Listings
|
|
Total:
42 | Displaying: 21 - 30 | Pages: << 1 2 3 4 5 >> |
|
|
|
This article explains about tracing facility in SQL Server for recoding what stored procedures and other programs do. This installment in the series writes messages to the trace table or to SQL Query Analyzer's results pane.
Updated: 03/08/2005
|
|
|
Before working with traces and showing you the code that writes trace output we have to discuss another concept that I use for organizing trace output. The concept is the session. For me, sessions represent a single use of a program. The program might be a Windows Forms program, SQL Agent Job, a stored procedure, or an ASP.Net on-line user session.
Updated: 03/08/2005
|
|
|
SQL Server 2005 allows the creation of User Defined Aggregates in VB.Net or C#. This article shows how simple it is to create and use a user defined aggregate.
Updated: 03/08/2005
|
|
|
Like the SQL Server ErrorLog, the SQL Server Agent ErrorLog is stored in a text file on the servers disk. It's usually in the subdirectory \MSSQL\Log under the location were the SQL Server Instance's code is installed. This article’s code is a UDF, udf_SQLA_ErrorLogFile that reads the registry to find the location of this log file.
Updated: 03/08/2005
|
|
|
This article explains about the transaction log that SQL Server maintains for transaction and database recovery, about the process of getting a message from a piece of code to the person responsible for responding to the message. The first such person is usually the DBA for the site. But if the message reflects a problem in the code, it may often have to be passed on to a developer who can modify the application.
Updated: 03/08/2005
|
|
|
Query Analyzer offers a template feature that acts as an aid in producing all types of SQL code. There are templates for stored procedures, triggers, and user-defined functions. There are also templates for using some system stored procedures such as the ones to manage extended properties.
Updated: 03/08/2005
|
|
|
SQL Server 2005, formerly known as Yukon, should be arriving sometime in 2005. This book shows developers many of the ways that they can work with the new features in SQL Server 2005. It does a good job but if you're going to read it, do so quickly. As new beta code is distributed, this book is aging quickly.
Updated: 03/08/2005
|
|
|
The .Net framework is a great start for building business applications. This presentation discusses the alternative possibilities for distributing smart client applications such as:XCOPY, Setup projects that make a Windows Installer MSI No-Touch deployment (With and without the NetRun tool)Microsoft's Patterns-and-Practices Updater Application Block (UAB)
Each of these alternatives are discussed in light of the considerations that go into making the decision about how to deploy your application.
Updated: 03/08/2005
|
|
|
Novick Software anounces the opening of the Programmer's Shop at Cafe Press. The shop offers fun merchandise forprogrammers and those who love them. Featured products are SQL Guru, SQL DBA mugs and .Net Guru caps. These products make the prefect holiday gift for the SQL DBA or SQL Guru in your office.
Updated: 03/08/2005
|
|
|
Routines to improve the way that trace messages are retrieved. The goal is to make it easy to get the trace messages from the AppSession, AppSessionTrace, and AppSessionMeasurement tables.
Updated: 03/08/2005
|
|
|
SQL Server Listings
|
|
Total:
42 | Displaying: 21 - 30 | Pages: << 1 2 3 4 5 >> |
|
|
