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 ...

You want tables [0].rows.count - test for 0 rows. You could also add the row in the SQL query. SELECT MAX (TimeStamp) TimeStamp, COUNT (*) RowCount FROM ... And check RowCount first. Second suggestion ...

The SQL Server team is unleashing the first widespread test builds of the next version of Microsoft's database, a k a SQL Server 2008 R2 (codenamed "Kilimanjaro"). Earlier this year, Microsoft ...

Microsoft is expected to deliver the third Community Technology Preview (CTP) of the next version of its SQL Server database during the Worldwide Partner Conference the week of July 11, according to ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

Microsoft this month described a test service designed to help SQL Azure users monitor the security of their databases housed in Microsoft's cloud. Code-named "SQL Azure Security Services," it's ...

As any database admin knows, mastering the subtler nuances of SQL can be likened to the black arts. For me, tuning the efficiency of SQL queries on large, heavily used databases is a perfect example.

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...