(Vincent Corvinelli and Samir Kapoor) Statistical views provide the necessary sophisticated statistics to the optimizer to more accurately model complex relationships. In this article, you learn through examples how to identify these complex relationships and create statistical views to allow the op
Author: SSWUG Research
MySQL 5.6: single-threaded performance regressions
(Mark Callaghan) I ran single-threaded performance tests to compare MySQL using releases 4.0.30, 5.0.85, 5.1.63 and 5.6.11. On my simple tests 4.0.30 is almost 1.5X faster than 5.6.11. I think it is important to reduce these regressions.
Profiling your ASP.NET MVC Applications with MiniProfiler
(Suprotim Agarwal) Profiling MVC production code at runtime can often be tough, messy and a performance hog. MiniProfiler created by the Stack Exchange team is an easy-to-setup-and-use profiling library for ASP.NET MVC and Entity Framework.
Custom Validation with IValidatableObject in MVC
(Abhimanyu Kumar Vatsa) In this post you will learn how to create a self validatable object using IValidatableObject to validate data in MVC.
Reverse engineering your .NET applications
(Tony Patton) The .NET Framework makes it easy to reverse engineer an existing application. Discover what techniques to use to deter prying eyes from deconstructing your code.
SQL Server 2012 Integration Services – Using PowerShell to Configure Project Environments
(Marcin Policht) In the recent articles published on this forum, we have been discussing how to leverage the capabilities of PowerShell to automate the most common SQL Server Integration Services administrative task, focusing in particular on the project deployment model introduced in SQL Server 201
SqlDev PowerShell 101: Getting Started with PowerShell
(Michelle Ufford) This is the first in a new series focused on PowerShell for SQL developers. That means using PowerShell to create and/or modify table schema, stored procedures, and indexes.
Hum… Better Tools Are the Answer to Increased Complexity?
(Craig Shallahamer) Oracle performance analysis has come a long way in the last 20 years. First there was the “just add more resources” approach and tuning the blatantly poor SQL. Then there was ratio analysis, followed by wait event analysis, time based analysis, and unit of work time based analysi
How to restore the spfile while using the flash recovery area and not the recovery catalog
(Marco V.) Imagine someone has deleted your spfile or you have modified it in depth that you are now unable to even startup your database.
Getting an estimate – DB2 LUW V10.1 Compression
(Philip) So you want to add compression to your house you need to get a tradesman in to give you an estimate, then carry out the work, DB2 can do all of this. Just like building an extension you need to make sure that you need all the appropriate permissions from the “council” (IBM) in place, you ei