(Gary Myers) Sometimes you are working with an off-the-shelf product and find something odd, and you’re not quite sure whether it is a bug, a feature or whether you’ve lost the plot.
Other News
Using List.Generate() To Make Multiple Replacements Of Words In Text In Power Query
(Chris Webb) Recently I had a request for help from someone who wanted to do the following in Power Query: take a piece of text and then, using a table, search for all of the occurrences of the words in one column of the table in the text and replace those words with those in the other column.
MVC 5 with EF 6 in Visual Basic – Sorting, Filtering and Paging
(Mike Brind) This tutorial is the third in a series of 12 which teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. This tutorial explores how to add sorting, filtering and paging to MVC 5 Views using the Entity Framework. You will also look at implemen
Increase DB2 availability
(Stephen Holt and Steve Raspudic) This article demonstrates how to use a cloud provider to create a reliable tie-breaking method to avoid a split brain scenario. The procedure is for two node clusters running IBM DB2 for Linux, UNIX and Windows (LUW) and the integrated high availability (HA) infrast
WPF Selection Controls – Slider
(Richard Carr) The seventy-third part of the Windows Presentation Foundation Fundamentals tutorial looks at the last of the WPF selection controls. This article describes the Slider, which lets users select a value from within a fixed range.
Inspecting Attribute-Normalization Within Directives In AngularJS
(Ben Nadel) This is a small but rather important post. I never noticed this before, but the attributes collection, that gets injected into the compile and link functions in an AngularJS directive, contains an “$attr” object. This object maps the normalized attribute names onto the attribute names us
On Becoming a DBA
(Craig S. Mullins) One of the most common questions I am asked is: How can I become a DBA? The answer, of course, depends a lot on what you are currently doing. Programmers who have developed applications using a database system are usually best-suited to becoming a DBA. They already know some of th
SQL Server – Script to Identify and Update Database Auto-Growth Setting
(Hareesh Gottipati) An auto-growth event is the process by which the SQL Server engine expands the size of a database file when it runs out of space. The amount by which a database file should grow is determined by the value that is set in the SQL configuration.
SQL SERVER – In-Memory Databases and Caching Wars
(Pinal Dave) The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!
Computed Columns
Today I wanted to brainstorm on some of the uses for computed columns in SQL Server. When the computed column is created it can either be persisted or dynamic. The kind you use is determined by the purpose of the computed column. Sometimes we like to track the birth date of a person, or some significant date. Then we want […]