(Brad_Davis) Angular.js, a JavaScript library and framework created in Google, is a fresh view into building great web applications. You can read a lot of articles on how it separates the concerns of the application, improves testability, and keeps to web app best practices, but I want to highlight
Author: SSWUG Research
Processing HTML5 in an XML Pipeline
(Phil Fearon) My last blog post was about HTML5 Compare, an online comparison tool for HTML5. The comparison process we used for this relies on an XML pipeline built around DeltaXML’s Core product. In this blog post I describe the solution we used for parsing HTML5 for the pipeline input and seriali
IBM DB2 Certification – Why it is Worth it
(Ember Crooks) A friend recently asked me what I thought of certification. I have a number of DB2 related certifications, and even one Oracle certification. I thought I would share my opinions.
The future of ALTER IGNORE TABLE syntax
(Morgan Tocker) As part of the ongoing effort to refactor MySQL and make it better, we are defining the behaviour of certain features and in some cases reimplimenting them in a more maintainable fashion.
Entity Relationship Diagrams
(Mike Chapple) Entity Relationship diagrams (also known as E-R or ER diagrams) provide database designers with a valuable tool for modeling the relationships between database entities in a clear, precise format. This industry standard approach uses a series of block shapes and lines to describe the
Audit : How to track logins getting dropped in SQL Server?
(GauravSrivastava) Tricky!! This is what I can say when I started troubleshooting the issue when suddenly the logins were getting dropped and no one had a clue what’s going on since no one from the DBA team would go ahead and drop the logins. However, SQL 2008 and above have this beautiful feature c
Setting Up Alerts for Long-Running Transactions
(Michael K. Campbell) The code below is something you can use to easily set up an alert for long-running transactions:
Master Data Services stops working after an upgrade
(Koen Verbeeck) Recently some SQL Server instances at a client were upgraded to the latest cumulative update of SQL Server 2012 service pack 1. The reason for this update was the added functionality to create Power View reports on top of Analysis Services Multidimensional.
Windows Azure SQL Database Backup and Restore strategy
(Arshad Ali) Microsoft offers Windows Azure SQL Database as a cloud based SQL Server service offering. Though it has built-in features to protect data from server, network and device failures (reducing overhead for setting up and ensuring disaster recovery) in certain cases you still need to protect
Handling Record Contention in Code-First Entity Framework
(Peter Vogel) This column is really a follow-up to one that I did in 2009. In that column, I discussed strategies for handling two users updating the same row in a table when using Entity Framework (one strategy is “Don’t worry about it”).