(Bhushan W. Juare) In this article we will see the different ways of retrieving XML data from SQL Server.
Author: SSWUG Research
Practical P_S: Extending PROCESSLIST
(Todd Farmer) MySQL 5.6 introduced major advances to monitoring made via PERFORMANCE_SCHEMA, but also made a change in how it binds to the network by default. In MySQL 5.5, the ¨Cbind-address configuration option defaulted to ¡°0.0.0.0¡å, meaning only IPv4.
System.Xml ImportNode and the .NET Heap(s)
(The Reeds) If you work with XML in .NET a lot, you have probably bumped into a scenario a few times in your career where you need to move or copy some XML fragment out of one document and into another.
AngularJS Drag and Drop Photo Directive
(K. Scott Allen) Continuing from previous posts on building a file input directive and a file reader service, this post contains my first try at a drag-n-drop directive that uses the file reader service to copy an image dropped from the desktop into an img element.
SQL – Agile Software Development Methodology vs Waterfall Software Development Methodology
(Pinal Dave) If you are in the process of developing and creating software, a business, or product, the steps to get from point A – the idea – to point B – the finished product – can seem completely overwhelming.
Oracle Database 12c: PGA_AGGREGATE_LIMIT
(Marco Gralike) There is a new default in town. Mark my words, you will encounter the following during your 12c life-cycle…
Local and Global Temporary Tables in SQL Server 2008
(Sachin Kalia) In this article I am sharing my experience with Temporary Tables in SQL Server 2008.
Security Questions: Removing Logins From Databases
(Jason Strate) As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to p
IBM DB2 NoSQL for JSON Setup
(Vineeth George Abraham) A quick guide on setting up DB2 10.5 for JSON, using the DB2 Tech preview.
Avoiding Lock Contention
(Troy Coleman) Having spent many years tuning batch applications and designing systems that could simultaneously run batch and online applications, I’ve learned quite a bit about locking and how to avoid it.