(Pinal Dave) Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? and SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2.
Author: SSWUG Research
Regular Expressions 101 – REGEXP_COUNT
(Scott Wesley) Not all regular expressions are scary.
Performance Comparison of the SQL Server PARSE, CAST, CONVERT and TRY_PARSE, TRY_CAST, TRY_CONVERT Functions
(Ben Snaidero) With every new version of SQL Server comes new and hopefully improved functionality. When SQL Server introduces a new function that sometimes overlaps or replaces the functionality of an already existing function, I am usually curious as to which performs better.
NULL and UNIQUE
(Peter Gulutzan) When I worked for MySQL I saw frequent complaints that the UNIQUE constraint didn’t stop users from inserting NULLs, multiple times.
XmlObject
(Er.aruntyagi) Creating XML from Complex Object type is a tedious task, and populating Object from XML by parsing it is even worse.
DB2 LUW Indexes: B-Tree Details, Physical Storage and More
(Ember Crooks) I had an earlier blog entry on the basics of Indexes, but there are so many details to cover.
Tracking File-Download Events Using JavaScript And ColdFusion
(Ben Nadel) In my ColdFusion applications, I either use the CFContent tag or the X-SendFile module to stream binary data back to the client as a download. Then, in the browser, I simply link to the ColdFusion page that delivers the binary response.
SQLT Data Explosion
(Bobby Durrett) Well, I’ve been running SQLT all day. I’ve got a case open with Oracle support on the issue described in my previous post. Oracle support wants me to use SQLT to run one of the queries with the long parse time and so I picked one out of the AWR.
SSWUGtv – Data Points Briefing: Kevin discusses the SQL SERVER 2014 CTP (part 2)
Video Programming for IT Professionals
7 Tips to Finding a Mentor
Most successful people acknowledge that mentors and coaches help achieve their goals faster. But what is the best approach to finding a mentor? Here are some things to consider: