Featured Article(s)
SQL Server 2005 Clustering Optimization Tips (Part 1)
Here are some helpful tips to work with SQL Server 2005 clustering.
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 SQL Server Always On Technologies. EMC has been building some really incredible storage systems and working with Microsoft to make sure they are stepping up to the plate on server management and high availability solutions. Check it out here – along with whitepapers and technical guides to the work they’re doing.
Spatial Data Types – Some Help Understanding Them
Saw this great post that answers a number of questions SSWUG readers have written in about – and have asked about at different points. Specifically, what are the spatial data elements really all about, and how do they work?
Jason writes: "Recently there has been a lot of discussion and focus on various location based services such as map API’s and GeoRSS but I never heard much about how people were actually storing their geographical data. I always assumed that their databases had columns for latitude and longitude using some sort of decimal datatype. Well, it seems that might not be the case because things look to be heading in a very different direction."
Read the blog post and get the examples here.
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 ]
Featured White Paper(s)
Transforming Enterprise Backups: How Using a Third-Party Tool Can Improve Backup Strategies
The backup and restore facilities in native SQL Server are robust, and once a backup routine is established, the DBA needs to… (read more)
The Payment Card Industry Compliance – Securing both Merchant and Customer data
This white paper introduces the Payment Card Industry Compliance standard, and the security threats which brought about the n… (read more)