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 ...

SAN FRANCISCO, CA--(Marketwired - Jun 5, 2013) - Embarcadero Technologies announced today it is hosting an online event titled "New SQL Server 2012 Functions" featuring SQL Server expert Rick Morelan.

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 ...

Pity the poor modern DBA, now that SQL Server gets attacked by some of the same scripts that PCs do. Pity the poor modern DBA who has to keep building Microsoft SQL Servers because some idiot vice ...

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 ...

So, I can make a LAMP stack dance, but I have no MS experience whatsoever, and now I'm taking on some work involving an ASP.NET/IIS/SQL Server setup, and I feel like I'm in a foreign country.<br><br>I ...

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 ...