SQL Server 2014 is ready to download. Download and Install now

SQL Server 2014 has lots of new stuff. If you worked with SQL Server 2012 it is time to upgrade. If you experimented with SQL Server 2014 CTP1, you need to completely uninstall it.

http://hodentek.blogspot.com/2014/03/you-need-to-uninstall-sql-server-2014.html

Here are some highlights of this edition:

http://hodentekmsss.blogspot.com/2014/03/sql-server-2014-will-be-available-on.html

 

You can download SQL Server 2014 from the Technet Evaluation Center here:
http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx

You can also download the express version here:
http://msdn.microsoft.com/en-US/evalcenter/dn434042.aspx

You get the following programs in the express edition:

• LocalDB (SqlLocalDB)
• Express(SQLEXPR)--Database Engine only
• Express with Tools(SQLEXPRT)---Install & Configure database server+ SSMS
• SQL Server Management Studio Express(SQLManagementStudio)
• Express with Advanced Services(SQLEXPRADV)--includes Full Text Search & Reporting Services

Summary of some basic requirements:

• .NET 3.5 SP1 is a requirement and is not installed by set up.

Download the above from here:

http://www.microsoft.com/en-us/download/details.aspx?id=22

• .NET 4.0 is also a requirement but the installaiton program downlaods and installs it.
• PowerShell 2.0 is also a prerequisite and you have to install it if it is not present.

Operating Systems on which you can install:

Full list can be accessed here:
http://msdn.microsoft.com/en-us/library/ms143506(v=sql.120).aspx#hwswr

• Enterprise and Business Intelligence versions installs only on Windows Servers (2012 and 2008 R2)
• Standard Edition can be installed on Windows 7(x32 and x64) and windows 7 SP1(Ultimate to Professional)
• SQL Developer covers the widest Windows operating Systems.

SQL Express can be installed on above mentioned Servers as well Windows 8, Windows 8.1 and windows 7 SP1

SharePoint on iPad - Microsoft BI

SharePoint on iPad

Microsoft has recently released a Cumulative Update 2011-12 for Microsoft SharePoint that enables consuming Microsoft BI data visualizations on Apple iPad running iOS 5 Safari browser.  Not all visualizations are supported:

VISUALIZATION TYPE	RENDERS ON IPAD
Dashboards (filters, linked elements)	YES
Excel Services (including PPS webpart)	YES
Reporting Services (including PPS webpart)	NO
PerformancePoint ScoreCards	YES
PerformancePoint KPI Details Reports	YES
PerformancePoint Analytic Charts and Grids	YES
PerformancePoint Strategy Maps	NO
Web Page Reports	YES
ProClarity Analytics Server Page Report	NO
Decomposition Trees	NO

Error occurred in deployment step 'Add Solution': A feature with ID {Guid} has already been installed in this farm. Use the force attribute to explicitly re-install the feature.

The fix in Visual Studio 2010 is to double click on the feature and open the feature window. from there use the property window and set the value AlwaysForceInstall="TRUE".

<Feature AlwaysForceInstall="TRUE">
....
</Feature>

Also, you can use power-shell:

Install-SPSolution -Identity <Solution File> -GACDeployment -Force

Start or Stop SQL Server Services using Command Line

You can using the following script to start/stop SQL Server services using command line:

SQL Server Database Engine(both SQL Server service and SQL Server Agent):

NET STOP SQLSERVERAGENT

NET STOP MSSQLSERVER

NET START MSSQLSERVER

NET START SQLSERVERAGENT

SQL Server Reporting Services:

NET STOP ReportServer

NET START ReportServer

SQL Server Analysis Services:

NET STOP MSSQLServerOLAPService

NET START MSSQLServerOLAPService