(Maciej Dobrzanski) MySQL lets database administrators define access rights on many levels – from the ability to run global commands down to access to individual columns.
Author: SSWUG Research
Don’t use TIME_WAITED in ASH views
(Bobby Durrett) I attended John Beresniewicz’s Active Session History (ASH) talk at Collaborate 13 on Monday. One simple point from it was that he commonly sees queries of the ASH views that use the TIME_WAITED column incorrectly and result in incorrect results.
Building Polygons from Incomplete Linestrings using ST_PolygonBuilder
(Simon Greener) This article shows how to use the Spatial Companion For Oracle’s ST_PolygonBuilder function to building polygon from incomplete linestrings (with gaps between pairs).
Deploying an ASP.NET Website to Azure in Visual Studio 2012 from a Git Repository directly
(Suprotim Agarwal) Azure Websites as we know is a ‘platform as a service’ offering allowing Azure subscribers to quickly deploy various type of web-applications. Using WebMatrix you can either pick from a huge Gallery of pre-built templates or build your own sites in ASP.NET and publish them to Azur
Oracle SQL Developer: Database Object Shortcuts?
(Jeff Smith) An interesting question popped up on the forum, and I thought I’d share my ‘answer’ with you folks. I figure this is something a lot of folks do several hundred times a day – pulling up a frequently used database objects in the browser.
Customizing EclipseLink JPA-RS Messages with MOXy
(Blaise Doughan) In a previous post I covered how EclipseLink JPA-RS can be used to expose a JPA persistence unit as a RESTful service. In that example we interacted with the default message formats.
A C# helper to read and write XML from and to objects
(Bertrand Le Roy) I really like jQuery’s pattern of attribute getters and setters. They are fluent and work really well with HTML and XML DOMs. If you specify a value in addition to the name, it’s setting, otherwise it’s getting.
Edit GridView data without displaying default Edit, Update and Cancel buttons
(Bipin Joshi) ASP.NET GridView control provides an easy way to edit and update data with the help of CommandField column type. The default CommandField arrangement is such that the Edit, Update and Cancel buttons are displayed in a column as shown below:
SQL Server 2012 Integration Services – Using PowerShell to Configure Package Execution Parameters
(Marcin Policht) In the series of introductory articles published recently on this forum, we have presented functionality incorporated into PowerShell that can be employed to create a SQL Server 2012 Integration Services catalog with an arbitrarily chosen folder structure, and deploy to it SSIS proj
Calculating the length of a string (Len vs DataLength)
(Kenneth Fisher) This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers I know use the function LEN to calculate the length of a string.