As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

If you haven’t been paying a lot of attention, you might have missed the rise of a new form of virtualization, based at the operating system level, called “containers.” While there are many specific ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...

Microsoft announced the name and many of the new features in the next release of SQL Server at its Data Amp Virtual Event on Wednesday. While SQL Server 2017 may not have as comprehensive of a feature ...

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come with a ...

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

Tim Kridel is an independent analyst and freelance writer with years of experience in covering technology, telecommunications and more. Just how much does the Department of Defense rely on Microsoft ...

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale. One of the most fundamental choices to make when developing an ...

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...