I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

The Common Language Runtime is at the heart of Microsoft’s .NET vision. It promises to co-opt the benefits of Java–it’s a run-time environment that features a just-in-time compiler and built-in ...

The long-awaited upgrade to Microsoft’s SQL Server database will come with a raft of new features when it ships later this year — as well as a price hike of up to 25 percent, Microsoft said on ...

SSIS is a popular and mature tool for performing data movement and cleanup operations. In the Microsoft ecosystem, SSIS is one of the most common extract, load, and transform (ETL) tools in use today.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...