(Jeff Smith) Yesterday was regular expression day. I got asked by three different people about regex search options in SQL Developer. One of those wanted to know how to use them in the Data Modeler.
Other News
Parallel Isn’t Always the Best
I’ve been talking a lot about parallel programming as the way to more fully utilize contemporary computers with multiple cores. Today I wanted to qualify those statements a bit. The main point I wish to make today is that even though you can generate parallel execution much easier today with new libraries, it is possible to actually slow down your […]
Tips for using indexed views in SQL Server 2014
Tips for using indexed views in SQL Server 2014 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Avoid creating indexes on a...
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
SQL SERVER – Row Offset in SQL Server For Different Version
(Pinal Dave) A very common question is how to find row offset in SQL Server. Here are a few examples based on different version of SQL Server. I have included SQL Server 2000 event, though it is almost 15 years old product and I encounter is less and less every day on production server.
Building IBM Enterprise Content Management Solutions From End to End
(Wei-Dong Zhu, Ben Davies, Isuru Fernando, Blair Groff, Sven Hapke, Abraruddin Khan, Johnson Liu, Josemina Magdalen, Yuki Makino and Mike Prentice) IBM Enterprise Content Management (ECM) solutions provide efficient and effective ways to capture content, manage the content and business processes, di
WPF Data Display Controls – TreeView – Basics
(Richard Carr) The one hundred and seventh part of the Windows Presentation Foundation Fundamentals tutorial begins to examine the TreeView control. This control is used to display hierarchical data.
Individual Firebase References Don’t Store Unique Event Bindings
(Ben Nadel) After my exploration this morning, on the data synchronization behavior in Firebase, I started to wonder about the relationship between unique Firebase instances and event bindings. Specifically, how do event bindings on one instance affect the event bindings on another instance.
ASP.MVC Real-time data processing with Sharded RavenDB and SignalR
(Tariku Tessema) In a move that some call “Radical” The Weather Channel recently swapped their enterprise Oracle and MySql Databases for NoSQL MongoDB. One word that could describe the rapid adoption of NoSQL databases compared to relational once is “sharding.”
JsonResult Type in MVC
(Ramchand Repalle) This article will provide you an idea of JsonResult, JsonResult Properties, the use of JsonResult with various scenarios and how can you test the JsonResult by using Test Project in a MVC application.
Edit and Query documents through the Azure portal
(Stephen Baron) We’ve released a number of great enhancements to further improve the DocumentDB management experience