SELECT * FROM Posts WHERE Date_Posted = 'septiembre 2015'
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…
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…
*First Published @ sqlservercentral.com (2015/01/29) Recently I have come across to an old topic relating to SQL Server security, more precisely to database ownership. I think it is worth revisiting this topic to highlight how an elevated privileges account…
Before I start writing my first SQL Server post, I had to get one of those plugins where you can see your code as you see it in SSMS. You can find some in the same wordpress plugins search engine, I came to one…
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…
Well, it’s very funny that the first post I’m publishing in my SQL Server blog does not talk about SQL Server 🙂 I’d rather tell you how this process has been and what kind of choices I’ve had to do to walk this road down…