Microsoft Cloud Roadshow – Hits Copenhagen

The Microsoft Cloud Roadshow is coming to Copenhagen March 3-4, 2016. Space is limited, so register today!

The Microsoft Cloud Roadshow is a free, two-day technical training event for IT Professionals and Developers that provides best practices and insight directly from the experts who build and run the cloud services across Office 365, Microsoft Azure and Windows 10.

PASS Summit 2015

2015-11-02 13_26_18-MailWhoaa, what a week that last one, was attending Pass Summit for the second time, so no “First Timer” ribbon for me, but I met a lot of First Timers and helped them feel comfortable at PASS Summit15. And this is what in my opinion makes this conference a special one, we all take care of each other and try to help out wherever possible, hence the twitter tag #SQLFamily ;o) Continue reading →

CU 4 for SQL Server 2014 ready

sql-server-2014It’s a good day today, the release of Cumulative Update 4 for SQL Server 2014 will fix a lot of small and larger bugs.

Including the painfull one that task would shift to upper left corner in SSIS when resized.

Cumulative update package 4 for SQL Server 2014 (including update for SSIS) is available at http://support.microsoft.com/kb/2999197/en-us

This CU release contains a list of bug fixes for SQL in general, SSRS, SSAS and SSIS.

For SSIS fixes:

FIX: Tasks shift to upper-left corner when you move or resize them while designing a maintenance plan in SSMS 2014

FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS

FIX: SSIS 2012 or SSIS 2014 XML Source task cannot load data from URI

For SSAS Fixes:

FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model

FIX: User obtains incorrect data when two users in the same security role run a client report in SSAS 2012 or SSAS 2014

SQL Performance Fixes:

FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server

SSRS Fixes:

FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012 or SSRS 2014

For the full list look here

Filtering on databases in Management Studio

Ever since I started working with Microsoft SQL server, there have been more than only one database on each of my servers. It can ba a nightmare to manage a installation with more than a few databases, and it is much like when we are working inside a specific database, consisting of hundreds of tables.

It can be a rather large task to pinpoint the excact table, view, function, stored procedure or what have you, but since a few versions ago, we have had the possibility to filter on these objects.

050213_0643_Filteringon1

Like in the picture above, I have made a filter so only tables belonging to a schema containing the word “Human” appears on the list.

Why is it that this feature is not implemented as an option to filter on databases, in some installations, where there are maybe more than 100 databases it would be a real treat to have this option.

Since the code is already implemented as a filter option on other objects, I would have to say that it would be rather easy to implement.

As you can see I am not the only one suggesting this to the SQL server team :

https://connect.microsoft.com/SQLServer/feedback/details/718007/filter-the-databases-list-in-object-explorer-oe-list-in-management-studio

https://connect.microsoft.com/SQLServer/feedback/details/488488/hide-or-filter-databases-in-ssms

https://connect.microsoft.com/SQLServer/feedback/details/497849/ability-to-filter-database-list

https://connect.microsoft.com/SQLServer/feedback/details/270659/filter-databases-in-object-explorer-management-studio

For some reason they have decided to close this suggestion, and will not implement it in a version, they just say they would consider it.