Category Archives: SQLServer

SQL Server 2016 Management Studio Download

It’s that time of the year. No, I’m not talking about christmas, I’m talking about new product cycles from Microsoft. For SQL Server it usually happens on even years, it’s 2016 so this year we have a new SQL Version. … Continue reading

Posted in SQLServer | Tagged , , , , , , , , , | Leave a comment

Get a taste on the cloud: MS Azure Free Trial

Continuing with the inevitable move to the sky, and trying to self-quote myself here (well, self-post actually), I’m back to tell you that you can have one month of free experimentation with all Azure platform for free. You can set-up … Continue reading

Posted in Azure, BI, Cloud, SQLServer, Windows | Tagged , , , , , , | Leave a comment

SQL Server: ranking your data

This is the kind of query that kills some servers – ranking. It’s a bit hard to make programmers understand how important the performance of their code can have a big impact on server speed – they all seems to … Continue reading

Posted in BI, MongoDB, MySQL, Oracle, SQLServer | Tagged , , , , , | Leave a comment

Some fancy BI stuff: SSIS training, Data Tools add-ins and BIML academy

A few days ago I posted a link to one BIML introduction webcast. Now I now it will be a series of webcasts this week, it’s a great oportunity to learn more about it! Stay tuned and subscribe to the … Continue reading

Posted in BI, SQLServer | Tagged , , , , | Leave a comment

SSIS / Data Tools compatibility between 2014 and 2012

Well, to be simple: there is no backwards compatibility when you create a package in SQL Server 2014 Data Tools (formerly SSIS/BIDS). 2014 files only run on 2014 servers. 2012 on 2012, and that’s it. Microsoft acknowledge this issue but … Continue reading

Posted in BI, SQLServer | Tagged , , , | Leave a comment

BIML first steps

BIML stands for Business Intelligence Markup Language. It adds some things on top of SSIS (SQL Server Integration Services, now called SQL Data Tools, or BI Development Studio, or even DTS – Microsoft should really make up their mind and stop … Continue reading

Posted in BI, SQLServer | Tagged , , , , , , | Leave a comment

SQL Server 2012 SP3 Management Studio Download

Aaaand we’ve got some news regarding the Management Studio download links for SQL Server 2012 Service Pack 3 (see last post about this here). Microsoft released the Service Pack 3 for SQL Server 2012 on November/2015, so right now it’s a … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

How It Works: SQL Server I/O Presentation by Bob Dorr

Once upon a time, in a server farm far far away… enough talk. I was researching some warning messages on my SQL boxes and came to this 2010 paper by one of the  Microsoft Customer Service and Support (CSS) SQL … Continue reading

Posted in SQLServer, Windows | Tagged , , , , | Leave a comment

Tips for Exam 70-462: make your labs using Azure trial

The complexity of certification exams is climbing up lately – up to the clouds. Gone are the days where a simple 3 VM lab was enough to try out every new tech release to newer versions of some product – … Continue reading

Posted in Cloud, SQLServer, VMware, Windows | Tagged , , , , , | 2 Comments

MS SQL: New ways to test disk performance

Sometimes things get easier, better or simples. Actually we became spoiled to expect this kind of evolution from everything in the world, and this is not always the case. But sometimes it is. Jokes aside, a while ago I opted … Continue reading

Posted in SQLServer, Windows | Tagged , , , | Leave a comment