(Arshad Ali) There are different techniques to optimize the performance of SQL Server queries, like keeping required and updated statistics, creating required indexes, partitioning tables, etc., but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries
Other News
The New IBM z13 Mainframe: A DB2 for z/OS Perspective
(Robert Catterall) Last month, IBM announced the z13 — the latest generation of the mainframe computer. The z13 is chock full of great technical features, and there are already plenty of presentations, white papers, and “redbooks” in which you can find a large amount of related information.
The Big Data DBA — Big Data in the 21st Century
(Lockwood Lyon) Big Data today is different in many ways. We are now faced with new and complex data types (large objects, or LOBs), self-describing data (XML) and multi-structured data (images, audio, video, click-streams).
Stateless Filters Don’t Apply To Objects, Arrays, or ngRepeat In AngularJS 1.3
(Ben Nadel) In the past, I have talked about my dislike for Filters in AngularJS. Not only do they have a performance concern, they also make it harder to manage the state of the View as filtering is applied to collections (ex, ngRepeat).
Generators in ECMAScript 6
(K. Scott Allen) You’ll know you are looking at a generator, or more properly, a generator function, because a generator function contains an asterisk in the declaration.
Visual Studio Online with Git
(Subodh Sohoni) TFS and Visual Studio Online (VSO) have embraced Git as one of the default options for version control while creating a new team project. In this article, I will attempt to explain the concepts of Git as implemented by TFS / VSO.
The info in OTHER_XML of view DBA_HIST_SQL_PLAN
(Marco Gralike) I had some time to spend, killing time, and thought about something that was “on my list” of things to do, to investigate, for a long time.
Control Class ToolTip During Debugging
(Peter Vogel) You’re debugging some code and you need to know the value of a string variable. You move your mouse over the variable and — voila! — a tooltip appears showing the value of the string.
Index Merging
Index merging is an implementation strategy in an SQL Engine, enhancings query performance when no single index is available to resolve the requirements of a query. Index merging is really pretty simple. It works a lot like joining two different tables. Since an index is much like a table, it can be utilized in a similar fashion. Let’s use an […]
SSWUGtv: Laura Rose discusses how to work successfully with someone you hate.
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.