This is the 5th article about Data Mining with SQL Server. This chapter is about Neural Networks.  Read more...

Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.  Read more...

This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models[1], this SQL Server 2012 CTP release allows connections between Power View and Multidimensional Models ( cubes) and not just Tabular Models.  Read more...

I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Windows Task scheduler on each SQL Server Express since SQL Agent does not come installed on Express Editions. Is there an alternative where I can utilize my existing SQL Server infrastructure?  Read more...

SQL Server 2012 makes your database maintenance jobs easy by proving an effective Maintenance Plan Wizard. This wizard does a fair job of creating core maintenance plans for your database.  Read more...

SQLServerCentral and Red Gate software have agreed to host the AdventureWorks database on the Azure platform and give free access to anyone that wants to practice querying it.  Read more...

A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.  Read more...

It is increasingly likely that DBAs are now given responsibility for maintaining Azure SQL databases as well as conventional SQL Server databases. What is likely to be required by way of maintenence? What are the differences? Grant Fritchey covers what you need to know.  Read more...

Learn how to write a script for regular database backups using Powershell and SMO.  Read more...

There's more than one way to be green.  Read more...

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...  Read more...