(Gary Vidal) In this article I am going to go into a comprehensive discussion on maps, operators and show even more functionality exposed through maps. In a previous post Returning Lexicon Values using XPath Expressions, I alluded to the fact that map:map supports operators and used it to compute th
Other News
Load Testing Made Easy with Microsoft Azure and Visual Studio Online
(Charles Sterling) The Internet is the great equalizer in the business world. It helps the smallest companies compete with the largest corporations in the world. There is as much opportunity as there is risk. Applications must perform on time all the time. Downtime equates directly to lost revenue.
WebClient and GetWebResponse not firing on Async Requests
(Rick Strahl) Here’s a little oddity I ran into today: When you’re using the good old simple WebClient class you can subclass WebClient and capture the HttpWebResponse object. This is useful because WebClient doesn’t expose any of the important HTTP results like Http status code or headers. WebClien
Dedicated BlueMix is now available
(Roman Kharkovski) Yesterday IBM announced the availability of the dedicated BlueMix PaaS. Why would you care? Some companies do not feel comfortable running in a fully shared public environment and dedicated PaaS running on IBM SoftLayer is as close to the on-premise as it gets, but arguably remove
Simple String Encryption in Visual Basic (Part 1)
(Ged Mead) A question that comes up again and again is the one that asks: “How can I encrypt a string?”. The answers range from the simple switching of characters right up to using a wrapper for a System.Security.Cryptography.TripleDESCryptoServiceProvider object.
SQL Server Database Mirroring Monitoring
(Rohit Garg) SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working fine.
Changing Your SQL Server Name
(Chris Bell) When the name of the actual host machine’s server name does not match the server name stored in SQL Server a lot of things can start to go wrong.
What’s the Big Deal About Query Optimization? Part 2
(Suresh Sane) Though the complexity of SQL queries has grown significantly, recent enhancements provide the opportunity for query optimization. The first installment of this series focuses on the challenges of increasingly complex SQL in relational databases.
Tempdb: Checksum or Torn Page Detection (or None)?
(Michelle A. Poolet) Tempdb performance tuning can be an art unto itself. We probably all know the standard stuff:
One Size Does Not Fit All
Yesterday I presented a case for not storing BLOB data in SQL Server. Dave Shared in the comments an good case against my generalized position against using blobs. His primary concern was the sprawl of files by storing each instance of BLOB data as a separate file. His product was a self-contained image management tool. By using SQL Server as […]