Changes

This is another not about SQL post. As of march 1st of 2019 I'm working for Axians IoT Operations and are adding value on top of their amazing solution microServiceBus, which connects any device to any IOT hub. Or most major ones at least.

For me this is about changing life, and adding a balance between work and life. In todays' ever changing world it is crucial to reflect over life. I did for sure and am truly grateful for this opportunity.

I will get back to blogging, answering questions at forums, and interact with the community as well as product groups. I will also start blueprinting the book I've been thinking about for years.

More to come...

Yours truly,
Mattias

Inside the fake science factory...

I just saw an interesting DEF CON session. https://www.youtube.com/watch?v=ras_VYgA77Q

Inside the fake science factory, it's about fake news ugly sibling. There are organisations that offer a "platform" for "scientists" to publish their "scientific papers" and hosting "scientific conferences" to gain credibility to the "reports" and "scientists".

See it, it might help you to discover if what you are looking at is published through at least a few of these fake science factories.

Try it, enter below search in your google search. Replace "your search object" with what you want to check up inside the quotes:

"your search object" site:omicsonline.org OR site:sciencedomain.org OR
site:omicsgrouponline.org OR site:waset.us OR
site:waset.org OR site:waet.org OR
site:academicjournals.org OR site:imed.pub OR
site:thescipub.com OR site:austinpublishinggroup.com OR
site:iosrjournals.org OR site:alliedacademies.com OR
site:conferenceseries.com OR
site:sciencepublishinggroup.com OR site:davidpublisher.org

N.B. just because you find "scientific stuff or people" with the search doesn't mean it is fake. It only means they probably made the effort publishing their "science stuff" with a "fake science factory" and that they paid money for it.

Are you missing the Database Diagrams from the new SQL Server Management Studio?

If you just installed the latest preview of SSMS 18.0 you might have realized that the Database Diagrams are gone. The feature is deprecated.

Download the preview here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Scroll down to the SSMS 18.0 (Preview) and try it out, there is also improvements.

So, what to do? Remember there is a bunch of INFORMATION_SCHEMA-views you can use.
This is an example how you can do it, the example is not perfect but help you out a bit.

As Always, I do not take any responsibility for any code you might find on my blog. I write queries for fun and business. Small snippets might end up here.

SQL Server vNext

Just want to tell you all that next awesomeness of SQL Server is available to test out. Check this out, https://www.microsoft.com/en-us/sql-server/sql-server-2019.

Trust me, you will love it!

It's a new year, 2016, and been for a while and SQL Nexus in Copenhagen

Last year, and currently, there are so much work and so little time. Am right now in Copenhagen for SQL nexus and current charging for my session Hi(gh) Availability. Slightly different format on the session than usual, and I'm going to promise to publish the demos as blog posts. That will force me to add stuff more frequently, which is good. And it will force me to plan my hours even more rigorous, which might give me my life back.

Anyways, it's a new year. And a few days ago I was told that the next version of SQL Server will be released on the 1st of June, and over the months after all goodies will be in place.

I can't wait for getting the golden RTM bits, it's going to be a super year.

Cheers,
Mattias

PS: Please check back and comment and request!

New features in Microsoft SQL Server 2016

Sitting on my train home from Microsoft Ignite 2015 in Chicago, IL, USA after 14 hours of travelling and still three hours to go. I’d like to summarize a few of all new features that we probably will get in vNext, i.e. Microsoft SQL Server 2016. At the time being there isn’t a public CTP, but to the summer we’ll probably get our hands on CTP2 which will be the first public preview and sneak peek.

For the BI folks out there in the world I’m going to say: There are investments done in Analysis Services, Master Data Services and Data Quality Services. Power BI is getting closer to On-Prem, Power Query as a Data Source for Integration Services and this is not all. Over the time forward I will elaborate and share my expressions of all the new goodies.

For the DBAs out there, and the DB Devs too, we’re getting tons of new stuff. Think about having a tool that actually persists queries and execution plans, and help us identify parameters, and easily pinpoint execution plans to explicit queries. And expose this together with graphs and statistics. This coolness is called Query Store.

And think about having a Slowly Changing Dimension type 3 alike feature built in into the OLTP engine, and having this ability transparently added to tables we need to keep track of all versions of rows, and as a time machine jump back and forward in time over the data. This is called Temporal Tables.

Is your table growing out of size and you still need to keep everything forever? Think about letting the table stretch cold data to Azure, still keeping it online, transparently and infinitely. Just having the need to have the hot and warm data in the backups, still being able to restore to any point in time have timely snapshots for your restore process. In 2016 the hybrid experience take another step and gives us the ability to stretch an On-Premise table to Azure offering you potential infinite storage.

This is just some, and more will come… I’ll keep you posted!

Over and out,

Mattias

SQL Server 2016 is not that far away... maybe...

Today is an awesome day, during the keynote here in Chicago at the Microsoft Ignite Sataya announced the upcoming and new SQL Server 2016 and that we will get a preview shortly. Read more at this blog, http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx

And if you're in Chicago try to find me...