Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

As we’ve come to expect from new SQL Server releases, SQL Server 2012 has so many new features that it’s impossible even to mention them all. Nearly everyone is well served, from the BI-hungry users ...

No fooling: The next version of Microsoft's flagship database will be available on April 1. SQL Server 2014 hit its "release-to-manufacturing" milestone today, which typically falls several weeks ...

At a rather muted Microsoft TechEd in Los Angeles in May, the crowds were diminished and the educational content was slimmed down. In the past, SQL Server sessions were so abundant that you'd have ...

Learn the differences between Is Null and IsNull() in Access Your email has been sent How many null values exist? What is the difference between a null value and a blank entry? This article answers ...