Thursday, April 16, 2015

FREE e-Book: Explore SharePoint 2013

This fee e-Book "FREE e-Book: Explore SharePoint 2013 " is published by Microsoft Press. This book covers below chapters.

This book covers following Topics
  • IT Professional Reviewer's Guide for SharePoint Server 2013
  • What's new for Business Connectivity Services in SharePoint 2013
  • What's new in eDiscovery in SharePoint Server 2013
  • What's new for mobile devices in SharePoint 2013
  • What's new in records management and compliance in SharePoint Server 2013
  • What's new in business intelligence in SharePoint Server 2013
  • What's new in social computing in SharePoint Server 2013
  • What's new in web content management for SharePoint 2013 publishing sites
  • What's new in workflow in SharePoint Server 2013
  • What's new in search in SharePoint Server 2013
  • Changes from SharePoint 2010 to SharePoint 2013
  • May 2014 cumulative update (CU) changes to SharePoint Server 2013 hybrid
  • Overview of identity management in SharePoint 2013
  • Test lab guides for SharePoint Server 2013
  • Test Lab Guide: Configure SharePoint Server 2013 in a three-tier farm
  • Test Lab Guide: Configure intranet and team sites for SharePoint Server 2013
  • Test Lab Guide: Demonstrate permissions with SharePoint Server 2013
  • Test Lab Guide: Demonstrate profile synchronization for SharePoint Server 2013
  • Test Lab Guide: Demonstrate Social Features for SharePoint Server 2013
  • Test Lab Guide: Demonstrate SAML-based Claims Authentication with SharePoint Server 2013.
  • Test Lab Guide: Demonstrate forms-based claims authentication for SharePoint Server 2013
  • Test Lab Guide: Configure eDiscovery for SharePoint Server 2013
  • Test Lab Guide: Configure a highly available SharePoint Server 2013 Search topology
  • Business Intelligence test lab guides
  • Learning roadmaps for SharePoint 2013
  • Authentication in SharePoint 2013 learning roadmap
  • Learn about upgrade for SharePoint 2013
  • Virtualize SharePoint 2013 learning roadmap
  • Windows PowerShell for SharePoint 2013 learning roadmap
  • User profiles for SharePoint Server 2013 learning roadmap
  • Database management for SharePoint 2013 learning roadmap
  • Permissions for SharePoint 2013 learning roadmap
  • Case study: Cambridgeshire Constabulary
  • Case study: Teck corporate Intranet (SharePoint Server 2013)
  • SharePoint Products for the technical decision maker
Download the e-book using below Link
http://www.microsoft.com/en-us/download/details.aspx?id=35396

Regards
Satishbabu Gunukula

SQL Server 2014:Mission Critical Performance White Paper

This white paper Applies to: Microsoft SQL Server 2014 and SQL Server 2012

As the volume and complexity of data continue to increase, organizations require a new approach to their mission-critical capabilities. In this white paper, we examine how capabilities built into Microsoft SQL Server including enterprise-grade security, availability, and performance, along with support for a full range of complex data types define a “new mission critical” that answers what kinds of capabilities organizations need and expect to compete in a dynamic global landscape. We also compare the cost impact of solutions that offer mission-critical functionality that is built into the core database with solutions that offer separate features organizations can add at additional cost.

Download the White paper using below URL

SQL Server 2014:Mission Critical Performance White Paper
http://www.slideshare.net/satishbabugunukula/sql-server-missioncriticalperformancetdmwhitepaper

Regards,
Satishbabu Gunukula

Free e-Book : Introducing Microsoft SQL Server 2012


This fee e-Book "Introducing Microsoft SQL Server 2012 " is published by Microsoft Press. This book covers below chapters.

PART 1 DATABASE ADMINISTRATION
CHAPTER 1 SQL Server 2012 Editions and Engine Enhancements 3
CHAPTER 2 High-Availability and Disaster-Recovery Enhancements 21
CHAPTER 3 Performance and Scalability 41
CHAPTER 4 Security Enhancements 57
CHAPTER 5 Programmability and Beyond-Relational Enhancements 73

PART 2 BUSINESS INTELLIGENCE DEVELOPMENT
CHAPTER 6 Integration Services 93
CHAPTER 7 Data Quality Services 141
CHAPTER 8 Master Data Services 175
CHAPTER 9 Analysis Services and PowerPivot 199
CHAPTER 10 Reporting Services 229

Download the e-book using below link
http://ligman.me/H8d9P3

Don't miss the opportunity ...!

Regards,
Satishbabu Gunukula

SQL Server 2014: Database as a Service Reference Architecture Guide

This guide explains how to build an infrastructure for hosting Microsoft SQL Server Database as a Service (DBaaS). By using the features of SQL Server 2014 and Hyper-V virtual machines with Microsoft System Center 2012, a hosting service provider can start with very small tenant databases and scale to meet the needs of the largest and busiest SQL Server applications.

This reference architecture includes information about hardware, software, system design, and component configuration

Downland using below link

SQL Server 2014: Database as a Service Reference Architecture Guide
http://www.microsoft.com/en-us/download/confirmation.aspx?id=39295

Regards
Satishbabu Gunukula

Wednesday, April 1, 2015

Enable and Disable xp_cmdshell using SP_CONFIGURE

You can enable or disable xp_cmdshell by using the Policy-Based Management or by executing sp_configure. This option enables system adms to control wheather the xp_cmdshell extended stored procedure can be executed on a system.

By default this is option is disabled on a new installation.

How to enable:
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1;
GO
-- To update the currently configured value for advanced options.
RECONFIGURE;
GO
-- Enable xp_cmdshell feature
EXEC sp_configure 'xp_cmdshell', 1;
GO
-- To update the currently configured value for this feature.
RECONFIGURE;
GO

** User might receive below errow when excuting sp_configure command

EXEC sp_configure ‘show advanced options’,1
GO
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '‘'. 


Note that the syntax is correct, but you might have used wrong character quote.

Run below query to check feature ENABLED or not.
SELECT * FROM SYS.CONFIGURATIONS WHERE Name = 'xp_cmdshell'


How to disable: 

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options',1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- Disable xp_cmdshell feature
EXEC sp_configure 'xp_cmdshell', 0
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

Run below query to check feature DISABLED or not.
SELECT * FROM SYS.CONFIGURATIONS WHERE Name = 'xp_cmdshell'



** Users might receive below error when executing RECONFIGURE command.
Msg 5808, Level 16, State 1, Line 1
Ad hoc update to system catalogs is not supported.


Note that some configuration options require a server stop and restart to update the currently running value." By using “WITH OVERRIDE” you should be able to run successfully.

RECONFIGURE WITH OVERRIDE;
GO
Command(s) completed successfully.

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com.