(Gunnar Peipman) My previous post about Web API content negotiation showed how to add support for new content formats. As our API may have consumers who prefer query for data using GET requests we have to offer something for these dudes too. In this post I will show you how to make life easier for o
Other News
Concept of Exists Condition in SQL Server
(Rohatash Kumar) This article shows how to use the EXISTS condition in SQL Server. The EXISTS condition is used to check if the row exists or not in the table. EXISTS queries are very inefficient since the sub-query is re-run for every row in the outer query’s table. In this article we define both c
mySQL Partitioning summary and what to watch out for
(Dathan Pattishall) I have been looking for efficient ways to purge data from “Fast Disks” for applications that are time based and do not look at data after a time window has passed. For instance keeping a table where one stores log data from access logs and the data is okay to roll up the data and
Using JEditable plugin as ASP.NET MVC3 jQuery inline editor
(Jovan Popovic) You have probably seen a new HTML5 feature called contenteditable. It enables you to edit any element in HTML using the inline editor. The only thing you will need to do is attach some event handlers that will be called when editing is finished and send the new content to the server-
Use concurrent I/O to improve DB2 database performance
(Jeyabarathi Chakrapani) Concurrent I/O is a feature that was introduced in UNIX and Linux platforms mainly for the benefit of relational database systems. This article explains the difference between the I/O mechanisms available with UNIX and Linux file systems, and shows how concurrent I/O technol
Skills You are Going to Need
SSWUGtv With Stephen Wynkoop In today’s edition of SSWUGtv, Steve interviews Paul Zikopoulos. Wach as Steve discusses Querying big data stores and declaritive languages for working with big data. Hear IBM’s new approaches and ideas… Watch the Show Skills You are Going to Need Today, in response to an Email from Srini I am brainstorming on skills that are necessary […]
SSWUGtv News – LinkedIn, eHarmony what it means for DBAs, interview tips, Google and more news from the week.
Video Programming for IT Professionals
Contained Databases in SQL Server 2012
(Dinesh Asanka) Contained Databases have been an oft requested feature which has finally arrived in SQL Server 2012. In prior SQL Server versions, database were not 100% portable. In case you need to move a database from one server to another using backup and restore, the data in the database will o
External Xslt link breaking web parts
(Ami) When you are using Xslt List View Web Parts there are cases where you might want to use an external Xslt style sheet (instead of hard-coding it in the web part itself.) In most cases this works fine but sometimes just after editing the web part you get an error message and the web part is brok
Typed XML vs UnTyped XML
(Shamas Saeed) XML stands for EXtensible Markup Language. XML tags are not predefined. You must define your own tags. It is used so much in web designing and managing structure and data. XML introduced in SQL server as well to manage extensive data with your specific structure as you can define rela