Microsoft's rapid-fire release cycle for SQL Server means it's easy for database admins to miss useful new features. Here are some recent additions that might otherwise fly under the radar. Modern ...

In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

Microsoft's SQL Server business has hit the $5 billion mark in terms of annual revenue and is growing like gangbusters, according to CEO Satya Nadella. But licensing experts believe this stunning ...

Sometimes, life really is like a box of chocolates. The same can also be said for software upgrades. Take, for instance, Visual Studio 2008. After all its various CTPs and RTMs, I feel like I've been ...

ENVIRONMENT: A dynamic Joburg-based Business Process Outsourcer seeks a forward-thinking Senior SQL Developer who sees AI not as a threat but as a powerful productivity enhancer. That leveraging tools ...

Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

Database admins strive to ensure that large chunks of data are both accessible and stored with integrity. By using these programming languages, they can keep systems optimized. As data volumes ...

The first two articles in the Hello, OSGi series have laid the groundwork for understanding how the OSGi service platform works. In this final installment, you’ll learn how OSGi’s pluggable, component ...