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
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Forums
One more reason to use foreign key constraints
Comments posted to this topic are about the item One more reason to use...
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers