A recreation of the classic Visual Basic 6 IDE and language in C# using Avalonia. This is a fun, toy project with no commercial intent. All rights to the Visual Basic name, icons, and graphics belong ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

Whether you're writing the next hit computer game or creating a simple drawing program, you may need to know where a user's mouse cursor lies on the computer screen. Visual Basic developers have a ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

If you are an SQL Server database user and want to know how to repair an SQL database table? Look no further!... If you are an SQL Server database user and want to know how to repair an SQL database ...

The performance of a SQL Server table directly impacts the speed and efficiency of data retrieval. This, in turn, affects how quickly your applications can run and serve your users. If your table ...

Part of the SQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates ...

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 ...