(Ember Crooks) I first addressed the new 9.7 methodology for deadlock and locktimeout analysis in my post Analyzing Deadlocks – The New Way. I’ve been playing with it a bit, and wanted to share what I’ve found. First of all, so far, I like it. I can’t speak to overhead yet, but it integrates lock ti
Other News
Statistics and Recompilations
(Erin Stellato) A couple weeks ago I was asked to look at system performance for a customer, and as part of my investigation I found a high read query. I had run a trace and filtered for anything over 10,000 reads and saw a query that required around 32,000 reads, and it was running at least once a
Three tips for a better SQL Azure migration
(Robert Sheldon) If you’ve decided to use SQL Azure to host your databases, you might need to migrate some of your SQL Server on-premises databases to the new environment. Doing a successful SQL Azure migration means picking the right tool, loading data into SQL Azure properly, and assessing your mi
Minimising the Impact of Data Model Changes in ADF Application Deployment
(Chris Muir) In the complete lifecycle of an ADF application backed with a database, it’s not uncommon for the data model to change. New columns are added to tables, datatypes are expanded, there are many changes that can take place in the database.
SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS
(Pinal Dave) “I do not know where my windows went!” “I just closed my object explorer and now I cannot find it.”
Selective request validation using custom request validator in .Net 4.0
(KedarRKulkarni) Cross site scripting attacks are very common and easy way of trying to break into any website. To secure web page from this common security threat, Asp.net always had request validation mechanism in place.
Some fun with R visualization
(Vadim Tkachenko) My previous post I finished with the graph with unstable results.
SharePoint: Should you use it for your public website?
(Eric Riz) Websites have come a long way from the mind-numbing simplicity of the late 1990s. Gone are the websites with basic left-margin navigation and static text, bland images, and broken links.
Use optimization profile in DB2 for Linux, UNIX, and Windows stored procedure
(Rui Bo Han) The optimizer of IBM DB2 for Linux, UNIX, and Windows relies on a cost-based design. Using an SQL statement input by a user or application, the optimizer selects an execution plan with the lowest cost to achieve the best performance.
ASP.NET Web API (Part 1)
(Scott Guthrie) Earlier this week I blogged about the release of the ASP.NET MVC 4 Beta. ASP.NET MVC 4 is a significant update that brings with it a bunch of great new features and capabilities. One of the improvements I’m most excited about is the support it brings for creating “Web APIs”. Today