(Pinal Dave) I have previously written about how to find the top and bottom value of column in SQL Server but recently I got a very interesting question based on the same blog post. The question was how to find the last value from Column in Google Spreadsheet. I find it very interesting and attempte
Other News
Approaches to DB2 Access Path Management
(Craig S. Mullins) BIND and REBIND are crucially important components as you attempt to assure efficient DB2 applications. Because the BIND/REBIND process determines exactly how your DB2 data is accessed it is important that you develop an appropriate strategy for when and how to REBIND your program
The DBA’s ‘Must Know’ List
(Lockwood Lyon) In a mainframe environment, where you share DB2 with hundreds of other apps, being well-behaved is important. The DBA will ensure this by gathering the following important information during application design.
Loading ASP.NET MVC Controllers and Views From an Assembly – See more at: http://weblogs.asp.net/ricardoperes/loading-asp-net-mvc-controllers-and-views-from-an-assembly#sthash.N7uTyNPU.dpuf
(Ricardo Peres) Back to MVC land! This time, I wanted to be able to load controllers and views from an assembly other than my application. I know about the extensibility mechanisms that ASP.NET and MVC give provides, such as Virtual Path Providers and Controller Factories, so I thought I could use t
Performance Optimization in ASP.NET Web Sites
(Raj Aththanayake) Performance is an important aspect of a modern day web application development. Not only it makes sites seamless to use but also increase the scalability and future proof. In this article, we will look at various aspects of improving the performance of web applications.
Building Web API using MVC 6 & MongoDB
(Shayne Boyer) This is a quick walkthrough on using ASP.NET 5 to build a Web API layer using MongoDB. The overall concept is not too dissimilar from previous examples you may have seen using X type of database, however there are some areas covered that are either new in MVC 6 that you may find you d
Using JSON Web Tokens with Katana and WebAPI
(K. Scott Allen) A common question I’ve been getting is how to use tokens with ASP.NET, specifically JSON Web Tokens (JWT) with ASP.NET WebAPI where the OAuth server and the resource server are the same. In other words, you have a single web site that wants to both issue tokens to authenticated clie
Custom Commanding Behavior in WPF TextBox using System.Windows.Interactivity namespace
(Mahesh Sabnis) System.Windows.Interactivity helps us to associate custom commanding for those WPF elements who do not have the Command property exposed. This article demonstrates how to implement custom behavior without making use of a 3rd party framework.
[SQL Snacks Video] Performance Tuning 103 – T-Logs and VLFs
(Ayman El-Ghazali) Finally the arrival of Part 3 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server.
Data Retention
Data retention is one of my favorite database topics because it has one of the greatest impacts on database performance. It also has a great impact on the capabilities of a company to fully utilize information for profit and efficeiency. Keeping too much data causes you database performance to degrade, increases the length of maintenance windows, and can even result […]