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,639 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
726 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,310 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
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers