Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.

This code is used to add a new log file to the database using the alter database command. Method 2-Recover Database from an Existing Backup If you fail to rebuild the corrupted Log files, then you can ...

Enter TST. TST is an Open source Unit Testing framework specifically meant for testing SQL Server Database Code. It helps in following ways - Has an Assertion Framework for testing Database code ...

How to Create Full Database Backup Using T-SQL If you want to automate the backup, you can use the T-SQL code. T-SQL is the SQL Server language used to automate SQL Server tasks. The following example ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

Code Focused Generating .NET POCO Classes for SQL Query Results A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO ...

Hibernate JPA and SQL queries The goal of Hibernate and JPA is to hide the complexity of SQL and relational databases from the software developer. However there are times when a developer must combine ...

Prophecy has announced the release of Prophecy 3.0, to provide first-of-its-kind, low-code SQL capabilities for business data users.

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.

APITable is competing with a handful of rising startups to provide an open-source, visual solution for creating smart, sleek-looking databases.