SQL Server backups are rock solid. But checking them is another matter and something that every DBA is responsible for doing. Another followup article by new Author Kevin O'Donovan to the issue of looking at which database
The SQL Server ports 1433, was blocked recently by an ISP. New Author Denny Figuerres read our release and decided to bring you some comments about why this isn't such a bad idea. Read on and see if you agree that blocking the SQL Server ports shouldn't present you any problems.
See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.
Entegra for SQL Server has been available for some time, but Lumigent has recently announced support for Oracle. So if you're in a heterogenous environment...
String manipulation in SQL Server or T-SQL can be a challenage. There are multiple ways to accomplish every task and often learning a new one may spark some creativity in yourself or teach you a better way to accomplish an old task. New Author Stephen Lasham brings us his technique for extracting a string that is delimited from within a larger string. Something I'm sure we'll all have use for in the future.
SQLCentric is a fully functional Web-based MSSQL Centric Network Database Monitoring System which is deployed on your corporate intranet. Now for a limited time, Pearl Knowledge Solutions is running a sale on this product.
This is rich. A hotel sets up Internet access using Linux for guests. But they run SQL Server internally. So much for all the FUD coming from MS.
Reducing the amount of round trips between a server and client is something that can give you a great boost in performance. David Poole looks at how he solved a problem with HTML checkboxes and the challenges they solve in a programming environment. Without Dynamic SQL!
A personal article refering to the latest change from NTL broadband stopping port 1433 globally on their network. Users are no longer able to develop Microsoft SQLSever systems using ODBC or Enterprise manager.
Learn about SQL Server and the CLR. Join PASS and speaker Michael Otey, Senior Technical Editor for SQL Server Magazine and Windows & .NET Magazine and President of TECA, Inc., for the upcoming WebCast where you'll learn about the new .NET Common Language Runtime integration with SQL Server 2005. Registration Required.
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
hi, im not a dba. For a couple of years our dev sql server...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Can I set Accelerated Database Recovery on tempdb?
See possible answers