The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures.
In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.
There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine exactly where the problems lie, in order to fix them?
Today we have a guest editorial from Andy Warren that talks about ways to enjoy life without spending a lot of money. Some of these might even be great team building ideas.
This article demostrates how to set up email notifications for SQL Server Agent Restarts.
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.
It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.
As we continue in this series, see how auditing tables are used to track all changes that are made to the main data tables.
The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Comments posted to this topic are about the item Increase Deadlock Detection
Comments posted to this topic are about the item A Tool is Better than...
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers