SQL Server has a great alerting mechanism for letting DBAs know when some event has occurred, but adding this notification to clients is a little more difficult. New author Stas Vasiljev brings us an extended stored procedure that has has used to allow clients to receive a broadcast when data has changed on a server.
Most software projects fail. Only about a quarter are completely successful. About half are late and over budget and the remaining quarter just fade into oblivion. What if there was a simple way to ensure your project’s success? There is, and it’s all about starting out in the right way
SQL Server 2005 has dramatically changed the way many maintenance plans are used. New author Aaron Ingold brings us an introductory look at Maintenance Plans in this new version.
SQL Server 2005 offers a new tool, Database Snapshot, which helps protect against user errors. It's a great feature, in some ways. But Ravindra Okade cautions against relying on it as an all-purpose rescue device.
The user group in Detroit is back and looking for new members. If you are in the area, check out the announcement for their next meeting.
SqlSiteMapProvider reads site maps from SQL Server databases. And it takes advantage of the ASP.NET 2.0 provider architecture to integrate seamlessly with the site navigation subsystem. Just create the site map database and register SqlSiteMapProvider as the default provider, and then, like magic, everything else just works.
What is the cost of DRI and is it something that you should implement? SQL Server expert David Poole takes a look at the impact of adding DRI to a CMS system and provides some real world results on which you can base your decision.
In Part Two of his series, database administration expert Baya Pavliashvili explores the challenges involved in building and maintaining a warehousing solution using a simple database warehouse.
A bit of a break from the SQL Server side with this great new .NET class developed by new author Jereme Guenther. He prints a page character by character to handle control of formatting. Take a look and see if this solves any of your .NET printing problems.
In the first of a two-part series, Baya Pavliashvili, database administration expert, offers solutions to your business problem using a data warehouse.
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers