(Ben Nadel) Yesterday, I campaigned against using ColdFusion 10’s dynamic “query” attribute in the CFLoop tag. That said, I am really excited that CFScript now supports FOR-IN looping for queries. This creates complete uniformity in CFScript for looping over queries, arrays, and structs.
Other News
Why a statement can be unsafe when it uses LIMIT clause?
(Maciej Dobrzanski) MySQL 5.1 or newer can sometimes start throwing a strange message into an error log. The message states that a query was unsafe for binary logging along with some additional information. What does it mean? Is it a problem?
Create a SharePoint Lookup Column to Another Site
(Benjamin Niaulin) I have been working with SharePoint for quite some time now, and have come to realize that a lot of SharePoint users do not use what is available out of the box. A very popular example for this is the lookup column.
IBM Cognos Proven Practices: Use Case: Diagnosing a Planning Problem with the IBM Cognos Planning Diagnostic Tool
Installing a new version of IBM Cognos Planning, the component Planning Analyst produces an error when launching.
SQL Services Status Check – An Evolution Part 2
(Robert Pearl) In my last tip Checking SQL Service Status – An Evolution (part I), I spoke about the important need to be able to monitor and keep track of the status of all necessary SQL Server Services. I also showed you one method using t-sql, xp_cmdshell and an OS component called SC.exe (servi
Scheduling Tools
Scheduling Tools I wrote about scheduling in Azure yesterday as a place where some of the tools we have become accustom are not available. My primary tool of choice for scheduling has been SQL Server Agent, being primarily a DBA for decades. One reader, Shannon, reminds us that there are a lot of capabilities built into Azure allowing for tasks […]
Josef Richberg talking about SSIS – Common mistakes, things to know and tips – all for SSIS and SQL Server.
Pro-Center Video Programming for IT Professionals
Scheduling Jobs in Azure
Scheduling Jobs in Azure Are you thinking about moving your applications into the Azure Cloud? Guess what is no longer there? Azure, at this time, doesn’t have any job scheduling technologies. Windows Scheduler and SQL Server Agent do not exist in Azure. Why? Because when you publish your applications in Azure you have no idea where it will be hosted. […]
Using JQuery Ajax to read an external XML file
(purushothamj) I wanted to read an external XML file, parse it and load the data into a HTML Form control. In this case, i wanted to populate a select component (combo box). And he didn’t want to use any PHP, Java or whatever. So that leaves me with JavaScript and HTML. This intrigued me for a bit.
Table High Water Mark and How Empty the Table Is
(Martin Widlake) On a recent post about reducing the high water mark in a table by shrinking it someone asked if you could tell how much “space” there was in a table that could be recovered by compressing it.