Tags » SQL

A Fireside Chat with a Microsoft SQL Technical Specialist...What's new and how you can profit from Microsoft SQL Enterprise

I had the opportunity to sit down with Sarah Barela, SQL Server Technical Specialist at Microsoft. She’s very passionate in her role and without question a great resource. 1,473 more words

Microsoft SPLA

Creating JSON documents with MariaDB

You probably know about two MariaDB great features: Dynamic Columns and Virtual Colums. I don’t think that we already found all possible use cases for them: more ideas will come in the future, and hopefully someone will write about them. 831 more words

SQL

Find no of active connection in SQL

Find no of active connection in SQL. Just change the name of the database according to your envoirnment.

select
db_name(dbid) as ,
count(dbid) as , 20 more words

Database

Find out if your database was overwritten or restored

I had a situation where i had to find out that the database was overwritten or restored and it can be done using below query:- 80 more words

Database

Entity Relationship Diagram

Entity Relationship
An Entity Relationship Diagram is the easiest way to represent a complicated database system. This diagram is mostly used to represent the relationship among different attributes and their contribution to database system. 126 more words

Sql

SQL SERVER - FIX - The term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet

It’s always a fun to learn and share new thing which I learn about any technology. So I decided to spend my weekend at home quietly, so I could learn some scripting using PowerShell and SQL Server. 442 more words

SQL Authority