Programming Microsoft SQL server 2012

catBefore few weeks I got a book from Oreilly Blogger Review program to review a book. I took enough time to read this book. This book covers most of the new trends and features in SQL Server 2012 with good explanation.

I was addicted to first chapter to get to know about the SQL Server Data Tools. Because previously I was studying development things like C# and Visual Studio because of that I was not be able to find out about SQL Server Development Tools. With SQL Server 2012 SQL Server Data Tools were introduced. In first chapter completely describes about SSDT from the point of Developers and Dev DBA’s.

All over the book I didn’t feel like reading a tech book. It is well organized and I felt that I read a story book. But this book is not good for absolute beginners who is looking for SQL Server Development. And this book also balanced one, It doesn’t cover only XML or CLR. Its covering most of the topics with useful things. This is like a essence for database developers who uses SQL Server 2012 or who is planning to use SQL Server 2012.

Each chapter had lot of things to learn. Actually this is a good book. Read it if you are a dev DBA in SQL Server 2012!!! Programming Microsoft SQL Server 2012 was a pretty interesting book for me.

Did you tried to install SQL Server 2012 on Windows Server 2012?

Recently I tried to install SQL Server 2012 in Windows Server 2012 box. Unfortunately it was not easy to do that for me because setup generated few errors. And then I it displayed that .NET Framework 3.5 SP1 Feature was not able to activate. There were few reasons to occur that problem.

  • Windows Server 2012 was not activated.
  • Windows Server 2012 was unable to access internet (When it is activated).

So first I realized when I tried to manually activate this feature, that I have to activate my Windows Server 2012. Then I activated my Windows Server 2012. Then I again tried to activate .Net Framework 3.5. But unexpectedly again I got failed. Then I checked what was wrong with my computer and why this installation got failed although I had inserted the installation media.

Error was like this.

Troubleshooting101-01

Then I found in the internet that we have to show the path of the binaries to activate this feature.

1. Then I opened Server Manager and then Manage –> Add Roles and Features.

Troubleshooting101-02

2. I followed the wizard normally.

Troubleshooting101-03

Troubleshooting101-04

Troubleshooting101-05

Troubleshooting101-06

3. Then I selected .NET Framework 3.5 from features window.

Troubleshooting101-07

4. Then I got this dialog box.

Troubleshooting101-08

5. But be careful and don’t click “Install”. If you click Install it will look up for internet connection. If there is not internet connection it will fail your setup.  Click on “Specify an alternate source path”.

net3installsourcesrvmanager

6. And then give your installation media folder plus “\sources\sxs”. It may be a share or DVD no matter whatever it is. Then Click OK and Install. It will activate .NET Framework 3.5 on your Server 2012 installation.

I found those pictures from sqlcoffe.com. And I saw that he has also tried in this way and get failed because he hasn’t specify the path of installation media. But he has an alternate method. I’’ll share it here too.

He had opened a cmd window. and had typed this command.

dism /online /enable-feature /featurename:NetFx3 /source:d:\sources\sxs

Troubleshooting101-09

You can replace “d:\sourced\sxs\” with your path of installation media. Then I tried to install SQL Server 2012. Installation was successfully finished.

Pictures: http://www.sqlcoffee.com/Troubleshooting101.htm