(Alex Nuijten) Yesterday I attended John King (@royaltwit) session on Oracle 12c for developers. He gave an overview of all the goodies that are available to us as developers. The whole plugging and unplugging of database, though very cool and exiting, is most likely not very relevant to most develo
Author: SSWUG Research
Using an Event Monitor to Capture Statements with Values for Parameter Markers
(Ember Crooks) Recently, I needed to do some SQL profiling – discovering exactly what SQL a web application was executing against the database. I learned a lot, and when I learn a lot, I try to share with my readers.
Build your own cloud sandbox, Part 2: Configuring security options
(José De Jesús, Michael Nassar and Apurv Johar) This article continues our discussion from Part 1 on how to build and configure your own cloud sandbox using a Workload Deployer virtual appliance. If you successfully completed the steps outlined in Part 1, which cover a complete installation up to
jQuery Autocomplete in MVC 3: Different Approaches and Customizations
(user6790) This article will describe how to implement the autocomplete feature from scratch in a .NET MVC application using jQuery.
Working with Task Scheduler XML
(Jason Morgan) Thank you for the opportunity to contribute to the Hey, Scripting Guy! Blog. I’m here today to talk about working with XML, specifically working with XML as it relates to the Task Scheduler. I’ve found at my job that I often need to create the same tasks on multiple computers.
Everyday Postgres: How I write queries using psql: Common Table Expressions
(selena deckelmann) I’m now going to share in a series of posts my workflow for writing queries, and some of the things about working with Postgres that I take for granted in writing queries.
Deleting Data from an SQL Table
(Mike Chapple) Oftentimes, it becomes necessary to remove obsolete information from a relational database. Fortunately, Structured Query Language provides a flexible DELETE command that can be used to remove some or all of the information stored within a table.
Using CORS in ASP.NET WebAPI Without Being a Rocket Scientist
(Rion Williams) If you have done any extensive work with AJAX calls, then the odds are that you have fun into an unfriendly (only for security purposes) mechanism that will have your request ground to a halt and its name is CORS (Cross Origin Resource Sharing).
An Introduction to Python Web Development Using the Pyramid Framework, Part 3
(Jesse Smith) If you haven’t read Part 1 and/or Part 2 of this series, I recommend you do that before continuing with this article. In Part 2, we looked at how to configure a Pyramid application using Declarative Configuration and Imperative Configuration.
The PoSH DBA – SQLPSX: SQL Server PowerShell Extensions
(Laerte Junior) Every DBA needs to know about SQLPSX, the PowerShell module library that is built by DBAs for DBAs, and designed to provide intuitive functions around the SMO objects. It makes the automation of database administration easier across all versions of SQL Server since SQL Server 2000.