(stewashton) We often use NULL values in date ranges, usually in the end date to signify the indefinite future. I have decided that this is a bad idea; here are my reasons.
Other News
How to get the DB2 database free space?
(Jack Vamvas) Question: Where can I find information for the DB2 database free space with automatic storage in use?
Create a dropdown list from an Enum in Asp.Net MVC
(Paul Davies) A common situation you can find in MVC, is to have an Enum in your model and want that rendered as a dropdown list in the browser.
Angular and ASP.NET MVC: when to use which golden hammer
(Peter Morlion) In my previous post, I outlined how to use ASP.NET MVC and Angular together, making certain views pure MVC and others Angular.
Converting JSON to XML to Java Objects using XStream
(anirudh bhatnagar) XStream library can be an effective tool for converting JSON to Java to XML translations to and fro.
Database Backups for Peace of Mind: Part 1
(Isaac Yassin) “Backup equals insurance” is a motto that should be prominently displayed on the office wall of every database administrator (DBA). A backup copy of data is not made just to have it, or to check off an item on a checklist, or because it is written
SQL SERVER – Activity Reports – Dormant Sessions
(Pinal Dave) With schools starting for my daughter, I rarely get involved in her daily routine activity. But there is one thing that I don’t try to miss – the parents-teachers meet. Sometimes it is not about the report card on how my daughter faired against the rest in the class but it is more than
An Open/Closed TSQL Approach
Today Aaron shares his implementation for applying the open/closed principle to SQL Server data and code. As stated previously it is more difficult to introduce a static set of parameters in SQL because TSQL does not support interfaces or inheritance. The primary point of interfaces is that you can implement them in many different ways and still keep the contract […]
Modifying the Default SQL Script in Management Studio
(Tim Ford) OK, a show of hands everyone. . . tell me how many of you have run a query against the wrong instance. . . oh, and when I say wrong I mean W-R-O-N-G. We’re talking take-down-production-and lose-data-wrong. Come on, don’t be shy. Don’t lie to me. I can tell when you’re lying. You’re about
Walkthrough: Attaching an Azure SQL database to your .NET Backend
(Jeff Sanders) I needed to attach an existing Azure SQL database to my .NET Backend. This will allow me to expose existing data using the Azure Mobile Service I have defined. This will walk you through the steps I took and get you on your way!