In this tip, I am going to show you how you can create a Data Access Layer (to store, retrieve and manage data in relational database) in ADO .NET. I will show how you can make it data provider independent, so that you don't have to re-write your data access layer if the data storage source changes and also you can reuse it in other applications that you develop.
The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.
Arshad Ali discusses the Initiator, Target, Message Types, Contract and Queue--all components of SQL Server Service Broker (SSBS).
A recent headline that Google is dumping Windows because of security issues sounds like FUD to Steve Jones.
Paging through results of data, or finding specific sets of data is something that most of us need to do. A new article from Lawrence Moore shows us how we can do this with ROW_NUMBER()
There are numerous databases housing the same information and it's getting quite difficult to keep everything in line. I've heard from a number of departments who want a more centralized approach to handling customer data, but I don't know where to begin. Can you steer me in the right direction?
Microsoft have been cooking up something for Database Developers in Visual Studio 2010, and Phil Factor has decided it's high time he looked into it. It's not as odd as it sounds, and is actually rather promising, as Phil discovers.
Will computers become better at finding context in situations and environments? Steve Jones comments.
The idea of this challenge is to clean up the phrase from the words identified as 'noise' words from the beginning and end of sentences.
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers