Your site got hacked overnight. And guess what? You didn’t even see it coming. According to Forbes, over 30,000 websites are hacked every single day. Most site owners are unaware of it until the ...

In November 2024, we announced the next major release of SQL Server: SQL Server 2025. SQL Server 2025, now in private preview, includes capabilities to build AI applications including vector and AI ...

You may encounter the SQL Server Error 18456 if the server could not authenticate the connection and this can be caused by the non-availability of the administrator ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

I am experiencing an issue with Liquibase where it fails to drop the auditlog table in a different schema on MS SQL Server. I am using Liquibase to create the auditlog, but when the auditlog table is ...

This article discusses the “DROP IF EXISTS” statement available in SQL Server 2016 and later versions. “IF EXITS” is the latest optional clause added in the existing DROP statement in SQL Server 2016 ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...