Since releasing SQL iQuery for the IBM i operating system, my customers have primarily been using a very cool feature of it: iQuery Scripts. iQuery Scripts, as the name implies, is a scripting ...

Data seeding is an important step in development process as it provides data for basic functional testing during development. However, data seeding may be also an integral part of the deployment where ...

These scripts should be put into the correlating ddl/insert folders and should have identical names following the convention: schema.table.sql (I recommend using all lowercase). In order for the dev ...

Then you are chased to present an inventory of all your SQL Server instances in your park. It might sound trivial, but it is something that most of us probably don't have especially if you manage ...

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of ...