(Peter Vogel) Sometimes you need more than roles to effectively manage authorizing user requests. You can do that without moving to claims-based security in the Microsoft .NET Framework 4.5 by creating your own user object.
Author: SSWUG Research
Ordering steps in a SQL Agent job
(Kenneth Fisher) Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is also a limited about of control flow available in SQL Agent jobs. Here are a couple of examples of how it works and what you can do with it.
DB2 Locking, Part 15: Tackling Timeout Troubles
(Craig S. Mullins) Many shops battle with locking issues and frequently, the cause of performance issues can be traced back to locking issues, more specifically, lock timeout issues. When you experience a timeout, it means that another process holds a lock on the data that you are trying to modify.
Security Questions: Prioritizing Security
(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
Configuring and Troubleshooting Database Mail for SQL Server
(Michael K. Campbell) In the past I’ve blogged a bit about the importance of enabling your SQL Servers to be pro-active in terms of alerting you via email when something bad has happened or requires attention. I’ve also addressed a very common ‘gotcha’ that prevents the SQL Server Agent from raising
5 Steps for Migrating Data to IBM DB2 with BLU Acceleration – See more at: http://ibmdatamag.com/2013/06/5-steps-for-migrating-data-to-ibm-db2-with-blu-acceleration/#sthash.TBP5F3Zm.dpuf
(Mohankumar Saraswatipura) In the dynamics of today’s business world the success of any organization depends largely on organizational decisions made at the appropriate times. And a reliable data warehouse environment plays a pivotal role in helping drive the business decisions that can move an orga
TechTip: jQuery Fundamentals, Part IV
(Jan Jorgensen) Well, it’s been a while since I started this jQuery fundamentals series, but I hope you haven’t forgotten about it. If you have, please read up (parts I, II, and III) because this time, I’ll put a lot of functionality into the script. This tip contains all the elements of a "real" we
Oracle Database 12c: XQuery Update
(Marco Gralike) New, new…? No, not really new, XQuery Update (W3C standard/draft 2011) was already implemented in 11.2.0.3.0, but is now officially also announced. Besides the XQuery Full Text support (XQFT for short, W3C standard/draft 2011), this is one of the big new features in Oracle 12c.
Advanced View Criteria Implementation in ADF BC
(Andrejus Baranovskis) I would like to walk through advanced options in ADF BC View Criteria. It goes easy, when defining pretty much standard criteria operators and comparing attribute from VO with literal on bind variable. But when it comes to implement more complex use case with SQL expression or
MySQL Proxy and microseconds
(Ronald Bradford) By default the included Lua within MySQL proxy (0.8.3) does not include socket, necessary for getting microsecond granularity. To setup you have to install Lua and socket on the OS first: