SSIS – Starter kit for the uninitiated – Data enrichment

In this last post (after which there will be a video explaining how to bring all this together in Power view) I cover how to convert geo coordinates from 38° 53′ 55.133″ N to Decimal Coordinate system 38.898648. You can find the previous posts here. The calculations is fairly simple the sql for it is…

SSIS – Starter kit for the uninitiated – Foreachloop

I was up at 3:00 AM in the morning and felt that the world needs to know where all the airports are and how you could use SSIS and PowerView to display this information in a clean and concise way. This need was so powerful that I spent the next 4 hours writing an SSIS…

OStress.exe – use it if you aren’t already

I was recently trying to simulate the performance implications of hashing vs encryption and wanted to simulate hundreds of sessions and 1000’s of requested on a username/password table. Most time developers and testers use a test harness for automating this kind of activity or use a load testing tool. I however am not a tester…

Restoring the database using TSQL command and backup stored in URL

In this post we cover the T-SQL command used to restore the database from the backup URL RESTORE DATABASE madworks FROM URL = ‘https://ebsclouddbstore.blob.core…….madworks_backup.bak’ WITH CREDENTIAL = ‘Azureblobbackups’ ,STATS = 5 — use this to see monitor the progress The output shows the time taken to restore the database, a sloppy 2 seconds for a…

sys.Dm_db_database_page_allocations()

This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a table. The advantage of the DMV is that it’s readily portable and provides a more complete picture of the allocations of the pages to the object it…