I'm very sad to say that after 5 ½ years I am leaving Quest and, as a result, this will be my last column for Database Trends and Applications. I have greatly enjoyed writing these articles and I hope ...

In 2020, we endured the COVID-19 pandemic’s impact on health and life, and we also saw multitudes of businesses and organizations collapse. One of those casualties was PASS, also known as the ...

Microsoft's continued focus on SQL Server 2025 highlights the lasting demand for on-premises and hybrid deployments that prioritize performance, control and flexibility for enterprise workloads. In ...

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there were ...

Relational SQL databases, which have been around since the 1980s, historically ran on mainframes or single servers—that’s all we had. If you wanted the database to handle more data and run faster, you ...

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

As more computing functions move to the cloud, a relatively new database format — NoSQL — is poised to take the place of the SQL database on which so many manufacturers rely. Automation experts weigh ...

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