(Thomas LaRock) I found this question over at DBA StackExchange the other day and it left me shaking my head. How is it possible that there is no way to automatically recycle, or reset, the SQL Server Analysis Services (SSAS) error log in a similar manner to SQL Server? After all, it’s not like the
Other News
Centralize Your Database Monitoring Process
(Dennes Torres) SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keeping an eye out for problems. It comes into its own when you have figured out how to co
ASP.NET Web Api 2.2: Create a Self-Hosted OWIN-Based Web Api from Scratch
(John Atten) Building up a lean, minimal Web Api application from scratch is a terrific way to become more familiar with how things work under the hood in a Web Api (or any other ASP.NET) project.
12 Unit Testing Myths and Practices
(Eli Lopian) This article presents the most widely misunderstood concepts about unit testing today and provides relevant information about how the practice actually occurs.
Experimenting With ngModel And ngModelController In AngularJS
(Ben Nadel) For the last few years, I’ve happily consumed the ngModel directive, in AngularJS; but, I’ve never really thought much about what it does – it just worked. But, ngModel does a lot – way more than I actually use it for, currently.
WPF Shapes – Path – Arc Segments
(Richard Carr) The one hundred and twenty-eighth part of the Windows Presentation Foundation Fundamentals tutorial continues to look at path geometry and the available segment types. This article explains how to include elliptical arcs in a Path.
SQL SERVER – Finding Tables Created Last Week – DBA Tip Part II
(Pinal Dave) When I wrote my previous blog post on SQL SERVER – Finding Tables Created Last Week – DBA Tip, lesser did I know something as simple as this can become such an interesting topic of conversation. I have been overwhelmed with the number of emails I have got in the past week to know more a
The DB2Night Show #147: DB2’s GOT TALENT – LUW Auditions
(Scott) 94% of our studio audience learned something! Today’s presentations were surprisingly good considering that we had contestants from New Zealand, Mexico, and India! It fascinates me that we can gather around our computers and learn from industry peers all over the world.
Helping Out the DB2 Optimizer Using the VOLATILE Keyword
(Craig S. Mullins) Do you know about the VOLATILE keyword? This keyword was added to DB2 for z/OS back in Version 8. It can be specified on a table using either the CREATE TABLE or ALTER TABLE statement.
CQRS Database Implementation
One database optimization solution is to duplicate a database, or a portion of it, when the database supports both online processing and reporting. The basics of the practice is to have two databases, essentially the same. All data entry is made into the OLTP instance of the database. All of the create, update and delete actions are replicated into a […]