(Ember Crooks) This was really a revelation for me when I took DanL‘s SQL workshop before the IDUG conference in Phoenix.
Other News
Importing Into MySQL from Other Databases
(Rob Gravelle) Your data may originate from many sources, from an application, atom feed, or even from another database. In the first two cases, you have application code and/or stored procedures processing the data; importing directly from another Database Management System (DBMS) can be accomplish
What does it mean that a value is NULL?
(Kenneth Fisher) Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be going over that in some detail in a future post.
How to restore MSDB & MODEL database – SQL Server System Databases?
(Rohit Garg) The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. Issues in MSDB restore that may result loss of all scheduling information, as well as the backup and restore history
Creating Cool WPF Charts using the ModernUI Chart Library and WebAPI
(Mahesh Sabnis) WPF has a rich charting and graphical capability, however it is time-consuming to build your own charts from groundup. The ModernUI chart library is a free handy library which allows you to quickly display some statistical data in a graphical form. This article shows how to use this
TechTip: New Function Resolution Casting Rules for DB2
(Kent Milligan) My recent article on the DB2 for i 7.2 release highlighted some of the more noteworthy database enhancements in the latest IBM i release. There wasn’t room in the previous article to discuss all of the DB2 enhancements, so in this article you’ll learn about a smaller DB2 improvement
New: ASP.NET Session State Provider for SQL Server In-Memory OLTP
Microsoft SQL Server 2014 brings new performance and scalability gains by introducing In-Memory OLTP. In-Memory OLTP contains tables and indexes optimized for in memory. Transactions execute under lock-free algorithms to provide linear scalability and Transact-SQL stored procedures can be compiled
SQL SERVER – Documentation Tool
(Pinal Dave) This article explains how to use ApexSQL Doc, a SQL documentation tool. You can download ApexSQL Doc, and follow along with this article.
How To Refactor for Dependency Injection, Part 2: Composition Root
(Ondrej Balas) Building upon my article from last month, “How To Refactor for Dependency Injection,” I’ll continue the discussion by focusing on a common design pattern called composition root.
MVC 5 with EF 6 in Visual Basic – Implementing Inheritance
(Mike Brind) This tutorial is the eleventh in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorial you handled concurrency exceptions. This tutorial will show you how to implement inheritance in the data model