My online presences include: Tech Blog: Marlon Ribunal - SQL, Code, Coffee, etc. Productivity & GTD Hack Blog: Productivity Bits Twitter: @MarlonRibunal
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all the days that he missed.
The expected result would look something like… Read more
Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions with OVER(), etc.). You can manipulate partitions of rows on the fly with Window Functions.
I’ve seen how complicated queries that require recursion were simplified by using combination… Read more
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last year. That didn’t happen. At the start of this year, I made that same commitment again. Neither did that happen. At that time, I told myself there’s still a lot… Read more
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at the same time.You can register and manage any servers but only those in SQL Server versions 2008 and higher can be designated as Central Management Server. You can execute… Read more
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable external hard drive. So after a while of not starting up the host laptop, I could not start any of the machines. First, I noticed that the state… Read more
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual SQL Playground Adventure blog series came to life.
In the introduction I promised to document everything but did not do a follow up blog post after that. That doesn’t mean… Read more
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource movement. Reporting is an important component of Business Intelligence (BI). Therefore, perceptive implementation options of the reporting portion should be considered. Data analysis and integration become pointless if they lack… Read more
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have been collaborating on for months. Packt has published this title under their Blueprints Series.
What exactly is a Packt Blueprints Book?
“Blueprints are basically in… Read more
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may also be a bold, usually risky undertaking, with an uncertain outcome.
That is exactly what this series is all about. I can’t tell you how… Read more
The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical network adapter (wifi) via the External Virtual Switch that I setup in Hyper-V (Windows 8 Pro host). I can connect to the internet to do Windows updates on those VM’s. Read more
How many lines of TSQL codes and Window Functions you need to come up with this?
R, it takes about 2 commands:
> order <- as.matrix(sqlFetch(ch,"SalesDetails") > summary(order)
To give you an idea, I prepared the dataset into a view like this:
CREATE VIEW SalesDetails AS SELECT soh.OrderDate…
I’ve got plenty of SQL Server books at home (physical and Kindle versions). But if I’m not in the mood of reading a tech book but itching to read anyway, I’d… Read more
Joe Lacob bought the struggling Golden State Warriors NBA franchise in 2010. He has been the most hated man by the Warriors fan base since then.
Lacob promised the fans he would turn the franchise around and get it back to the winning edge.
To set the wheels in motion,… Read more
I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos are great learning aids. Having the right tools and method makes a lot of difference. Building a SQL Server VM Playground to put the lessons in practice is a vital… Read more
There is something about the Silicon Valley that attracts the innovative and creative individuals. The “misfits, rebels, troublemakers, and the round pegs in square holes” come here as dreamers and leave the valley as
billionaires world changers. The Silicon Valley provides the opportunity and platform to make a difference for… Read more
This book project got its second life. I am now collaborating with another author to bring this book to completion.
I was super excited when I received an invitation to write a book on SSRS 2012. Writing a book has been in my bucket list for as… Read more
I’m in the middle of writing the first chapter of my book. I’m not just ready to announce the working title yet. I’ll probably wait until I finish the 5th chapter (total of 10 chapters).
I thought it would be fun if I open up my writing process so… Read more
Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to your device locally. That is cool because you can still work on your files even when you’re offline.
The thing is I don’t need all the… Read more
There are things that I’m thankful for this year. Yes, I also got a lot of setbacks but that wouldn’t make me less thankful.
I’m thankful for my family as always. No words can ever describe how thankful I am for the gift of family.
I’m also thankful for my… Read more
I needed to upgrade my tools. It was not a matter of “want” but of “need”. It’s no longer enough to have just the bare minimum, specially when you need to test or study about certain features of SQL Server that require multiple servers in a network environment.
My current… Read more