Featured Article(s) Using the Merge Statement Inside an Application This article describes how to use the Merge statement with the Dual table to reduce the number of SQL calls and to simplify application code How Do You Vet Your Information? Not your data, your information. We’ve talked before in this space about data usage, how you manage data and such. […]
Author: Ben Taylor
Are You Supporting Mobile SQL Server Applications?
New SQL Server Show Posted Special: SQL Server 2008 Features: Chris Shaw takes a look at some of the new features of SQL Server – and how they work. This is a special airing of his session from the June Virtual Conference. [ Watch the Show Now ] Featured Article(s) Oracle 2-Day DBA in x Days Post 10; Oracle Automatic […]
Are You Supporting Mobile SQL Server Applications?
New SQL Server Show Posted Special: SQL Server 2008 Features: Chris Shaw takes a look at some of the new features of SQL Server – and how they work. This is a special airing of his session from the June Virtual Conference. [ Watch the Show Now ] Featured Article(s) Oracle 2-Day DBA in x Days Post 10; Oracle Automatic […]
Application- (and Data Use) Aware Data Management
Application-Aware Data Management I don’t know how I missed this article from InfoStor a bit ago, but it had me thinking… It sort of answers the call about the whole "how do I split up my databases for recovery, for performance, for reporting… and should I?" It doesn’t really ask that question, but if you think about what they’re saying […]
Application- (and Data Use) Aware Data Management
Application-Aware Data Management I don’t know how I missed this article from InfoStor a bit ago, but it had me thinking… It sort of answers the call about the whole "how do I split up my databases for recovery, for performance, for reporting… and should I?" It doesn’t really ask that question, but if you think about what they’re saying […]
Spatial Data Types – Some Help Understanding Them
Featured Article(s) SQL Server 2005 Clustering Optimization Tips (Part 1) Here are some helpful tips to work with SQL Server 2005 clustering. EMC and Microsoft I don’t know if you’ve seen it, but Microsoft and EMC are really working closely together in a number of areas. One is the backup and recover area, and another is in the area of […]
Spatial Data Types – Some Help Understanding Them
Featured Article(s) SQL Server 2005 Clustering Optimization Tips (Part 1) Here are some helpful tips to work with SQL Server 2005 clustering. EMC and Microsoft I don’t know if you’ve seen it, but Microsoft and EMC are really working closely together in a number of areas. One is the backup and recover area, and another is in the area of […]
AJAX – Are You Doing Applications Work With It Yet?
Video How-To Available TSQL 103 – Part 3 of 3 of the TSQL Introduction Series from the Spring Virtual Conference. This is the final segment, reviewing tips and how TSQL works, essential query elements, etc. [ Watch the Show ] AJAX – Are You Doing Applications Work With It Yet? AJAX is the big thing happening right now – allowing […]
AJAX – Are You Doing Applications Work With It Yet?
Video How-To Available TSQL 103 – Part 3 of 3 of the TSQL Introduction Series from the Spring Virtual Conference. This is the final segment, reviewing tips and how TSQL works, essential query elements, etc. [ Watch the Show ] AJAX – Are You Doing Applications Work With It Yet? AJAX is the big thing happening right now – allowing […]
Web 2.0 – A Good Thing, Or Bad Thing for Projects?
Featured Article(s) Provide login access to all databases in an instance Automating login creations and and assigning appropriate rights – a script. Does "Web 2.0" Help, or Hurt, Your Projects? I know there are some good tools out there, but when it comes to building out projects, creating new tools for your organization, do you think collaboration is paying off […]