Title15 Aspects of SQL Server Indexes that You Might Not Know WhenApr 16th 2013 at 6:00pm Where NJ SQL Server Users Group Meeting SPS Commerce Inc. 6 Upper Pond Road Parsippany , NJ
Apr 152013
Apr 122013
Abstract You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this demo rich session you will be able to Explain the differences between SQL Servers 9 [more...]
Feb 192013
Do you know what the TRUSTWORTHY database property does to your stored procedure security? Read on to learn more about the behavior of this commonly misunderstood database property.
Feb 052013
One of the most often encountered concurrency problems in T-SQL code happens in the Insert or Use scenario in which a new row is inserted if it does not exist yet and afterwards the primary key of the existing or the new row is returned. One of the easiest and safest ways to get this right is provided by the MERGE statement.
Jan 222013
Last weekend was Philly GiveCamp 3. I got to work on creating a Choropleth Map of Pennsylvania for the Coalition Against Hunger in Philadelphia. Get all the details about the weekend and the project here.
