(Chris Webb) Back in September I wrote a post on handling situations where the data source for your Power Query query was unavailable.
Other News
SQL Server Reporting Services Basics: The Visual Controls
(Kathi Kellenberger) The challenge of report development is to present complex data in a simple, visually compelling way. The goal is to make it as quick and easy as possible for others in the organization to use that data to make decisions, to see progress towards a business target, or spot and act
A Pattern for Sharing Data Across Domain-Driven Design Bounded Contexts, Part 2
(Julie Lerman) In the October 2014 Data Points (msdn.microsoft.com/magazine/dn802601), I wrote about a pattern for mirroring data from one database to another when you’re using multiple Domain-Driven Design (DDD) bounded contexts (BC), with each BC isolated to its own database.
Arrow Function In ES6
(K. Scott Allen) JavaScript has always been a functional programming language. You can pass functions as arguments to other functions, and invoke a function that returns a function back to you. The ES6 standard improves JavaScript’s functional programming capabilities by offering a new, succinct syn
Reference Architecture: System x Solution for IBM DB2 with BLU Acceleration on X6
(Shang-Min (Allen) Wei, Jon Lind, Jessica Rockwood, Rahul Agarwal, Doug Petteway and Ajay Dholakia) Enterprise data warehouses (EDWs) store data that is used primarily for business intelligence, analytics, and other reporting requirements. Today’s business analytics demands higher performance from d
Fun with eConnect and .NET decimal rounding
(Steve Endow) There are some situations where you need to import transactions into Dynamics GP, where the source data contains line item totals that need to be broken down before being imported into Dynamics GP.
Events in C#
(Krishna Vamshi Goud) C# is an Object-oriented programming language. C# comes with simplicity, expressiveness and great performance to meet the programmer productivity.
Analyzing Historical Performance Data – Important Reports
(Lockwood Lyon) Often the DBA must react to production performance problems. The DBA should have a good working knowledge of the following:
A Data Quality Initiative
(Craig S. Mullins) As regular readers of this blog know, I sometimes share answers to questions I get via e-mail (and other avenues). By doing so I can hopefully expand on the audience participating in the discussion…
Modern Database Security
Most database engines have some form of security built in. The security is designed to authenticate the client credentials and to grant or revoke rights against the database objects. Most engines have schemas owning database objects to which users are assigned. Encryption is sometimes included in the engine to product the database contents under different circumstances. Years ago I used […]