Articles in SQL-DB

Create CLR Stored Procedure with Visual Studio Express Edition

By Manar Ezzadeen

Create CLR Stored Procedure with Visual Studio Express edition

SQL Server Date Format Language

By Cristhian Selah

Perform a conversion in a select, view, and Stored Procedure.

MySQL 5.6 Replication: FAQ

By Mat Keep

[if gte mso 9]> 0 0 1 1207 6881 Homework 57 ...

btrfs – probably not ready yet

By Vadim Tkachenko

Every time I have a conversation on SSD, someone mentions btrfs filesystem. And usually it is colored as a solution that will solve all our problems, improve overall performance and SSD in particular, and it is a saviour. Of course it caught my curiosity and...

Infobright/MySQL Statistics Utility

By Ryan Krage

Display Infobright/MySQL Database Statistics in Java

Contained Databases in SQL Server 2012

By Dinesh Asanka

Contained Databases have been an oft requested feature which has finally arrived in SQL Server 2012. In prior SQL Server versions, database were not 100% portable. In case you need to move a database from one server to another using backup and restore, the...

Intel 520 SSD in MySQL sysbench oltp benchmark

By Vadim Tkachenko

In my raw IO benchmark of Intel 520 SSD we saw that the drive does not provide uniform throughput and response time, but it is interesting how does it affect workload if it comes from MySQL. I prepared benchmarks results for Sysbench OLTP workload with MySQL...

LLBLGen Pro feature highlights: assigning attributes based on rules to properties in generated code.

By FransBouma

(This post is part of a series of posts about features of theLLBLGen Prosystem)One of the things which makes some people hate generated code is that it's effectively 'read-only' code: changing it will make you run the risk that your changes are likely gone...

SQL Server Prefetch and Query Performance

By Fabiano Amorim

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries...

A first look at SQL Server 2012 Availability Group Wait Statistics

By Joe Sack

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize...