Where is BIDS in Visual Studio 2015 or Blend for Visual Studio 2015

I was totally confused when i was finding my favorite BIDS or you can say Visual Studio for SSIS/SSRS/SSAS even when i successfully installed SQL Server 2016 Developer Edition with SP1 along with Blend for Visual Studio Community 2015 and Visual Studio Community 2015 both .

However when i tried to create my new project in SSIS , I was unable to find an option there.Microsoft no longer provides BIDS with SQL Server Installation after 2012 Version. They wants us to do some extra efforts I guess.:P . So what should we do to get our BI features?

Finally i have find out..there is SSDT missing.Its SQL Server Data Tools...So i looked for an independent version for that.I have got it from https://msdn.microsoft.com/en-us/mt186501 or https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt .

 

 Download the installer from there and install English Version on your machine. SSDT will add BIDS in Visual Studio Community 2015.

 That's all we need and it will take
 some minutes.   

Hopefully at least with next release of SQL Server , we will get all necessary tools in one one setup

Just finish your install and then you might need to 

Restart your machine or re-open Visual Studio

 2015 once again and then our favorite BIDS 

will be there .

Where is SSMS in SQL Server 2016 Installation Center

I personally got this issue when i downloaded SQL Server 2016 Developer Edition with SP1 from Miscroft .

I installed everything correctly but could not find SSMS anywhere in machine.So i double checked again to find out how and where i missed it .

So guys refer to below steps to get your SSMS on board .

Step 1:Click on Install SQL Server Management Tools 

Step 2: This link took me to download it from below link.

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

I have chosen English (United States) option to make sure it goes with my correct language.

Step3: Then you have to execute the SSMS-Setup-ENU.exe file .

Cheers !! 

Some Quick Facts of Data Recovery

Its Friday -Fun of Data Recovery Day

Some Quick Facts

Fact 1) Who make sure that each committed transaction will be written to Transaction Log file before actual Data File in SQL Server?

 It’s a Write Ahead Logging (WAL) Mechanism, we call it a Buffer Manager too.It basically maintain ACID property in database.

Fact 2) What is Crash Recovery in SQL Server?

This is Database Recovery Process too which automatically initiate whenever SQL Server restarts, it always cross check as recovery process with the Transaction Log File for any reconcile between Transaction Log File and Data File. If there is any transaction that is been left to write in data file after writing it to transaction log file, it could be possible in case of certain database crash usually will be rolled forward to data file.

Fact 3) What is Redone and Undone in SQL Server?

Redone refers to Rolled Forward in Data Files and Undone is Rolled Back from Data Files.

In Case Transaction is been recorded in Log File but not in data file, it must have rolled forward to Data File and on the other side, if data is being recorded in Data File and not in Log File, it must perform a reverse physical operation on data file as “Undone”.

Fact 4) While performing Differential Database Backup how SQL Server knows which data is been changed after Full Backup?

A bitmap page is been referred in all data pages that contain a BIT for each extent in data files. Here 1 means, in one or more pages in an extent data is been modified since last full backup and 0 means no change. So, that’s how differential backups know which extent to be taken or which ones to leave.