(Ged Mead) Back in this post, I introduced the DataView. You saw there that you can find individual rows by using the Find method. In addition to this, you have the option to find multiple rows in a DataView very easily by using the FindRows method.
Author: SSWUG Research
WPF Information Controls – StatusBar
(Richard Carr) The forty-third part of the Windows Presentation Foundation Fundamentals tutorial looks at a further WPF information control. This article describes the StatusBar, which displays messages and progress details in a horizontal strip.
Watch out for SQL Server 2012 licensing pitfalls
(Kurt Mackie) As agencies migrate to the cloud, consolidate their data centers and add ever more end-user devices to the enterprise network, reviewing and renewing licensing agreements has become increasingly important.
Comparing Tables In Power Query
(Chris Webb) An interesting Power Query nugget for you: you can compare two tables using the Value.Equals() function. For example, take the following worksheet with five Excel tables on it:
How to Run DDL in PL/SQL
(Andrew Reid) This was tested on Oracle 11.2. You cannot run DDL directly in PL/SQL. If you try, you get an error:
Setting Up BCS Hybrid Features End to End In SharePoint 2013
(Steve Peschka) For those of you who will be attending SharePoint Conference 2013 (www.sharepointconference.com), I’m going to be teaching a half-day course after the three main days with Bill Baer and some other folks on SharePoint Hybrid features.
DBA Rules of Thumb – Part 10 (Keep Up-to-Date)
(Craig S. Mullins) If you wish to be a successful DBA for a long period of time, you will have to keep up-to-date on all kinds of technology — both database-related and other.
The DB2Night Show #122: BIG DATA – What does it really cost?
(Scott Hayes) 97% of our studio audience learned something! During this episode of The DB2Night Show™, Richard walked us through a brilliant analysis method for computing the cost of BIG DATA and shared with us some interesting examples and case studies.
Oracle Restart – going , going , gone?
(John Hallas) Oracle restart is an 11GR2 feature which ensures that all services on a standalone installation start up in the correct order. As such it seems to work well. One bugbear I have with it is that it changes the order of entries in the /etc/oratab file.
Dimensional Modeling in Oracle SQL Developer Data Modeler
(Jeff Smith) Oracle SQL Developer Data Modeler (SDDM) is a free data modeling solution. It supports many types of modeling levels, including: