(Ross Mistry and Stacia Misner) If you thought Microsoft SQL Server 2008 Reporting Services introduced a lot of great new features to the reporting platform, just wait until you discover what’s new in Reporting Services in SQL Server 2008 R2. The Reporting Services development team at Microsoft has
Other News
Service Broker, Are You Using It?
DBTechCon – Spring 2011 The SSWUG Spring 2011 virtual conference is quickly coming together. Without a doubt, this will be the largest virtual conference in the information technology industry. Access more than 70 sessions from well seasoned professionals with in-depth instruction on technologies such as SQL Server, SharPoint, .Net, Business Intelligence and much more. Register any time from now to […]
HTML 5 nears completion: What is happening to HTML?
(Bill Brogden) Listening to marketing departments you would think that HTML 5 is poised to take over the world, but I found that the status of HTML5 versus HTML 4 and XHTML as standards in typical web developer practice is not as simple as that.
XQuery in the Browser … via JavaScript
(Kurt Cagle) Here’s an interesting thought experiment – suppose that XML had preceded HTML and that XQuery had originated prior to JavaScript. Given that, what would the web have looked like?
Working with Reporting Services Filters – Part 4: Creating a NOT IN Filter
(Stacia Misner) A question came in from a reader asking about how to create a NOT IN filter. You can see in the first of this series of blog posts about Reporting Services filters, NOT IN is not available in our list of operators for filters. However, it’s still possible to produce a filter that exc
Scheduling Tips and Tricks
(tdoman) In a previous post (Create a regularly scheduled job), we described how to create a schedule using the SSMS visual interface.
New cursor_bind_capture_destination parameter in Oracle 11.2.0.2
(Tanel Poder) I just noticed that there’s a new cursor_bind_capture_destination parameter in Oracle 11.2.0.2 (which is really more like Oracle 11gR3 version because of the large amount of new features in it, as opposed to just bugfixes).
More on Interested Transaction Lists
(Arup Nanda) In the last installment of this series “100 Thing you Probably Didn’t Know About Oracle” you learned how Oracle locks the rows of a table. Here is what you learned in a nutshell:
How to Monitor an Oracle Database Automatically
(James Koopmann) In the past, automatic monitoring of an Oracle database often resulted in DBAs developing a variety of scripts, scheduled to run against the database. Oracle’s Automatic Database Diagnostic Monitor (ADDM) provides a more elegant way to monitor database performance automatically.
Prepared Statement Failure
(Michael McLaughlin) One of my students asked for some help on developing a MySQL stored procedure that would conditionally drop a foreign key constraint. I put together a quick example, which compiled fine but failed at run time. With some investigation it appears that either the MySQL 5.5 Document