(Kalen Delaney) The optimistic concurrency model assumes that several concurrent transactions can usually complete without interfering with each other, and therefore do not require draconian locking on the resources they access.
Other News
SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action
(Pinal Dave) Actions are used for customized browsing and drilling of data for the end-user. It’s an event that a user can raise while accessing the cube data. They are used in cube browsers like excel and are triggered when a user in a client tool clicks on a particular member, level, dimension, ce
Mapping between Database Types and Client Types in the .NET Backend using AutoMapper
(Jason Cooke) Most of the samples showing how to use the .NET Backend have a single type that represents both the data stored in the database and the data that is exposed to the service callers. However, sometimes you cannot expose your database data as-is, or you want to provide and accept extra da
DB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security
(Anas Mosaad and Mohamed El-Bishbeashy) This tutorial introduces authentication, authorization, privileges, and roles as they relate to IBM DB2 10.1. It also introduces granular access control and trusted contexts. This is the second in a series of six tutorials designed to help you prepare for the
Layouts, RenderBody, RenderSection and RenderPage in ASP.NET MVC
(Shailendra Chauhan) Layouts are used to maintain a consistent look and feel across multiple views within ASP.NET MVC application. As compared to Web Forms, layouts serve the same purpose as master pages, but offer a simple syntax and greater flexibility.
Office for Touch Based Platforms
Microsoft released its latest touch based version of office for the iPad recently. They are targeting a release to the Android platform next, and then following up on a release to the new Windows 8 operating system. This is a new version of office that has been re-designed to make it work better in a touch based environment such as […]
Intro to Power Pivot
Pro-Center Video Programming for IT Professionals
Intro to Power Pivot
Pro-Center Video Programming for IT Professionals
SQL Server DBA Tip: One Time Schedules
(Michael K. Campbell) Most DBAs are aware that they can simply right click on a SQL Server Agent Job from within the SQL Server Management Studio GUI and start the job at any time desired by using the Start Job at Step menu command:
SSIS package fails with error : The step did not generate any output. The return value was unknown
(Mahaja) One of my customers recently ran into a very strange issue. We had many SSIS Packages that were running as a SQL Server Job.