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.
Whoaa, 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 →
Just had my post on Always Encrypted feature in SQL Server 2016 going online at www.sqlshack.com.
This feature will make sure your data is encrypted all the way from the database and to the client application, and back again. Continue reading →
Did you know, SQL Server Management Studio (SSMS) 2016 now have the ability to auto check for updates when you launch it. Actually I already knew it, but had not encountered the update service yet. Continue reading →
It’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
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
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.
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 :
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.