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 for no refresh of web pages while still going out and getting fresh information for your audience. It’s a good tool on many fronts, and has challenges in some areas. The good side of things is that you’re able to increase usability for your audience – faster refreshes, fewer page paints, etc. The downside can include search engine issues – with much of the information generated dynamically, it can be challenging to have search engines see the full extent of your page (since the search engine can’t really "submit" a page and see the results).
There was a good summary article on Info World talking about what AJAX is, and is not. It has some good points – and clears up some very common misconceptions. Take a look here.
A couple of the points caught my eye from the perspective of SSWUG-type things – "9) Old Security Threats Get a Second Exposure" was high on the list. As you work with systems to enable AJAX-style interaction with your developers, end-users and the like, make sure you’re taking a second look at the types of interfaces you’re opening up, or potentially opening up, in support of these more interactive applications. I’ve seen a number of places where new cross-site scripting vulnerabilities were introduced because of the interactivity of the AJAX-style applications.
Featured White Paper(s)
SQL Server Fragmentation Explained
As the data in Microsoft SQL Server tables changes, their indexes change. Over time, these indexes become fragmented. This fr… (read more)
Selecting the Right Change Management Solution
Frequent application updates, data migrations, service level requirements, and new compliance mandates mean your company need… (read more)