By Paul Krill – AS INTEREST IN open-source databases builds, data management veterans IBM and Microsoft argue that alternative open-source databases such as MySQL lack the strength and functionality for enterprise deployment.
Tag: sql server
SQL Server: Recovering the Master Database
by Frank McBath – Run through a typical recovery situation step-by-step, plus review specific critical issues such as restoring logins and organizing restored user accounts.Registration required.
Database Administration: The Complete Guide to Practices and Procedures
Book By Craig S. Mullins – This book is a little different from most of the books I review on this website. It is different because it doesn’t solely focus on SQL Server, but instead covers the bigger picture of database administration that applies to virtually every database. Whether you use SQL Se
The .NET Architecture Center
By Brian Moran – IT professionals can easily be overwhelmed by the mass of technical information that’s available. For help sorting the informational wheat from the chaff, check out Microsoft’s new .NET Architecture Center.Don’t let the .NET moniker fool you. This site includes plenty of val
Implementing full text search in T-SQL stored procedures
By Eli Leiba – Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager, but is still worthwhile. Here are the T-SQL steps to take in order to implement FTS in T-SQL.
ASPReport Enterprise General Info
ASPReport is a data driven, web reporting solution for Microsoft SQL Server. Imagine the ability to leverage off an existing database and begin offering your users literally hundreds of reports in a few minutes rather than months.
Additional Criteria in the JOIN Clause
Have you ever seen a SELECT statement joining two tables that had something like and Field = Value in the JOIN clause? Did you, like me, ask yourself, “Why did they put that in the JOIN instead of in the WHERE clause?” What difference does it make? Well recently I found out that I needed this functi
Using Functions
John Paul Ashenfelter continues his SQL tutorial with one of the most useful but most frustrating areas of SQL: built-in functions.
SQL Server Magazine LIVE!
Learn from and interact with the writers from Sql Server Magazine. Check it out for dates and location!
Inside SQL Server 2000
Master the inner workings of today’s premier relational database management system with this official guide to SQL Server 2000, winner of SQL Server Central.com Reader’s Choice award.