Using Check Constraints
Check constraints can be added to a table to enforce specific rules on one or more columns. This article shows you how to use them to enforce simple and more complex rules.
Migrating from Oracle to SQL Server
Are you migrating your database and applications from Oracle to SQL Server and having trouble converting your code from PL/SQL to T-SQL? Then this article might help, though it doesn't cover all aspects. It provides you with answers to most commonly asked migration relasted questions. You will also find links to additional resources and books.
Worst Practice - Sorting by Ordinal
If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!
Push Those Logs Away!
Steve found a gaping hole in his backup process. One that he plugged with this script to move log files around the network in the event of a server failure. If you can't afford to lose a day of work, read about his solution.
Pause for a Minute
Ever needed a pause in a script? Maybe want to retry something after a minute? This article gives a quick snipped of code that will help you implement a pause in your script.
Get the Latest SQL Server News Across the Web
Eurgeeka is a central place to search for the latest in SQL Server news, articles and press releases. If you're a SQL Server solution provider or website, you can add your news for free! New information daily! Eurgeeka puts the pride back in the word geek.
Advice on using COUNT( )
In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column).
New SQL Server News Site Begins Beta Test
Come and help us beta test our new website! Eurgeeka is a central place to search for the latest in SQL Server news, articles and press releases from all SQL Server related websites. If you're a SQL Server solution provider or website, you can add your news for free!
Adding Linked Servers Using SQL-DMO
Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.
Build Notification Services
Microsoft SQL Server 2000 Notification Services is the premier platform for developing and deploying a new class of scalable Web applications that deliver personalized, timely information updates to a variety of mobile devices. Review the resources on this page for details.
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers