Never thought of this:
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 →
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.
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.
Always an interesting topic — GUID keys. Actual Emails: More Grief for GUIDs – 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.
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.
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 – 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.