How to change the Sql Server backup folder

Scenario proposal
When you install SQL Server the path for the installation is generally something such as the following: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL.

In this directory there are also folders for your DATA files and also your BACKUP files.  Within SQL Server Management Studio you have the ability to change the default location for your Data and Log files for all new databases, but you can not change the default directory for your backups.

Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?

Continue reading How to change the Sql Server backup folder

Sql Server 2014 a game changer – Part 1

There are 3 factors that can transform Microsoft Sql Server 2014 into a real game changer and I'll go through each of them in brief details below :

1. Mission-Critical Performance

Continue reading Sql Server 2014 a game changer – Part 1

What is Hadoop ?

Here are 2 videos that explain in details what is Hadoop and how was invented. Continue reading What is Hadoop ?

How to determine what edition Microsoft Sql Server you have installed

To determine what edition  of Microsoft Sql Server you have installed you have to start Sql Server Management Studio and run the following query : Continue reading How to determine what edition Microsoft Sql Server you have installed

Microsoft Announces Launch of MTA Exams Today!

MTA, the Newest Certification in the Microsoft Technology Stack now available at Prometric Test Centers

Description: Description: cid:image002.png@01CDD473.07F6BA30Today, (December 11th, 2012), Microsoft announced the launch ofMicrosoft Technology Associate (MTA) certification to the commercial space, consisting of 12 exams for new entrants to the IT space. www.prometric.com/microsoft/mta.

These are available now and are accessed like every other Microsoft exam through TC Flow. All MTA exams have a 98-prefix.www.prometric.com/microsoft/mta

MTA’s been a huge success in the academic world, because it fills the entry-level gap between aspiring technologists (of all ages) and those IT Professionals using Microsoft technology on the job today. Learn more about MTA exams: (www.prometric.com/microsoft/mta) Continue reading Microsoft Announces Launch of MTA Exams Today!

%d bloggers like this: