(Craig S. Mullins) One of the most fertile grounds for disagreement between database professionals is the appropriate usage of views. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach.
Author: SSWUG Research
Clarity in T-SQL: Adjoining Socks
(Jen McCown) One of my children is very literal, a true pedantic.
SSWUGtv Security Edition: Today, we discuss HIPAA/HITECH Compliance with Patrick Townsend.
Video Programming for IT Professionals
SQL Server Database RESTORE WITH MOVE or not WITH MOVE
(Mike Eastland) A recent tip related to RESTORE operations reminded me of something I’ve wanted to share for quite some time. I frequently restore production databases to various development servers. The drive layouts between the servers are almost never the same. I am constantly shuffling files
jQuery – How to Select Nodes by Attribute Value?
(Arun Ramachandran India) In this article, we will go over Selecting Nodes by Attribute Value in jQuery.
Tracking changes in PostgreSQL
(Hans-Juergen Schoenig) Database security is always an essential issue in any database application. Especially when critical data is stored, it might be interesting to know who has changed which data when and how. To track those changes made to tables in PostgreSQL you can write yourself a generic c
Oracle Tablespace File Management Made Simple
(Mary Mikell Spence) One of the most common tasks for any DBA is managing the space used by the database. This, in turn, translates to managing space on the server. In the early days of Oracle, this could be quite a task as it was considered a ‘best practice’ to use as few extents as possible to c
Oracle Restart with Oracle Database 12c (12.1.0.1)
(Bobby Curtis) Back in October, I wrote a blog post on adding an Oracle 11g Database to Oracle Restart to help start the database on a server reboot (if you want to read that post, you can find it here). Since my original post on using Oracle Restart to start a database, I’ve talked with a few fr
Virtual Reality in the .NET Framework, Part 2
(Eric Vogel) Welcome to Part 2 of this series on programming for the Oculus Rift Virtual Reality headset in the .NET Framework. Today I’ll cover how to render a stereoscopic 3D scene using Mono Game, which is an open source implementation of XNA.
Normalizing T-SQL text, part 2: using the TransactSql.ScriptDom classes
(Arvind Shyamsundar) In my previous post I had reviewed the classic ways of obtaining ‘normalized’ text for ad-hoc SQL queries. Do take a minute to glance at that post in case you have not already done so. Both the methods described previously are dynamic – they need an active workload to operate up