InfoWorld

SQL Server 2005’s Schema Problem–An Elegant Solution

There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...
Visual Studio Magazine

Elevate SQL Development with VS Code

Microsoft PM Carlos Robles previews his Live! 360 Orlando session on how recent updates to the MSSQL extension—like GitHub ...
GitHub

A Python-based utility that compares schema structures between two relational databases (SQL Server, MySQL, PostgreSQL) and generates HTML and/or PDF reports showing missing ...

db-schema-comparator/ ├── db_adapters/ │ ├── base_db_adapter.py │ ├── sqlserver_adapter.py │ ├── mysql_adapter.py │ └── postgresql_adapter.py ├── utils/ │ └── hashlib.py ├── templates ...
GitHub

Support for SQL Server schema-prefixed table names

I would like to report an issue regarding SQLx's lack of support for SQL Server schemas (e.g., dbo.table_name). When using sqlx, attempting to query a table with a ...
Visual Studio Magazine

Deleting all Data from a SQL Server Database (Part 2)

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...