(Ben Nadel) ColdFusion 10 Beta introduced two revolutionary concepts to the ColdFusion language: Closures and Function Expressions. Closures allow functions to retain their lexical bindings when passed out of context; Function Expressions allow us to define functions as part of larger expressions.
Other News
Querying Active Directory Data from SQL Server
(Brady Upton) My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server? In this tip we walk through how you can query Active Directory from within SQL Server Management
Back to the Cloud
Featured Article(s) Troubleshooting SQL Server 2008 performance counters problems In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2008 performance counters. He also tells how you can resolve these problems.SQL Server 2012 Release – Beginning to Understand the Changes SQL Server 2012 brings a while series of changes to the platform, from more crystalized […]
SQL Server 2012 On Deck
SSWUGtv: Special Edition Leon Guzenda from Objectivity DB joins us to talk about Big Data, some real applications for it and the history behind this kind of massive data procession. Really interesting applications of this technology. [Watch the Show] Featured Article(s) SQL Compliance Review Do you work in the Healthcare industry? Do you work in the Banking industry? Do you […]
Transactional Replication – Unable to Replicate Data onto the Subscriber – A Practical Example
(Satnam Singh) Scenario: A couple of days back, I got a call from one of my users saying that the Data is not being replicated properly onto the Production Reporting Server from the Production OLTP server.
Enterprise architects mix REST integration with SOA
(Alan Earls) SOA is no longer merely a buzzword. It has become a mature component of innumerable pieces of IT infrastructure and now is being projected into a future helping to support the cloud and mobile apps. As it is adapted to these new functions, practitioners find they must move quickly to in
How do I kill a query?
(Evan Lenz) Have you ever run some code in Query Console only to realize that your query was going to take way too long to finish? Perhaps you made a mistake and didn’t want to wait for the query to complete
Identifying Unused Indexes
(Craig S. Mullins) Did you know that DB2 V9 added a new column to the Real Time Statistics to help identify unused indexes?
SQL Developer Trick: DropDown Vs Tree
(Jeff Smith) I’m not saying there’s anything wrong per se with SQL Developer’s tree control for navigating your connection objects. As a matter of fact there are a few things to really admire about the tree implementation. Just in case you have NO IDEA what I’m talking about, here is the tree in all
How to transform a CSV file into HTML table in SQL
(Frank Zhou) The following SQL pattern can be used to tranform the CSV file into a HTML table by utilizing the XQUERY functionality.