Welcome to Megan’s Space at Far2Go.net. You’ll find a brief introduction to me and this website here.
Reply
A nice, clear presentation. I am probably going to be starting with MVC soon, and this article made a lot of sense to me.
Here we go with developers again. I wonder if the ones that go around creating this particular kind of mess are also the ones that tend to flunk the index/performance quiz?
Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization.
Well at least I “passed” (4 out of 5). Hint: read the questions CAREFULLY.
Never thought of this:
Using hash values in SSIS to determine when to insert or update rows.
What does this have to do with database development? Ever work on a project where people were afraid to talk about what they saw going on? It’s an interesting book, to say the least, and it brings together in one place many “pieces of the puzzle” that I have encountered over the years.
This is a good list of basic security measures you can include when you install SQL Server, very similar to my own.
Really basic, but possibly difficult to remember in detail if you don’t work with the nuances all the time. An excellent review, and some helpful comments on the use of snapshot isolation…
Always an interesting topic — GUID keys.
This looks promising. (Trying to use the built-in connection manager might not work so well.)
Create/write to an Excel 2007/2010 spreadsheet from an SSIS package – SQLServerCentral.