(Craig S. Mullins) We all can relate to dealing with systems that have data integrity problems. But some data integrity problems can be cleaned up using a touch of SQL. Consider the common data entry problem of extraneous spaces (or blanks) inserted into a name field.
Other News
MDX Solve Order, SCOPE_ISOLATION and the Aggregate() function
(Chris Webb) Solve order in MDX is a mess. Back in the good old days of Analysis Services 2000 it was a difficult concept but at least comprehensible; unfortunately when Analysis Services 2005 was released a well-intentioned attempt at making it easier to work with in fact ended up making things muc
Get Ready to Learn SQL Server: 16. Combine Table Rows Using UNION
(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. You can get started using these free tools using my Guide Getting Started Using SQL Server.
Setting RingTones with Windows 8.1
(Hannes DuPreez) Start Visual Studio 2013 and create a new Windows Phone VB application, by clicking File, New Project, Windows Phone Apps, Blank App, as shown in Figure 1:
WPF Data Display Controls – ListView
(Richard Carr) The one hundred and sixth part of the Windows Presentation Foundation Fundamentals tutorial returns to the topic of the WPF controls. This article looks at ListView, which is the first of the data display controls.
How to Integrate Visual Studio with Github Repository
(Mitesh) This articles describes how to integrate visual studio with github repository and commit your local changes to github repository.
Structured-Filter – a jQuery UI Widget for building structured queries
(Olivier Giulieri) Structured-Filter is a generic Web UI for building structured search or filter queries. It is a full jQuery UI widget, supporting various configurations and themes.
InfoSphere Guardium and the Amazon cloud, Part 2: Secure storage on the cloud for backup and restore
(Azadeh Ahadian, Dario Kramer and Indrani Ghatare) The growing number of relational databases on the cloud accentuates the need for data protection and auditing. InfoSphere Guardium offers real-time database security and monitoring, fine-grain database auditing, automated compliance reporting, dat
Microsoft SQL Server 2012 Internals: Special Storage
(Kalen Delaney and Craig Freeman) This chapter from Microsoft SQL Server 2012 Internals looks at how SQL Server stores data that doesn’t use the typical FixedVar record format and data that doesn’t fit into the usual 8 KB data page.
Open source jQuery mobile x-platform template for your use
(David Voyles) I wrote this Cordova app last year for a game studio that some friends run a game studio in Seattle, called Ska Studios. I had the app sitting around, so I figured I’d write a detailed readme and post it to GitHub, so that students can use it as a template for their projects.