(Tim Ford) I’m starting to get interested with the Dynamic Management Views in Microsoft SQL Server. What kind of information can I collect from the sys.dm_os_sys_info DMV?
Other News
Characteristics of a Architectural DBA
Find Out What’s New at SSWUG SelecTViews Check out this week’s SelectTViews So much data, so many databases…to the moon! Cloud exit strategies, cloud security considerations, wireless access to data… Jeopardy!(tm) ….and the SSWUG Virtual Conference, Bus. Intelligence Upgrade hesitations and much more. $$SWYNK$$ Featured Article(s) Top Ten Database Blunders (Part 1 of 4) As a PTO (Performance, Tuning, and […]
CICS meets XML: Using CICS Web Servives with DB2 pureXML
(Matthias Nicola) Ok, the readers who are not from the mainframe world may wonder what “CICS” means. According to IBM’s official web site, CICS is defined as follows: “CICS (Customer Information Control System) is a family of application servers and connectors that provides industrial-strength, onli
Getting JSON Out of WCF Data Services
(Glenn Gailey) I was working with Ralph and a few other folks in my team on an internal project that required us to pass an OData feed from our own Windows Azure-hosted WCF Data Service to Windows Azure Marketplace DataMarket.
Programming ADO.NET Entity Framework 4.0, Part 1
(Joydip Kanjilal) There are plenty of Object Relational Mapping tools available now. You have nHibernate, LINQ to SQL, Entity Spaces, and what not. The ADO.NET Entity Framework is an extended Object Relational Mapping Tool from Microsoft that has over the past few years become increasingly popular a
Creating an Action
Learn how to add a new action to an ASP.NET MVC controller. Learn about the requirements for a method to be an action.
Advanced replication for the masses – Part II – Parallel replication
(Giuseppe Maxia) I hope you liked the first part of this series of lessons. And I really hope that you have followed the instructions and got your little replication cluster up and working.
Bulk CRUD Operation using XQuery and Reflection in ASP.NET
(Shahriar Iqbal Chowdhury) In database terms, CRUD stands for the four essential database operations: Create, Read, Update and Delete. Regardless of the diversity of applications, most real world applications are data centric, more precisely CRUD centric. At some point, a huge amount of data from th
SQL Arrival Patterns and Impact
(Craig Shallahamer) If you have been following my recent posts and especially the post about SQL statement elapsed times, you’ll know that unfortunately SQL statement elapsed times do not conform to a normal, poisson, exponential, or even a log normal distribution.
Alpha 4 of the next version of DB2 quietly slips out in to the wild
(Leon Katsnelson) You don’t have to be a genius to guess that IBM is hard at work on the next version of its DB2 database product. And it would not be a big stretch to imagine what there is probably some sort of an alpha/beta program in place. OK, both points are true. As a matter of fact, the Early