Error handling is one of those things that is simple to do in SQL Server, but most people don't do it and it's not the most rebust thing. Here's another way that you can implement error handling in your stored procedures from a new author Amit Jethva.
Have you ever built a join graphically using Access or Visual Studio? Did you know that you can do this with the native SQL Server tools? And it's easy! Follow along as Dale Corey shows you how.
The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!
Lumigent Technologies today announced that they are a recommended supplier to provide data auditing solutions for risk management to customers of Microsoft SQL Server 2000 through their Entegra product. Enterprises that depend on SQL Server databases can now rely on Entegra as a trusted auditing solution to enable compliance with regulatory requirements.
The error handling in SQL Server leaves something to be desired, especially compared with other RDBMSes and languages. The standard method of testing for errors can leave your code bloated and hard to read. Stefan Popovski looks at another method of handling errors.
What's wrong with SQL Server? Lots of things to some people, but here's a look at where this product is positioned in the marketplace against the other RDBMSes.
A little off topic (or is it?), David needed to vent a little - something we can all appreciate. Meant to be light hearted fun, please don't take too seriously.
Sometimes its good to get back to basics - or to make sure you really know all the basics. This is a very good intro to all the different join types.
Are you a new SQL Server administrator? A network admin or developer who got the responsibility for a SQL Server dropped on your head? Steve Jones starts a new series looking at a few of the things that you might want to know if you've never worked with SQL Server before.
Good enough for your bookshelf? This one meets that requirement for Brian, click the link to find out why.
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers