(Jason Strate) As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to p
Author: SSWUG Research
CTE Data Paging in a Procedure
(Steve Stedman) Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday we took a look at CTEs for Data Paging, today we will build on what we used yesterday.
Matching related and duplicate Customer Records using SQL Server Data Quality Services (DQS)
(Welly.Lee) SQL Server Data Quality Services (DQS) enables you to match records using your matching rules defined in DQS Knowledge Base. There are two common use cases where you would like to match related records. One is to identify duplicate in your records, such as same customers appear as separa
The lowdown on SQL Server auditing tools
(Robert Sheldon) When Microsoft released SQL Server 2008, they introduced SQL Server Audit, which are comprehensive SQL Server auditing tools that address many of the limitations of auditing capabilities in earlier versions of SQL Server, when DBAs had to rely on SQL Trace and other tools. But SQL S
Perform Row Operations Using MySQL Cursors
(Rob Gravelle) As promised in the MySQL Cursors and Loops article, this article explores the use of cursors and their role in stored procedure programming. A cursor is a special kind of loop for traversing through an SQL resultset one row at a time. That allows us to perform operations on every reco
Oracle Database 12c: joining and outer joining with collections
(Lucas Jellema) Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly inside the SQL query or that are returned by a PL/SQL function that is invoked from a TABLE operator in the query is a powerful weapon as well. Oracle Database 12c has
Identity Columns – 12c edition
(Bobby Curtis) Oracle has made it easier to define unique table columns with IDENTITY columns. These are table columns that have been enhanced to support the American National Standards (ANSI) SQL key word IDENTITY.
Declarative View Objects (VOs) for better ADF performance
(Shay Shmeltzer) Just got back from ODTUG’s kscope13 conference which had a lot of good deep ADF content. In one of my session I ran out of time to do one of my demos, so I wanted to share it here instead.
How To Use Spring RESTTemplate To Post Data to a Web Service
(Johnathan Mark Smith) In this example I am going to show you how to post data to a RESTful web service in Java using Spring, Spring Java Configuration and more.
SSWUGtv – Security Edition: How do you start the partnering process, and how do you avoid battle scars?
Video Programming for IT Professionals