nhaslam.wordpress.com

blog.nhaslam.com

VS2010 | Dev Blog

https://blog.nhaslam.com/category/microsoft/vs2010

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! DDD9 – My thoughts. Mdash; Leave a comment. On Saturday, it was DDD9 ( http:/ www.developerdeveloperdeveloper.com/ddd9. For me, and a lot of feedback I’ve seen on Twitter, it was the best DDD yet. There were six sessions over four tracks, covering a wide range of topics and there seems to be a pretty good turn out. This was the best sess...

blog.nhaslam.com

VS2012 | Dev Blog

https://blog.nhaslam.com/category/microsoft/vs2012

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Filed under: SQL Server. Mdash; 2 Comments. Having recently been playing with the newly released Visual Studio 2012, one of the really nice features that I’ve seen is the Database Schema Comparison functionality. If you’d like to follow along with this, you’ll need the ContosoBI database, which is available here. My next step was to conn...

blog.nhaslam.com

VS2008 | Dev Blog

https://blog.nhaslam.com/category/microsoft/vs2008

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Playing with new toys. Mdash; Leave a comment. Recently I’ve had the need to create a new website, to host various sets of media files (including pictures and videos). I’ve been wanting for a while to have a look as ASP.NET MVC. So this was a great opportunity. I created a website ( http:/ nhaslam.com/primus. Mdash; Leave a comment.

blog.nhaslam.com

Windows O/S | Dev Blog

https://blog.nhaslam.com/category/microsoft/windows-os

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Filed under: SQL Server. Mdash; Leave a comment. Having spent some time creating posts and doing some work on Virtual Clusters, I saw that Jonathan Kehayias from SQL Skills. Had also done a set. They are linked below:. Building a Completely Free Playground for SQL Server 2 Setting up Active Directory and the iSCSI Virtual SAN. Part 1 of ...

blog.nhaslam.com

Presentations | Dev Blog

https://blog.nhaslam.com/category/events/presentations

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! SQL Server and the CLR Slides. Mdash; Leave a comment. Last night I had the opportunity to do my first community presentation, at the SQL Server in the Evening. Event, hosted by Gavin Payne. Thanks to both of you for the opportunity to present. The slides from the session are available here: SQL Server and CLR Session Slides. Build a web...

blog.nhaslam.com

C++ | Dev Blog

https://blog.nhaslam.com/category/c-2

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Presenting in Spring… #sqlserver #sqlclr. Mdash; Leave a comment. Having been sitting on the fence for a while, I’m finally leaping off, and presenting at some community events. Following a false start with SQLBits. I submitted, but wasn’t voted in, and given the number of attendees I’m a little relieved about that! Hope to see you there!

blog.nhaslam.com

UnSQL Friday | Dev Blog

https://blog.nhaslam.com/category/events/unsql-friday

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Un-SQL Friday #004: Speaker Lessons Learned. Mdash; 1 Comment. So all about something SQL-Adjacent. This month, something related to Lessons learned as a speaker. Ok, so that’s much easier than the last one I took part. In I’ve done a couple of presentations, and the first, well, that wasn’t so great. What I’d done was write down w...

blog.nhaslam.com

SharePoint | Dev Blog

https://blog.nhaslam.com/category/microsoft/sharepoint

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Loading Reference Data from a SharePoint List using SSIS. Mdash; 5 Comments. Recently, I’ve been working on a project where the reference data is stored in SharePoint lists. While it is possible to get the information out of the SQL Server database directly, using something like the T-SQL below, it’s a bit messy. DboUserData.tp ID,.

blog.nhaslam.com

MCMPrep | Dev Blog

https://blog.nhaslam.com/category/certification/mcmprep

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Reinstalling and Slipstreaming SQL Server. Mdash; Leave a comment. Sounds straightforward doesn’t it. It wasn’t. The resolutions to these issues were around corrupt registry settings (I cleaned those out), corrupt setup files (I changed the install location, which seemed a little random, as a fix) and corrupt ISO images (downloaded a fre...

blog.nhaslam.com

Cloud | Dev Blog

https://blog.nhaslam.com/category/cloud

Thoughts on SQL Server, MS BI, Coding and other random bits…. Thanks for dropping by Dev Blog! Take a look around and grab the RSS feed. To stay updated. See you around! Fun with TPC-H (Part 2b) – AWS RedShift. Mdash; 2 Comments. This is the third article I’ve done on the TPC-H benchmark, and part 2 on AWS RedShift. Read the first article here. And the first part on AWS Redshift here. Copy orders from ‘s3:/ oldnick-tpch/orders.tbl.gz’ CREDENTIALS ‘aws access key id= Your-Access-Key-ID ;aws secret...Copy ...