SQL Server Select – Back to Basics

Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...

SQL Server Select – Back to Basics

Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
Related Posts:

Changing Default Logs Directory - Back to Basics...

Failed to Initialize SQL Agent Log... not worthy

Moving system databases in SQL Server takes a bit of practice. I got that again, along with a dose of...

Hidden code in AdventureWorks

I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t...

How to Use Data to Improve Student Outcomes with Microsoft Power BI

Almost fives months ago I joined Microsoft as a Data Platform Solutions Architect. As a DPSA for Microsoft, I am...

If SQL Server Runs on Linux What’s Left for April Fools Day and A Journey Journey

It’s still a bit hard to believe that SQL Server will soon run on Linux. If you think back to...

Power BI Application Embedding Releases Today

A few weeks ago, the Power BI team gave us the ability to freely embed Power BI reports, dashboards and...

SOME BUGS IN SQL-SSRS 2005

Hi Guys
I know sql 2005 is getting outdated and there would be no support from Microsoft from this month. But lets not...

Speaker of the Month: April 2016

THIS IS NOT AN APRIL FOOL POST!
Seriously.
My Speaker of the Month for April 2016 is Keith Tate (b|t) and his...

SQL Developer Edition is now free!!!

Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed...