Using hash values in SSIS to determine when to insert or update rows
Never thought of this:
Using hash values in SSIS to determine when to insert or update rows.
Monthly Archives: February 2014
SSIS: Dynamic Processing of SSAS Partitions | Benny Austin
Crucial Conversations Book – VitalSmarts
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 … Continue reading →
SQL Server Security Checklist
This is a good list of basic security measures you can include when you install SQL Server, very similar to my own. SQL Server Security Checklist.
Continue reading →Transaction Isolation Levels – SQLServerCentral
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… Transaction Isolation Levels – SQLServerCentral.
Continue reading →Actual Emails: More Grief for GUIDs – SQLServerCentral
Always an interesting topic — GUID keys. Actual Emails: More Grief for GUIDs – SQLServerCentral.
Continue reading →Create/write to an Excel 2007/2010 spreadsheet from an SSIS package – SQLServerCentral
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.
Continue reading →Five Rules For Successful Conversations With DBAs – SQLServerCentral
Through much of this SQL Server phase of my career I have been both developer and DBA. Yes, I have had these conversations with myself, but it’s time now to think about when the DBA is someone else. Five Rules For Successful Conversations With DBAs – SQLServerCentral.
Continue reading →A genuine use for a SQL CLR Aggregate – SQLServerCentral
An interesting example using a CLR aggregate function to perform linear regression. I’ve done a linear regression within an SSRS custom chart component (to draw a trend line), and I have done text string concatenation using a CLR aggregate, but I never thought of doing this. I don’t know that … Continue reading →
Script Table Data In SQL Server Management Studio
Script Table Data – I have used other tools to do this for ages. I can’t believe that I never knew that it existed in SQL Server Management Studio. Script Table Data In SQL Server Management Studio.
Continue reading →