Managed Instance Database Limits

The Great Developer Resignation

In 2021, many companies had employees leave positions. The number of people resigning from their jobs was so high that the term "The Great Resignation" began appearing in many publications. A number of industries were affected, and there are no shortage of pundits and experts analyzing why. This happened primarily in the US, but the […]

Model Good Behavior

I'm answering a question in the forums and I spot something that crawls up my spine: ;WITH... The person was using a Common Table Expression (CTE) which requires that the preceding statement in the batch have a statement terminator, the semi-colon. However, since the terminator isn't required everywhere, lots of people don't use it at […]

SQL Server Monitoring Using Free Tools

You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!

Most of Us Are Vulnerable

Security is hard, and while data professionals might not be responsible for network issues, we ought to be aware that there could be vulnerabilities that might attack our systems.

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

Your Data After Life

Today Steve thinks about what to do when planning for your digital assets after you pass.

Changing Computer Retail

The way we build and buy computers has changed.

Is AI human-ready?

Aleksander Madry discusses roadblocks preventing AI from having a broad impact and approaches for addressing these issues.
Continue reading Is AI human-ready?.

8 ways for banks to use AI

If a bank gets in touch with a software company and wants to know how it could use artificial intelligence (AI), that means two things. First, the bank is...