(Peter Vogel) Once you’ve delivered server-side objects to your client, you’re going to need to manage them. Here’s how to integrate a powerful client-side (and server-side) object manager into your application using TypeScript.
Author: SSWUG Research
Making strict sql_mode the default
(Morgan Tocker) MySQL has sometimes faced criticism for being too relaxed at allowing invalid values, or inserting but truncating values that are out of range. For example:
Preventing Overlapping Ranges in SQL Server
(Richard Carr) In some scenarios it is necessary to store ranges in a table in SQL Server. If those ranges should not be permitted to overlap, this can be prevented using a combination of constraints and a trigger.
Migrating from Sybase to DB2, Part 1: Project description
(Luc Vandaele) This article describes the processes and techniques used to migrate trigger code from Transact SQL (Sybase) into SQL PL (DB2). Part 1 describes the intended goal and scope of the project. Part 2 talks about the considerations and challenges we had to overcome to make the database vend
SQL SERVER – Fix – Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
(Pinal Dave) Earlier this week, I was on vacation and did not check my emails for three days and when I returned, I found six different emails from 4 different people asking for the same problem.
DB2 11 SQL Performance Improvements
(DAVE BEULKE) DB2 11 for z/OS SQL performance improvements help make your applications go faster. DB2 11 also helps address some of the latest coding problems provided by the latest Java and other development coding.
How To Backup a SQL Server Database including Data
(Ged Mead) In an earlier post I described various ways you can automatically make backups of a SQL Server database. But if you have SQL Server Management Studio installed and you want to do this manually, you can have quite a lot of control over what is and isn’t backed up. The way to do this is n
The Newest Fiddle Sibling : .NET Fiddle!
(Rion Williams) Earlier this year, I wrote a short post that covered different tools that you can use from the comfort of your favorite browser to help create examples, prototypes and just tinker in general. This post serves to introduce the newest member of the Fiddle family of tools (which surpris
Different ways of rendering layouts in Asp.Net MVC
(Shailendra Chauhan) In Asp.Net MVC, Layouts are like as Master Pages in Asp.Net Web Forms. These helps us to maintain consistent look and feel across all the views within your Asp.Net MVC application. Like Master Pages, Layout may contains common CSS, jQuery files across the multiple Views and one
DBA Rules of Thumb – Part 11 (Invest in Yourself)
(Craig S. Mullins) Most IT professionals continually look for their company to invest money in their ongoing education. Who among us does not want to learn something new — on company time and with the company’s money? Unless you are self-employed, that is!