(Ember Crooks) I first want to share a few things that stood out this year.
Author: SSWUG Research
SQL Server Performance Comparison – Storing XML data in-row versus out-of-row
(Ben Snaidero) Over the last few years I have seen more and more cases where we need to store XML data in the database. This tip will take a look at the performance impact, if any, of storing XML data in-row with the rest of the data that make up the table record vs. out-of-row where only a pointer
ORA-01086
(Andrew Reid) You can only rollback to a savepoint if it was created in the current transaction. You can see this in the example below, which I tested on Oracle 11.2:
What are those numbers you see at the top corners in VS2013?
(Ged Mead) When I started using Visual Studio 2013, I noticed that some numbers kept appearing at the top left and top right corners of the Window when I ran the app in Debug mode. Something like this:
SQL Server Integration Services (SSIS) Inline Documentation Methods
(Scott Murray) What methods can be used to document and sequence SSIS packages, connections, and tasks “inline” just as we do our SQL Code?
JSON’s Eight Year Convergence With XML
(Adam DuVander) The XML vs. JSONs lighter approach has proved popular2009, but that JSON has been rising for the last eight years.
Commentary on MySQL slow query collection sources
(Morgan Tocker) The other day it struck me that MySQL applications have no fewer than four sources to be able to collect potentially slow queries for analysis, and that I actually find myself using 3/4 methods available.
My Processors Can Beat Up Your Processors!
(Bill Cole) I grew up a fan of Formula 1 and the Indianapolis 500. One of the great F1 racers was a British fellow named Sterling Moss. Look him up. Won lots of races for Mercedes-Benz and then went back to England and drove only British marquees. They were underpowered but he still won races.
Readable Code for Modify_Snapshot_Settings
(Jeremy Schneider) It annoyed me slightly that when I googled modify_snapshot_settings just now and all of the examples used huge numbers for the retention with (at best) a brief comment saying what the number meant.
Obtaining the Number of Logical Processors
(Richard Carr) There are several ways in which to determine the number of logical processor cores in a computer, including using standard members of the .NET framework or Windows Management Instrumentation queries. This article uses the Environment class.