(domas mituzas) Our database environment is quite busy – there’re millions of row changes a second, millions of I/O operations a second and impact of that can be felt at each shard. Especially, as we also have to replicate to other datacenters, single threaded replication on MySQL becomes a real bot
Other News
SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT
(Pinal Dave) Today I had very interesting experience when I was presenting on SQL Server. While I was presenting the session when I ran query SQL Server Management Studio returned message like (8 row(s) affected) and (2 row(s) affected) etc. After a while at one point, I started to prove usage of @@
Cursors V The Good, the Bad, and the Ugly
SSWUG-TV Check out this latest edition of SSWUG-TV to hear Field Reporter Interviews from SQL Server MVP Kevin Kline. Watch the Show 2012 Class Development Survey Responses The results of our survey for class topics for trainging next year have been compiled. Click here to see a chart of the responses, Many of the topics we included in the survey […]
XML Data Binding for Java on Android using JiBX
(Don Corley) JiBX is an excellent tool for binding XML data to Java objects on the Android platform.
WebDriver: Getting it to play nicely with jQuery ColorBox
(Mark Needham) As I mentioned in an earlier post about removing manual test scenarios we’ve been trying to automate some parts of our application where a user action leads to a jQuery ColorBox powered overlay appearing.
SQL Server 2008 and 2008 R2 Integration Services – Slowly Changing Dimension Transformation – Historical Attributes
(Marcin Policht) In one of the recent tutorials published on this forum, we described characteristics of Slowly Changing Dimension methodology, focusing in particular on its implementation in SQL Server 2008 R2 Integration Services.
Microsoft SSIS basics: Tying it all together
(Don Jones) One of the awesome features rolled out in SQL Server 7.0 was its Data Transformation Services. Today, that set of features is called SQL Server Integration Services (SSIS).
XML data mining, Part 2: Mining XML association rules
(Laura Irina Rusu) In Part 2 of this series, learn about mining association rules from XML documents. Mining association rules from XML documents is different from mining rules from relational data. Information can be structured differently in XML because of the language’s flexibility and hierarchic
Creating FlowDocuments using XML Literals & Embedded Expressions
(Meshack Musundi) In this article I will show how you can go about defining a FlowDocument using XML Literals and embedded expressions. As XML literals are exclusive to VB.NET this article may not be palatable to some die-hard C-Sharpers. If your programming curiosity gets the better of you then ple
Backing Up a SQL Server Database Directly Onto a Remote Server
(Satnam Singh) Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy and t