https://weblogs.sqlteam.com/lucaz/ Recent content on Luca Zavarella Blog Hugo -- gohugo.io nospam@nospam.xyzasdf (Luca Zavarella) nospam@nospam.xyzasdf (Luca Zavarella) Copyright © 2018 - Luca Zavarella Tue, 12 Jun 2012 14:59:32 -0500 https://weblogs.sqlteam.com/lucaz/2012/06/12/how-to-use-a-list-of-values-in-excel-as-filter-in-a-query/ Tue, 12 Jun 2012 14:59:32 -0500 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2012/06/12/how-to-use-a-list-of-values-in-excel-as-filter-in-a-query/ It often happens that a customer provides us with a list of items for which to extract certain information. Imagine, for example, that our clients wish to have the header information of the sales orders only for certain orders. https://weblogs.sqlteam.com/lucaz/2012/06/05/how-to-update-all-the-ssis-packagesrsquo-connection-managers-in/ Tue, 05 Jun 2012 12:16:00 -0500 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2012/06/05/how-to-update-all-the-ssis-packagesrsquo-connection-managers-in/ During the development of a BI solution, we all know that 80% of the time is spent during the ETL (Extract, Transform, Load) phase. If you use the BI Stack Tool provided by Microsoft SQL Server, this step is accomplished by the development of n Integration Services (SSIS) packages. https://weblogs.sqlteam.com/lucaz/2012/04/02/bids-helper-1-6-beta-released/ Mon, 02 Apr 2012 14:42:00 -0500 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2012/04/02/bids-helper-1-6-beta-released/ A new version of this fantastic tool, used by Microsoft BI Stack developers, is out. Now it’s compatible with SQL Server 2012. In this post, Teo Lachev gives us more details. https://weblogs.sqlteam.com/lucaz/2012/02/06/new-release-of-quotolap-pivottable-extensionsquot/ Mon, 06 Feb 2012 12:20:16 -0600 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2012/02/06/new-release-of-quotolap-pivottable-extensionsquot/ For those who are not familiar with this add-in, the OLAP PivotTable Extensions add features of interest to Excel 2007 or 2010 PivotTables pointing to an OLAP cube in Analysis Services. https://weblogs.sqlteam.com/lucaz/2012/02/02/how-to-import-in-bids-more-than-one-ssis-package/ Thu, 02 Feb 2012 21:27:14 -0600 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2012/02/02/how-to-import-in-bids-more-than-one-ssis-package/ Have you ever wanted to add more than one Integration Services existing package (e.g. 20 packages) in a SSIS project? Well, you may suppose that an Open Dialog supports multiple files selection to import more than one file at a time . https://weblogs.sqlteam.com/lucaz/2011/12/10/letrsquos-keep-informed-with-ldquodata-explorerrdquo/ Sat, 10 Dec 2011 13:39:20 -0600 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2011/12/10/letrsquos-keep-informed-with-ldquodata-explorerrdquo/ At Pass Summit 2011 a new project was announced. It’s a Microsoft SQL Azure Lab and its codename is Microsoft “Data Explorer”. According to the official blog (http://blogs.msdn.com/b/dataexplorer/), this new tool provides an innovative way to acquire new knowledge from the data that interest you. https://weblogs.sqlteam.com/lucaz/2011/11/09/versione-2-di-sql-treeo-rilasciata/ Wed, 09 Nov 2011 09:34:40 -0600 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2011/11/09/versione-2-di-sql-treeo-rilasciata/ A new SQL Treeo update is available at http://www.sqltreeo.com. Lot of bugs fixed so now it seems to be a stable add-on for SSMS. The full change log is available here: https://weblogs.sqlteam.com/lucaz/2011/08/29/running-your-ssms-client-as-a-domain-user/ Mon, 29 Aug 2011 22:46:58 -0500 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2011/08/29/running-your-ssms-client-as-a-domain-user/ I wonder if it is possible to use the SQL Server Management Studio (SSMS) client on my machine with a specific domain user when my machine wasn’t in that domain. In fact, many developers use some SSMS add-ons installed on their machine (with appropriate licenses), which greatly simplify their daily work. https://weblogs.sqlteam.com/lucaz/2011/08/28/custom-folders-in-ssms-object-explorer-yes-we-can/ Sun, 28 Aug 2011 17:09:14 -0500 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2011/08/28/custom-folders-in-ssms-object-explorer-yes-we-can/ When you have a huge objects’ number in SSMS Object Explorer, you often get lost in finding items. So it’d be useful to catalog those objects in folders, in order to follow an application’s logical layer subdivision, for example. https://weblogs.sqlteam.com/lucaz/2011/08/20/online-introduction-to-relational-databases-with-stanford-university/ Sat, 20 Aug 2011 15:06:37 -0500 nospam@nospam.xyzasdf (Luca Zavarella) https://weblogs.sqlteam.com/lucaz/2011/08/20/online-introduction-to-relational-databases-with-stanford-university/ How many of you know exactly the definition of "relational database"? What exactly the adjective "relational" refers to? Many of you allow themselves to be deceived, thinking this adjective is related to foreign key constraints between tables.