One of the great new features of SSMS 2008 is the new debug facility. Query Analyzer had a stored procedure debug facility in SQL Server 2000 but it was not transferred when SQL Server 2005 combined ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

I recently wrote a .NET web application for work. I always make a data access class with methods for getting data, but I usually just point the methods to stored procedures. This time, I decided to ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...