Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White ...

Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine.   Click the ...

Have you heard of the monthly print and web magazine Database Trends & Applications (DBTA)? Did you know I'm the regular columnist covering SQL Server?  For the past six months, I've been writing a series of articles about database benchmarking culminating in the latest article discussing my three favorite database ...

I've been keen on MySQL ever since I first started using it heavily more than a decade ago.  In fact, I liked it well enough to include it as one of the four main database platforms, over and above the ANSI-ISO SQL standard, in my popular book SQL in a Nutshell. However, with the advent of NoSQL data platforms in the last few years, ...