With SQL Server 2022, there was a shift back to a slightly slower cadence, which we are back to -- I'm not expecting a SQL Server 2024, but you never know. Microsoft has leveraged its cloud ...

This is script kiddie stuff—and fixing your web application to mitigate the risk of SQL injection is so easy that failure to do so looks more and more like gross negligence. There are several ...

I was not terribly surprised that there were some changes coming to the SQL Server licensing model with this new version. Effective January 2023, Microsoft will raise the per core pricing of SQL ...

The ability to perform transactions is the backbone of most processes today, and SQL made that possible at scale. There have been attempts to replace SQL in the past. NoSQL (Not only SQL ...

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...

IMDb is a single database that tells you everything there is to know not only about movies but also the directors, writers, actors, and crew. The IMDb archive is available for use by anyone who wants ...

With Microsoft T-SQL, there’s the stored procedure sp_spaceused. As convenient as triggers are, they come with a big limitation: they must happen in the same transaction as the original operation.

And while there are plenty of new features and speed improvements in this new version, the fact that SQL Server 2017 supports Linux remains one of the most interesting aspects of this release.

“Not really,” I replied, “I think there’s going to be trouble.” The day was the 25th of January, 2003, and SQL Slammer had just been released. Slammer was the fasted spreading Internet ...

While you can find many courses on SQL, there are very few that focus on query optimization. When you get down to writing SQL queries in the real world, you don’t just want the correct result ...