SELECT *
FROM Posts
WHERE Tags IN ('AdventureWorks')

mar
10
2016

SQL Server 2016, playing with DATABASE SCOPED CONFIGURATIONS

It’s been a few days since SQL Server…

Continue Reading »

nov
2
2015

Day 1 @ AdventureWorks, the Solutions

It’s been a while since I published Day 1 questions and I guess it’s time to post the answers I came up with. That doesn’t mean my solutions are the only possibles, and in some cases I’ll provide more than one answer taking different approaches….

Continue Reading »

sep
14
2015

Day 1 @ AdventureWorks, some basics about SELECT, JOINS and more

The first day of this journey we’ll work on the most basic statement I can think of, the SELECT statement. Exercises are growing in difficulty, from the most basic to others a bit more complicated, where you’d get data from more than on table in the…

Continue Reading »

sep
13
2015

Day 0 @ AdventureWorks, setting up AdventureWorks sample database

I wasn’t planning writing this post, because there are tons of resources available on the internet, but since I want to create a comprehensive series of exercises, starting from the very basic, I understand most people interested on doing them, might have limited…

Continue Reading »

sep
9
2015

Welcome to your new office!

Hi there! Welcome on board, you’re the candidate we have chosen to cover the junior DBA opening. Does it sound any good? Perfect, it doesn’t really matter whether you have some knowledge on relational databases because here I’ll try to cover most…

Continue Reading »