(Kenneth Fisher) I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? Well the blocking_session_id was a negative 2 (-2)! I’ve never seen anything like it before.
Author: SSWUG Research
Applied SQL: LIKE ‘whatever’
(Jen McCown) Today let’s play around with the LIKE operator. Like, totally.
Java deserialization flaws: Part 2, XML deserialization
(djorm) All classes which implement the java.io.Serializable interface can be serialized and deserialized, with Java handling the plumbing automatically. In the first part of this two-part series, we looked at some of the unexpected security consequences which can arise from usage of binary deserial
Modifying InfoPath Form Based on XSD Schema Using Resource Files
(Deepti Nahar) I came across a scenario where an InfoPath form was created based on an XSD schema. This schema changed frequently and the corresponding changes had to be made to the UI (InfoPath form template) accordingly.
WPF Information Controls – Popup
(Richard Carr) The forty-fifth part of the Windows Presentation Foundation Fundamentals tutorial completes the individual examinations of the WPF information controls. This instalment looks at the Popup control, which allows controls to be shown as pop-ups.
SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip
(Pinal Dave) In one of the recent interview I had asked questions of interviewees – If you are a SQL Server Developer there must be times when you want to validate syntax, but do not want to execute a query.
How to Allow Updates and Inserts on Individual Columns
(Andrew Reid) This was tested on Oracle 11.2. First I created a couple of users:
Posting GridView Data To MVC Controller
(Bipin Joshi) Visual Studio 2013 provides a unified development environment for ASP.NET Web Forms and ASP.NET MVC applications. This unified environment is called as One ASP.NET. What it means for developers is that a single project can use Web Forms, MVC controllers and Web API. While using all the
Generating Concurrent Activity
(Michael J. Swart) I’ve discovered that DBAs use different methods to accomplish what amounts to the same thing: Generating concurrent activity on a server. I want to explore a number of methods I’ve seen. For each method, I want to call one particular procedure, many times at once, and often… Oh, a
Regular Expressions: Not as Tricky as They May Seem
(Ondrej Balas) Regular expressions are like power tools: They may look scary, but are easy to use once you understand their basic building blocks.