MySQL 5.5.6 is not ACID compliant, here is an example: mysql> drop table if exists mytable1; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> create table mytable1 (idontfeellucky int) ; Query OK, 0 rows affected (0.44 sec) mysql> show create table mytable1; +——-+—————————————————————————————-+ | [...]

When I investigate a new SQL Server instance for the first time, I perform a number of standard checks to get a handle on the current health of the system. One of the checks I like to perform is a VLF count on each transaction log file associated with each database on the system. Right [...]

In this quick presentation I’ll demonstrate how you can use a SSIS package in SQL Server 2008 to loop through multiple files of a certain type in order to load data into your database. Thanks, James Shropshire MCDBA, MCITP SQL Server