Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...
There’s a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...
How effective are free and open source data bases? For answers, we reviewed 6:: Microsoft SQL Server Express, PostgreSQL, Oracle's MySQL, MariaDB, Apache Derby and Firebird SQL. Free or open source ...
In a previous blog entry, I talked about the new FILESTREAM data capability in SQL Server 2008 where we can store Binary Large Object (BLOB) data on the file system but have it transactionally part of ...