Click here to monitor SSC

John Magnabosco


John Magnabosco

The Legend of the Filtered Index

0 comments

Once upon a time there was a big and bulky twenty-nine million row table. He tempestuously hoarded data like a maddened shopper amid a clearance sale. Despite his leviathan nature and eager appetite he loved to share his treasures. Multitudes from all around would embark upon an epiphanous journey to sample contents of his mythical […]

6 October 2011 11:52 am by
John Magnabosco

SQL Server MVP Deep Dives Vol. 2

1 comment

The confetti and silly hats, which are quintessential standards of the celebration of a new year, had just been freshly packed away when an email popped up in my inbox. It was Kalen Delaney announcing the call for submissions for upcoming the SQL Server Deep Dives Volume 2 book. Potential authors were challenged to write […]

30 September 2011 3:36 am by
John Magnabosco

SQL Saturday and Exploring Data Privacy

0 comments

I have been highly impressed with the growth of the SQL Saturday phenomenon. It seems that an announcement for a new wonderful event finds its way to my inbox on a daily basis. I have had the opportunity to attend the first of the SQL Saturday’s for Tampa, Chicago, Louisville and recently my home town […]

29 June 2011 2:28 am by
John Magnabosco

Moving Dates

2 comments

At the loading dock, hard working individuals load a semi trailer with your new television, stereo system and personal computer. There is a dependency in this process: it is that your favorite electronics store has a loading dock that will be able to accommodate the size of the semi. If the semi were to arrive […]

24 April 2011 12:32 am by
John Magnabosco

Expanding Influence and Community

1 comment

When I was just nine years of age my father introduced me to the computer. It was a Radio Shack TRS-80 Color Computer (aka: CoCo). He shared with me the nuances of writing BASIC and it wasn’t long before I was in the back seat of the school bus scribbling, on a pad of paper, […]

25 January 2011 2:29 am by
John Magnabosco

SQL Prompt Easter Egg

0 comments

Having Red Gate’s SQL Prompt installed with SQL Server Management Studio has saved me many headaches over the years of its use. It is extremely nice to type in a table name and see not only the column names, but also their data types and identification of primary keys. Another cool feature is the built-in […]

14 January 2011 3:49 am by
John Magnabosco

Embracing Imperfection

1 comment

The pursuit of perfection is a road on which we often find ourselves traveling. It is an unpaved road filed with pot-holes and ruts that often destroy our stride. The shoulders of this road are lined with the bones and rotting carcasses of well planned projects, solutions and dreams of others who have dared the […]

4 December 2010 9:55 pm by
John Magnabosco

Converting Encrypted Values

0 comments

Your database has been protecting sensitive data at rest using the cell-level encryption features of SQL Server for quite sometime. The employees in the auditing department have been inviting you to their after-work gatherings and buying you drinks. Thousands of customers implicitly include you in their prayers of thanks giving as their identities remain safe […]

28 November 2010 3:43 am by
John Magnabosco

Databases and Beer

2 comments

It is a bit of a no-brainer: Include the word “beer” in a subject line of an e-mail or blog post title and you can be certain that it will be read. While there are times this practice might be a ploy to increase readership, it is not the case for this blog post. There […]

13 November 2010 6:42 pm by
John Magnabosco

Return to Sender: Identity Values and Triggers

2 comments

In my previous post I wrote about using the OUTPUT clause of an INSERT statement to obtain the auto-generated identity value of a row. Quickly and easily obtaining the identity value will allow the application to immediately reference the new row or add rows to another table that use the identity value as a foreign […]

3 October 2010 12:03 am by
Older posts