(Allen White) After having used PowerShell to manage SQL Server since 2006, when PowerShell was first introduced, I’m pretty comfortable with it. Everyone has to start somewhere, though, so I’d like to share some basics with you. Hopefully, you’ll be as comfortable with it as I am in no time.
Author: SSWUG Research
JDeveloper Extension To Suppress Warnings
(Wilfred van der Deijl) The JDeveloper auditing framework can be a very valuable tool in delivering high quality code. It not only gives you warnings and errors during development, but can also be run from the command-line on a build server. One thing that always annoyed me is the limited possibilit
BLU at IOD: Highlights from 2013
(Susan Visser) This year’s IOD conference was amazing! Record crowds, lots of events, great people, and for the first time ever, our beloved product DB2 was front & center! DB2 with BLU Acceleration is clearly a winner and you had no trouble learning about it at IOD: the whole conference was paint
NanoXML – Simple and fast XML parser
(TObject373) This is a quite small and fast XML DOM parser on the .NET platform (using .NET 2.0). The Main feature and main demand for this is not to use the System.Xml namespace. Also tests shows amazing performance results compared with built-in .NET parsers.
Protecting your Azure Blob Storage Items using Shared Access Signatures
(Suprotim Agarwal) In my recent experiments with Azure Storage, I found out that Azure Blob items are protected by default and unless you make them available explicitly, they cannot be accessed. However opening up Blob access to the whole wide world can be a big bag of hurt, especially since you pay
JOINing against VIEWs can be harmful
(Selena Deckelmann) I had a recent code review problem that was very curious at first glance, but came down to the use of complex VIEW in an even more complicated and frequently used reporting query.
Steps to rollback database changes without impacting SQL Server Log Shipping
(Mohammed Moinudheen) I have a production release for a database that has log shipping setup. The database is very large and I don’t want to have to redo the entire log shipping setup again if I have a problem with the release and I need to roll back the changes. I plan to take a full backup of th
Node.js Development in Visual Studio – Life After Visual Node with Node Tools for Visual Studio
(Bart Read) By now you may have seen the first public alpha release of Node Tools for Visual Studio on CodePlex announced in Scott Hanselman’s excellent overview of the suite. You may have noticed Red Gate’s name associated with this and, particularly if you’re a Visual Node user, you’re probably wo
12c Invisible Columns (The Invisible Man)
(Richard Foote) Oracle 12c introduced the ability to make user specified columns “Invisible” such that they’re invisible by default and have to be explicitly referenced to be accessed. So a simple SELECT * won’t display columns defined as invisible, but they will be displayed if explicitly reference
I forgot to mention Data Studio in our discussions about DB2’s subsystem parameter (aka DSNZPARM)
(Willie Favero) This could be the longest post (in words) with the least amount of information (overall content) that I have ever published. For that reason I am going to break it down into multiple posts to make it easier to read. You see, what I want to attempt to do over the next couple of post s