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 […]
ETL 2 million rows – Comparison of BULK INSERT, BCP, OLEDB, ADO NET, OPEN ROWSET, SQL Server Destination task
A quick video comparing the performance of different ETL options when importing 2 million rows into a database. All tasks use the BULK Logged Options where possible. ETl […]
Why I don’t have a lot of personal info on the internet- OLAP – BIGDATA and the future of privacy
I was asked this question while having a chat with a few friends. Mainly the complaint was I don’t have a lot of social media presence. The only […]
You can now create nonclustered indexes on the Clustered Columnstore index
This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that […]
SQL 2016- Live Query Stats
I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 […]
Drawing a graph in SQL Server Management Studio
Had some spare time today so I used it to finally get around to a small project I had in mind. The intention is just to do it […]
SQL 2016- Activity monitor – Active Expensive Queries
Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. […]
SQL 2016 – Updatable Columnstore Index finally OLTP and DW workloads delivered
So SQL 2016 comes with updatable non clustered columnstore index. Are you wondering why this is a big deal. It is and here’s why In SQL 2012 the […]
Fill Factor and Page split demonstrated
Recently on one of the popular SQL Forums I read a post by a DBA who seemed experienced but still had a poor understanding of fill factor and […]
Some new screens you will likely encounter when installing MS SQL 2016
Here a screenshot by screenshot tour on installing SQL 2016, please keep in mind that this is a CTP (preview) so the screens may differ from RTM – […]