(Anshoo Srivastava) We know that Oracle EXECUTE IMMEDIATE statement implements Dynamic SQL in Oracle. It provides end-to-end support when executing a dynamic SQL statement or an anonymous PL/SQL block. Before Oracle 11g, EXECUTE IMMEDIATE supported SQL string statements up to 32K in length.
Author: SSWUG Research
How to display a QR code in ASP.NET and WPF
(Scott Hanselman) I’ve half-jokingly said that there’s never a good reason to use a QR Code. However, I’m working on an MVP (minimally viable product) for a small startup with Greg Shackles and we actually have a good reason to use one.
Keeping Track of your SQL Servers with a DBA Configuration Repository
(Sadequl Hussain) SQL Server DBAs are often responsible for managing large number of database instances. Busy 24/7 operational DBA teams may look after hundreds of instances with widely different characteristics. As systems get added, modified or decommissioned from the fleet, database administrator
Using AutoMapper with Complex XML Data
(Scott Toberman) AutoMapper is a very cool object-to-object mapping library that works great mapping POCO-to-POCO and even handles collections pretty seamlessly. Unfortunately, in the real world, sometimes the data we need comes to us in other formats. This article explores mapping XML data using Au
Creating Useful Naming Conventions: Business Considerations
(Peter Vogel) In an earlier column (“Creating Useful Naming Conventions: Technical Considerations”), I looked at the benefits that naming conventions have historically provided to individual developers in preventing programming errors.
Waiting for 9.4 – Support ordered-set (WITHIN GROUP) aggregates.
(depesz) On 23rd of December, Tom Lane committed patch:
SQL Server Error Message: ‘Saving changes is not permitted’
(Ged Mead) Whenever I’m working on any kind of developer task, I find that I hit the Save button or hotkey combination very regularly indeed. It’s just become an ingrained habit (and I think it’s a good one). But there is one situation where saving before the job is finished can bring up a problem
What’s New in .NET Framework 4.5.1
(Pravinkumar Dabade) Microsoft .NET Framework 4.5.1 is an in-place update to .NET Framework 4.0 and the .NET Framework 4.5. This version can be run side-by-side with .NET 3.5 and earlier versions.
WPF Information Controls – ToolTip
(Richard Carr) The forty-fourth part of the Windows Presentation Foundation Fundamentals tutorial continues the examination of the WPF information controls. This instalment looks at the ToolTip control, which enhances tool tips for FrameworkElements.
Using Complex Types In Entity Framework
(Bipin Joshi) Recently a participant of my ASP.NET MVC training program asked me about complex types in entity framework. This article attempts to answer that question…