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 as SQL 2016 is the current version, there is no hope for 2014 users. So you have to stick to 2012 tools if your servers are living in that version. I have lived on 2008 long enough, so that’s not gonna be a problem, but for anyone trying to show new things to the boss in order to make the company bite the bill for a new version, this is bad news.

There are a couple of work-arounds, of course: Vanie Castro found some stuff inside the XML files, and Verena expanded upon it.

By the way, MS should make it easier for us to sell their products, but they don’t. Maybe someday.

cya!

Advertisements
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 changing this product name).

Its used to automate and simplify some tasks in the BI world, with a strong focus to save time creating and maintaning SSIS packages used in the ETL steps of any BI project. You know, SSIS is not strictly for use with SQL Server, it can read any data source and write to any other DB engine too. So even if your project is not related to SQL directly, you can benefit of it.

I follow the folks from http://www.sqlservercentral.com/ and received the news of a free webinar to learn BIML. It’s available at the Biml Academy. It’s free and a great oportunity to learn it. The date will be May-09, at 01:00pm EDT.

You can read an introduction to BIML here. Go on. Subscribe now. Knowledge is never too much.

Link to webinar: http://andyleonardconsulting.enterthemeeting.com/m/JCNAMVF8

cya!

 

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 good time to get the latest SP and tools for it. With the development now focused at SQL 2014 and SQL 2016, this could be the final big Service Pack for SQL2012.

As before, the key is looking for the SP3 download page, and then select only the minimum file you will need. For most users, that will be “ENU\x64\SQLManagementStudio_x64_ENU.exe”. Some people may need the other packages, but those folks should know what they are looking for already. There goes the new link:

https://www.microsoft.com/en-US/download/details.aspx?id=50003 (no direct link this time, folks).

cya!

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 Support team members. It is a really great presentation about SQL Server IO needs and, well, how it works.

http://blogs.msdn.com/b/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation.aspx

Read it, read it, read it.

ok, now cya!

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 – SQL Server in this case.

Article: http://www.sqlservercentral.com/articles/certification/128503/
Read it, do it. Practice, practice, practice. You can even try some PowerShell on this setup.

Course: https://www.microsoftvirtualacademy.com/en-US/training-courses/administering-microsoft-sql-server-2012-jump-start-8259

You can try this too: https://technet.microsoft.com/en-us/virtuallabs (I will do it myself later).

You can always go the DIY route and use VMs on your home computer, but it is good to get a feeling for administering something in the cloud – there are clouds everywhere lately, really.

PS: but I will do it in my home too, of course, so I won’t loose my setup in case of rain…

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 for simpler tools to do performance tests that are easier to translate into real-world examples, and recently one of these tools has got a revamp in functionality and this new and updated version is worth testing.

The tool is CrystalDiskMark, wich has been updated in version 4 to use a new framework to do it’s testing (Microsoft DiskSpd).

It’s good to be able to keep it simple, but if we need anything more detailed you can also go directly to the bones of it and use the new DiskSpd directly and with more control. This is a great article that I wanted to share with you, please take your time to read it and apply it to your database servers: http://sqlperformance.com/2015/08/io-subsystem/diskspd-test-storage

cya!

 

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

Get all job steps in SQL Server

You never know when you will need to get all the jobs steps in a hurry. This is a great script for this situation.

Sufian's Diary

Someday you might need to see the steps of any specific job or find in which step of which job does a specific query is used. Confused!

Following query will show you all the steps of a specific job having a specific query in any of its steps.

SELECT JOB.NAME AS JOB_NAME,
STEP.STEP_ID AS STEP_NUMBER,
STEP.STEP_NAME AS STEP_NAME,
STEP.COMMAND AS STEP_QUERY,
DATABASE_NAME
FROM Msdb.dbo.SysJobs JOB
INNER JOIN Msdb.dbo.SysJobSteps STEP ON STEP.Job_Id = JOB.Job_Id
WHERE JOB.Enabled = 1
AND (JOB.Name = ‘%Job_Name%’ OR STEP.COMMAND LIKE ‘%Exec AnotherStoredProcedure%’)
ORDER BY JOB.NAME, STEP.STEP_ID

View original post

Posted in Uncategorized | Leave a comment

New year, new post, new MongoDB

Everytime I think of MongoDB I remember Sheldon Cooper playing Bongo on TBBT tv series. Just for fun, because of the sound of the words.

But to start a new year nothing better than a new DB system. Please take a look at the announcement page for MongoDB 3.0.

https://www.mongodb.com/blog/post/announcing-mongodb-30

PS: this image did not scale well… what an irony!

cya!

Posted in Uncategorized | Leave a comment

Last post of the year: SQL Server 2014 Checklist for Performance

I would like to share these kind of things directly from SqlServerCentral, and not only posting links. But linking seems the best way to do it currently. Also I decided to increase that post count to 20 (yea, the yearly stats are post #19). Just for the fun of it 🙂

Be sure to read these quick tips (and discuss in the forums) because it may help you more than you can imagine. This is a greate piece by Rudy Panigas.

http://www.sqlservercentral.com/articles/Performance/119308/

I would like to add two little tips:

  • Keep your app data on a single database. Cross-database queries are bad.
  • Forget that Linked-Servers exist. Use other technology instead.

cya all next year!!!

Posted in SQLServer | Tagged , , | Leave a comment

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. (They did not have much work, only 18 posts this year. Gotta increase that number.)

Here's an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 90,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 4 days for that many people to see it.

Click here to see the complete report.

Posted in Uncategorized | Leave a comment