(Tim Ford) The Template Explorer is a little known tool inside the SQL Server Management Studio (SSMS) IDE. It allows you to store custom scripts, parameterize them for re-use and have them at your fingertips without ever having to leave SSMS. Previously, we looked at how you gain access to the Temp
Other News
Rethinking DOM Traversal
(Brian Rinaldi) In web development, as in life, sometimes we develop patterns in how we think about a topic or achieve a common task. This is necessary, as to do otherwise would waste a lot of mental cycles on trivial problems we’ve already solved.
DB2 for i 7.2 Features and Fun, Part 1
(Michael Sansoterra) The dump truck of database features driven by IBM is delivering yet again, unloading a full load of great enhancements for the beloved DB2 for i RDBMS. In addition to the new features included in the various IBM i 7.1 technology refresh (TR) releases, 7.2 has even more security,
Understanding DB2 Object Privileges, Part 2
(Roger Sanders) In DB2 for Linux, UNIX, and Windows and DB2 for z/OS, object privileges convey the right to perform certain actions against specific database objects. Part 1 of this series reviewed DB2’s authorization ID, buffer pool, table space, storage group, schema, table, view, and index privil
MVC 5 with EF 6 in Visual Basic – Updating Related Data
(Mike Brind) This tutorial is the eighth 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 displayed related data; in this tutorial you’ll update related data.
Windows 7 Compatibility Mode
This is probably old news to you. I didn’t know that running a program under Windows 7 Compatibility mode was actually running a virtual Windows XP session, separated from the Windows 7 operating system. A friend recently brought this to my attention and I went to learn more. You can find a lot of information about Windows XP running as […]
SSWUGtv Security Edition: Encrypting data for higher education institutions with Steve and Patrick Townsend.
Video Programming for IT Professionals
Understanding Business Intelligence
Understanding Business Intelligence Though Business Intelligence is technology driven, it is more about Business requirements and less about technology. BI Champion/ Sponsor in the organization defines the vision and mission. The leader must have the ability to precisely define the Business intelligence requirements of the organization; the format of the reports; the relationship between the different data elements and version...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Shedding Tiers: Stop Thinking in Terms of Layers
(Peter Vogel) Now that the Entity Framework (EF) has replaced almost all of what used to be called the data access layer (DAL) — code that converted rows into objects and converted changes to objects into SQL statements — it’s odd to find designers still trying to define part of their application
An XQuery-based Model Transformation Language
(Jesús J. López Fernandez) In this paper we propose a framework for model transformation in XQuery. Our proposal aims to provide the elements for using XQuery as a transformation language. With this aim, our framework provides a mechanism for automatically obtaining an XQuery library for a given met