(Blaise Doughan) In a previous post I introduced EclipseLink JAXB (MOXy)’s @XmlVariableNode extension. In this post I’ll demonstrate how @XmlVariableNode could be leveraged to handle an interesting question I came across on Stack Overflow.
Author: SSWUG Research
Finding the Predicates that are different on the same Execution Plan
(Carlos Sierra) Ok, this may not be common but when it happens it becomes very hard to spot. Couple of cases:
How to Create an Extended Events Session in SQL Server 2012 – The DBA Power Tool!
(Angela Cataldo) Extended Events we–have all heard about it, but did you ever troubleshoot SQL Server 2008 performance, locking and connectivity issues using this source of data?
SQL Gone Bad – But Plan Not Changed? – Part 2
(Kerry Osborne) In Part 1 of this series I talked about the basic problem, which is that plan_hash_values are not based on the whole plan. One of the main missing components is the predicates associated with a plan, but there are other missing parts as was pointed out in Part 1 of Randolf Geist’s po
Renaming files for RMAN restore
(Bobby Durrett) Here is a script I hacked together Tuesday night to figure out how to fit all my production data files and temp files on a development server for a RMAN restore of a production backup onto a new server:
Did You Know? What settings to always change
(Kalen Delaney) A week ago, I taught my SQL Server 2012 Internals class to a great group of very interactive students. Even though a dozen of them were taking the class remotely, there were still lots of really great questions and and lots of discussion.
Lazy Log Truncation – Clearing of SQL transaction log VLF status deferred
(Lisa Gardner) I came across an oddity in the transaction log when I was testing Availability Group backup scenarios which really had me confused. It required some help from my colleague Denzil and a few others to figure out what was going on.
Closing the Unique Index Null Loophole
(Ike Walker) As documented in the MySQL Reference Manual: a UNIQUE index permits multiple NULL values for columns that can contain NULL.
Best Practices for Transitioning from ASP.NET to Windows 8 Development
(Brandon Downing and Phillip Stewart) Windows 8 is gaining traction in the marketplace and is forcing developers to adapt and evolve. Along with the adoption of new technology come lessons and steep learning curves.
Getting Started with ASP.NET MVC 5
(Rick Anderson) This tutorial will teach you the basics of building an ASP.NET MVC 5 Web application using Visual Studio Express 2013 Preview for Web or Visual Studio 2013 Preview. A Visual Web Developer project with C# source code is available to accompany this topic. Download the C# version.