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.
2010-10-25
3,289 reads
In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.
2010-10-22 (first published: 2009-08-25)
18,632 reads
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?
2010-10-22
3,228 reads
This article demostrates how to set up email notifications for SQL Server Agent Restarts.
2010-10-21
1,926 reads
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
2010-10-21
2,806 reads
More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.
2010-10-20
721 reads
As we continue in this series, see how auditing tables are used to track all changes that are made to the main data tables.
2010-10-20
8,301 reads
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.
2010-10-20
1,918 reads
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
2010-10-20
4,525 reads
String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor
2010-10-19
4,427 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Have you done a Mid...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers