(Wayne Ha and Patrick Zeng) Learn how to enable database high availability (HA) using IBM Linux, UNIX and Windows (DB2 V8 or DB2 9) High Availability and Disaster Recovery (HADR) capability in an SAP ABAP and Java dual stack environment, as well as how to enable automatic failover using IBM Tivoli S
Other News
MySQL Proxy: Tracking Parallel Queries
(Jan Kneschke) In the Enterprise Team we had the need to track how many connections to the MySQL server in parallel. By “used” I mean running queries and not just idling around.
Report Session Caching in Reporting Services 2005
(William Pearson) One of many capabilities that Reporting Services offers administrators is caching. During report execution, the three basic steps taken by the Report Server include: –Retrieval of data from the specified data source(s); –Merging of the retrieved data with the layout informat
Passing table valued parameters in SQL Server 2008
(Tim Chapman) I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary.
Performance Impact: the Most Optimal Insert Script can’t Beat BulkCopy
(Linchi Shea) With the insert script and the test configurations in my previous posts, the best data load throughput was 24GB in ~7 minutes when the checkpoint (and/or transaction commit) batch size was set to 100,000 ~ 1,000,000. That was the best result when I was trying to get the most out of the
Distributed DBA: Label-Based Access Control, Part 2
(Roger E. Sanders) Label-based access control (LBAC) is a DB2 9 security feature that uses one or more security labels to control who has read access and write access to individual rows or columns in a table. In my previous column, I described how you can use LBAC to control who can access individua
Business Intelligence and Data Mining VS Privacy and Ownership
New Weekly SQL Server Show Posted SelectViews: Legacy application upgrade choices, T-SQL JOINs, upcoming events and more. Also looking at privacy expectations and business intelligence – a problematic match? This is show number 79, and you can also find out how to win $200 in the drawing, information about current SQL Server versions and service packs and all sorts of […]
(79) SelectViews: Legacy application upgrade choices, T-SQL JOINs, upcoming events and more.
Video Programming for IT Professionals
Heading to SQL Server Connections in Vegas in November?
Catch the Latest Weekly SQL Server Show Here Watch SelectViews, posted Friday, with another episode posting tomorrow. Watch here. Featured Article(s) Standard Operating Procedure I alluded to SOPs or Standard Operating Procedures in an article earlier and Sean Maloney was kind enough to mention that this is really something that I could expand on. In short, anyone could pick up […]
Parsing Microformats
(Brian Suda) Microformats are a way to embed specific semantic data into the HTML that we use today. One of the first questions an XML guru might ask is “Why use HTML when XML lets you create the same semantics?” I won’t go into all the reasons XML might be a better or worse choice for encoding data