THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 19 (182 total posts) < 1 second(s)
  • SSIS Dashboard v0.4

    Following the post on SSISDB script on Gist, Ive been working on a HTML5 SSIS Dashboard, in order to have a nice looking, user friendly and, most of all, useful, SSIS Dashboard. Since this is a spare-time project, Ive decided to develop it using Python since its THE data language (R aside), its a beautiful &amp; powerful, well established ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on August 19, 2014
  • SSISDB Analysis Script on Gist

    I've created two simple, yet very useful, script to extract some useful data to quickly monitor SSIS packages execution in SQL Server 2012 and after.get-ssis-execution-status&nbsp;&nbsp;get-ssis-data-pumped-rows&nbsp;&nbsp;I've started&nbsp;to use&nbsp;gist since it comes very handy, for this ''quick'n'dirty'' scripts and snippets, and you can ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on July 23, 2014
  • Submitted Abstract Feedback – My 2 cents

    ''WOW. That's exactly the feedback I would have loved to have for ALL my proposals in the past year. And not only for PASS Summit''. No more and no less this is what I thought after having received the mail with all the feedback from the review committee of my PASS Summit proposals. Yeah, sure, I thought it in Italian, but for your convenience, I ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on July 15, 2014
  • PASS Summit 2014 – Agile BI & Agile Data Warehousing

    I'm really happy to be able to announce that I'll be delivering one full-day workshop and a regular session at PASS Summit 2014. Here's the titles and the short summary of my workshop and session: Agile Data Warehousing: from Start to Finish Full-Day Workshop In this workshop you'll learn how to create a Data Warehouse from the beginning to end: ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on July 9, 2014
  • re: On Community and Recognition

    Posted to Argenis Fernandez (Weblog) by Davide Mauri on July 2, 2014
  • re: GUID, fragmentation and performance: the eternal flame.

    @Thomas: the result set was always an empty set...for a very simple SELECT statement as the one used in the test, it should be the same of discarding results (in term of performance), isn't it? @Greg you're right. I'll do the test you both suggest as soon as I can work again on the test machine.
    Posted to Davide Mauri (Weblog) by Davide Mauri on April 7, 2014
  • GUID, fragmentation and performance: the eternal flame.

    In the last months a lot of discussion has been done around the topic of GUIDs and their usage as Clustered Keys. We had a very hot discussion on that several years in Italy, and looking on the web you can see that this kind of question surface gain periodically. Recently I discussed it also with my friend Thomas. Discussion that gave me some ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on April 6, 2014
  • Data Warehouse Advanced Modeling Techniques

    Im yet again pleased to announce that on the next month (19th February 2014) Ill deliver the Advanced version of our Data Warehouse Workshop with my friend Thomas Kejser. The venue will be Stockholm again (really a lovely city) but this time well be at the World Trade Center Klarabergsviadukten 70 107 24 Stockholm, Sweden This is ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on January 20, 2014
  • PowerQuery, ExpandTableColumn and the parent data

    Ive been playing with PowerQuery in the last days and Ive come across the need of accessing parent object data when using the ExpandTableColumn function. The solution is more tricky then one could imagine and I have to say a BIG THANK YOU to Miguel Llopis for showing it me. Now, lets say you have a bunch of files in a directory. All files ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on December 4, 2013
  • re: SQL Rally Nordic & Amsterdam slides & demos

    @Alejandra: sent :)
    Posted to Davide Mauri (Weblog) by Davide Mauri on November 13, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement