Archive for tag: SQL

NEW Elastic Database Jobs: SQL Agent For Azure SQL Database

7 November, 2016 (09:00) | Azure, Azure SQL Database, SQL | By: Mark V

Azure SQL Database is part of a strong, and strengthening overall Data story in Microsoft Azure. The flexibility of the platform, the scalability, both up and out, and the fact that so much functionality is just included all combine to show Azure SQL Database as a great offering. One thing that has been missing that […]

2014 Microsoft Most Valuable Professional (MVP) for SQL Server

1 April, 2014 (10:02) | Professional Development, SQL | By: Mark V

So… This happened: Dear Mark Vaillancourt, Congratulations! We are pleased to present you with the 2014 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in SQL Server technical communities during the past year. I am […]

PASS Summit 2013 Recap of Madness and Mayhem

23 October, 2013 (10:00) | PASS, Presentations, Professional Development, Regional Mentor, SQL, Summit | By: Mark V

Greetings! Another PASS Summit has come and gone. This was my third Summit and I have to say that I am truly hooked on this spectacular event. I had the privilege to be a bit more involved this year than in years past. I love when I can give some of my time and energy […]

Surprise SQL Server 2012 Feature: “It’s Like Siri….For SQL Server.”

1 April, 2012 (10:08) | SQL, SQLComedy | By: Mark V

In conjunction with the official release of SQL Server 2012 today, Microsoft has announced a surprise feature that was kept under wraps for three years. Casper Marley, Senior Program Manager for Microsoft’s newly announced Whimsical Products division put it this way, “It’s like Siri…for SQL Server.” “Siri,” Apple’s intelligent assistant that ships with the IPhone […]

Facing The Challenge: Designing a BI Infrastructure With SQL 2008 (70-452)

21 February, 2012 (10:00) | Books, Professional Development, SQL | By: Mark V

On Monday, Feb 6th, I passed exam 70-452, Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008. Hazzah. I am really excited about that, not because I get a shiny new MCITP certification, but because it validates how much I have learned. When I started working with SQL Server about 5 years ago, I […]

Yes, Virginia, There Is A SQL-Themed Holiday Song

20 December, 2010 (10:01) | Songs, SQL, SQLSongs | By: Mark V

“Dear Mr. VSQL, I am 8 years old. My friends tell me that there are no SQL-themed holiday songs. My Dad says ‘If it’s on the Internet, it has to be true.’ Do you know of any SQL-themed holiday songs on the Internet I can show them?” – Virginia O’Hanlon Virginia, your friends have been […]

Finding Foreign Keys

11 March, 2010 (12:59) | SQL, T-SQL | By: Mark V

No, this is not a new initiative by United States Immigration and Customs Enforcement. I am talking databases. I recently found myself in a situation where I wanted to find all the tables that referenced a particular table via foreign key relationships. I had heard that relying on the built-in dependency tracking (right-clicking the object […]

Jinkies! Passing MultiValue SSRS Parameters To Stored Procedures

5 January, 2010 (13:08) | SQL, SSRS, T-SQL, XML | By: Mark V

SQL Server Reporting Services provides a great way to allows report users to select more than one value from the available values list in parameters, creating a multivalue parameter. SSRS dynamically creates a comma separated list of the values selected by the user to pass in to the data source. Great. It also dynamically creates […]

Enforcing Uniqueness On A Nullable Column

19 May, 2009 (11:04) | T-SQL | By: Mark V

I recently found myself needing to enforce uniqueness on a column which was nullable. To make things interesting, there were already thousands of records for which the field was already NULL and would remain NULL. A unique index on the column was not possible since I had more than one NULL value. I therefore had […]

Using Medians For Quartiling When NTILE Is Too Arbitrary

26 March, 2009 (10:56) | T-SQL | By: Mark V

So, in a previous post on The Coolness of the T-SQL NTILE Function, I discuss that NTILE can perform quartiling (or any other –tiling not requiring a trip to Home Depot) for you. Very cool. However, there is something worth noting about this function that I discovered the hard way. I will continue with my […]