Twenty-one new webcasts are scheduled for November, covering such topics as How Microsoft IT Implements Encryption Using SQL Server 2005, The New Features of T-SQL in SQL Server 2005, Intelligent Reporting and more.
Tag: sql server
Northwind Sales – A Sample XRMS WebSql Data Provider Remote SQL Database Application
(Jeff X. Chang) Distributed applications are generally connected to data services, very often, the only reason for many applications designed as distributed is the need for network data services access. Such applications are so common, that the practice of developing LAN based database applications
Backing up and Restoring Databases in SQL 2000
(Steven Warren) If you are a Database Administrator (DBA), I have no doubt in my mind that you have been called away from home, dinner, or just plain in the middle of the night to answer a page on a disaster with your database(s). In this field, it is the nature of the beast to get called away at th
Improving Data Security by Using SQL Server 2005
Detailed discussion describing how Microsoft IT uses SQL Server 2005 to improve data security for its line of business applications. SQL Server 2005 enabled Microsoft IT to implement column-level encryption together with a robust, and yet easy-to-use encryption key management framework. (doc)
How to increase the number of SQL Server error logs
This article describes how to increase the number of SQL Server error logs.
An interview with Damian Mehers
(Douglas Reilly) I have never met Damian Mehers, but I know him by way of a tool he created, called PromptSQL. I have, over the years, used a number of tools that promised to bring Intellisense into the SQL Server world, but the way PromptSQL works is unique.
FIX: An access violation may occur when a deadlock graph is written to the error log in SQL Server 2000
Consider the following scenario: • You enable the 1204 trace flag in Microsoft SQL Server 2000 to identify SQL Server deadlock events. • A deadlock event occurs, and a deadlock graph is automatically written to the SQL Server error log.
Hacker Protection for Your Web Applications
(Caleb Sima) Your Web applications can be the most important and most vulnerable entry point into your organization, and, as such, ensuring adequate hacker protection in your Web applications can be critical. A Web application not only includes the code that creates your Web site, but also the a
Using TRY…CATCH in Transact-SQL
(Himanshu Kumar Sinha) In this article, I will discuss the new feature ( TRY ……..CATCH) for errorhandling in SQL Server 2005.
Compress SQL Server backups using WinZip – Part II
(Muthusamy Anantha Kumar) Part I of this article illustrated how to use reasonably priced WinZip to do a full backup and transaction log backup. Part II of this article is going to illustrate how to delete the original backup file after zipping the backup file using WinZip and how to uncompress the
