Undocumented SQL Server 2012 extended stored procedures (Part 2) An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server. You can run extended stored procedures as normal stored procedures. Extended stored procedures are used to extend the capabilities of SQL Server. You can take advantage of the many extended stored...
Other News
Too Much Validation is Too Much
(Jeffrey Kemp) I had built and was managing a web site that takes registrations from thousands of people around the state for a variety of sporting events. One of the goals of the site is to collect better quality data for the people running the events, i.e. they basically needed to get a better han
Microsoft – SQL Server – Bulking Copying data using XML Template File
(Daniel Adeniji) Preparing to perform a bit of load test against MS SQL Server. And, so downloaded spawner, a MS Windows desktop application that allows one to generate test data.
Retrieving and changing SQL Server Database Properties AutoShrink
(Faiz Farazi) Auto Shrink needs to be kept false (off) for the user databases. True option will shrunk the database files automatically. If the free space of the database files is more than 25 percent. If the shrinking of database files occurred it will affect the data position. That’s why this opti
My First Custom View Helpers
(Summer S. Wilson) As I’ve been going through building my app for the Practical Learning series, one thing that has been bugging me is the way we had to prepend/append the individual divs for each form row item in our forms. It seemed to be a great way to introduce errors and inconsistency in our u
Simplifying Oracle Database Migrations
(Danny Arnold) As part of my role in IBM Information Management, as a technical advocate for our DB2 for LUW(Linux , Unix, Windows) product set, I often enter into discussions with clients that are currently using Oracle Database.
The DB2Night Show #134: DB2 LUW INGEST Utility with Mark Gillis, Triton
(Scott Hayes) 18% of our audience was running DB2 LUW V10.5 in production and 45% of our audience was running V10.1 in production. The INGEST Utility became available in V10.1 as a client side utility, yet 0% of our audience today was using it.
Update XML File using PowerShell
(Sonam Rastogi) There are many blogs on internet already speaking about updating XML files in PowerShell, but I felt need of one consolidated blog where complex XML files can also be updated with long complex Hierarchy of XML nodes and attributes.
jQuery UI Autocomplete in MVC 5 – selecting nested entity
(morzel) Imagine that you want to create edit view for Company entity which has two properties: Name (type string) and Boss (type Person). You want both properties to be editable. For Company.Name simple text input is enough but for Company.Boss you want to use jQuery UI Autocomplete widget*. This w
EntityLevelOnly Property To Delay Unique Key Validator
(Andrejus Baranovskis) Idea for this post was kindly suggested by real ADF BC guru and evangelist – Steve Muench. You can check famous ADF Not Yet Documented Examples on Steve’s blog – Dive into ADF.The main idea is about composite Unique Key, based on multiple EO attributes.
