Today many companies determine to publish their data on the Internet trying to expand their business and make their information more accessible. The IT industry proposes a wide range of original solutions for resolving data inconsistency problems that publishers inescapably face when exporting their data as they need to properly access, process and interchange large amounts of information mainly through the web.
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
SQL Bits IV, in Manchester, UK next year on March 28th, is now looking for speakers. Please submit a session if you are interested.
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
A little procedure to quickly product a script for copying data from one database to another.
At first glance, a client appeared to be violating a cardinal rule of data warehousing. However, Bill Inmon's further investigation revealed that perhaps their actions were acceptable.
Steve Jones looks back at the past year and database news that has occurred.
Steve Jones looks back at the past year and database news that has occurred.
Steve Jones looks back at the past year and database news that has occurred.
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers