Sql

Graph Data in SQL 2017

One of the new features in SQL 2017 is a way to save Graph Data. First time I heard the term “graph” I was stunned… Graph Data? First thing, that came into my mind: “Why would you save charts (graphs)”. Nevertheless, that is not what Graph Data is.

New syntax in SQL 2016 (+ vNext)

SQL 2016 has been released now already since a couple of months. Many of us have been testing it. Even developed applications on it. Or even fully migrated to it on production environments (thumbs up!)

R[101]

What is the buzz about ‘R’?
What is R?
How can I use it?
Where do I use it?
How do I start?

I had all the same questions about it, the first time I heard of it. That’s why I want to…

SQL 2016 — New Features — Dynamic Data Masking

As a running up to the new release of SQL 2016 I would like to share some research I did about the new features that will be available.
Today I want to talk about Dynamic Data Masking. It is a nifty, small but quite interesting new feature.

Query to check size of tables in database

It can be useful to know what tables are consuming alot of storage or has a lot of data.
Especially if you want to clean up your database.

I had to do this at a client and I found following query quite handy

This query returns the table name, the number…

Query all databases on server

[code lang=”sql”]
DECLARE @DbName VARCHAR(100)
 — Sql Query that you want to execute
DECLARE @Sql VARCHAR(MAX) = ‘SELECT * FROM t_alm_lot’