Tags » SQL Server

Universal Database Manager: DBeaver

DBeaver is free and open source (GPL) product

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MongoDB, etc. 90 more words


creating user defined types

Starting from SQL 2008,we have the ability to create user defined table types which is the only way to pass table as a parameter to SQL.Lets see how we can do that.Blog Post is all code and it is heavily commented out,please leave a comment for any queries… 176 more words


Steps to create SQL database at Azure

Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure.

Login into your Azure account and move to portal. 307 more words

Sql Server

Insert multiple rows into a table from another table and get identity values

Let me explain the case first, so you will get the idea when this is required to use. In the database, there is more than one tables which store the future values and will move on specific time to standard tables. 382 more words

SQL Server

SQL SERVER - Availability Group and the Six Critical Steps for DBAs to Follow - Notes from the Field #104

: In this episode of the Notes from the Field series database expert Mike Lawell explains about Availability Group and the Six Critical Steps for DBAs to Follow.   881 more words

SQL Authority

Use Power Shell to execute SQL Server script files

Below is the snippet for using Power Shell to execute list of SQL scripts under a specific folder. I use this script in Octopus deployment to deploy database changes (* for this particular case, we don’t use Code First therefore we don’t use Migrate.exe) 217 more words

SQL Server

Deleting a limited amount off records in MSSQL

It’s been awhile since I’ve done it and today had a need for it. Kept getting “incorrect syntax near 5”

I got bit by the fact that parens are needed around the number value. 38 more words