Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

With the release of SQL Server 2014 earlier this year, Microsoft Corp. marked another milestone in its vaunted plan to plunge into cloud computing. SQL Server 2014 found a favourable response in early ...

Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

This course has been developed in collaboration with GreenFrog IT Solutions to prepare fresh graduates and working professionals to work as an effective and productive SQL Database Management & ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

I'm struggling to make this work, it's for a school assignment so I'm looking for some direction instead of a straight out answer. I'm just going to paste the whole thing up here.<BR><BR> <BR>For this ...

In an earlier tip I discussed how indexes can speed up processing. It's only fair that I also talk about when indexes don't help. First: Because indexes don't always help but do always increase the ...