Skype for Business
See all products »
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
culture independent format
network bind order
SQL 2008 R2
SQL Server Configuration Manager
SQL Server SQLServer 2008R2
User-Defined Server Roles
Browse by Tags
SQL Alias PowerShell script
Hello everyone, this time I am going to show the "Server Alias". I have been asked by one of my customers to write down a PowerShell script to add an SQL Alias as part of an automatic installation. The Alias is stored in the registry at this path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer...
31 Mar 2014
Four Tips for SQL tuning for SharePoint Part 1 - MAX DOP
Lately I have been thinking about some of my latest work; mainly I have focused on an one day work shop with one of my colleagues, Amir, who is a SharePoint PFE. Now I’d like to share with you some of the SQL Best Practices for SharePoint. In this post, we will talk about MAXDOP and why MAXDOP...
1 Feb 2012
Target Recovery Time - new database option in SQL Server 2012
Recently I’ve created a new database on my SQL Server 2012 instance. I reviewed the new database options before creating. One of the options that I’d like to share today is “Target Recovery Time” in seconds or TARGET_RECOVERY_TIME. Target Recovery Time is new in SQL Server...
13 Jun 2012
SQL Server Service Packs and Cumulative Updates List
See below SQL Server Service Packs and Cumulative Updates List. It will be updated monthly.
23 Feb 2012
A while ago, I was asked by customer how to tell if an instance parameter is dynamic or rather static (which requires me to restart the instance service). Parameters like fill factor (%) or max degree of parallelism . Does this parameter exist in the short list or do I need the show advance option ?...
10 Dec 2013
Check your SQL – default Trace
Every installation of SQL has a default trace. The default trace was introduced in SQL 2005, It is the same trace that we know from the profiler or server but it is a preconfigured trace that is enabled as default. The default trace create five *.TRC file that are been recycle when they arrive to 20...
21 Jan 2013
Did you know , Dead locks can be track from the System Health in SQL 2012
Before using SQL server 2008, in order to capture a deadlock, we had to create a server side/profiler trace or use trace flags 1204, 1222. If you were lucky enough to work with SQL 2008/2008R2 you could have tried using XEvents (which were introduced in SQL 2008). SQL Server 2012 added a new feature...
27 May 2013
Recovery model is our way to instruct SQL Server how to maintain the log file. We have 3 recovery models in SQL Server – SIMPLE, BULK_LOGGED and FULL. We’ll review them and describe the differences between them. SIMPLE recovery model When the database recovery model is set to...
13 Mar 2012
Startup parameters in SQL 2012.
SQL 2012 brings us new options and cool features, one of these features is the startup parameters. On previous versions; when we needed to update a startup parameter for the database, we needed to go to the configuration manager and then in under the SQL server service we were able to add in a line with...
18 Apr 2012
Where is the Help in SQL 2012? F1
In SQL 2012 the BOL (Books Online) are only located on the internet. When you press F1, you are redirected to the web, so what can we do in a closed environment, where my production server is not connected to the internet and I need the F1? Checking for help regarding the sys.dm_exec_cursors system table...
28 Apr 2013
SQL & SIDs why we need it and what the hell is it?
Service SID and Or ice age Sid Lately I was asked about service SID during the installation of SQL 2008 Cluster. So I thought about it and wrote this blog post: During the times of SQL 2005, while installing SQL in a cluster configuration we needed to assign elevated permission to a domain group...
16 Feb 2012
The scenario of a missing SA password:
You are the senior DBA of your organization, responsible for all the databases that hold the critical info. In order to secure the environment and the databases, you performed the next recommended steps: 1) Remove all built-in admin account from SQL Server logins. 2) Remove all users from SYSADMIN...
22 Jul 2013
Four Tips for SQL tuning for SharePoint Part 2 - Shrink DB
SharePoint DB’s - To shrink or not to shrink the data file, this is the question: SQL Server provides you the ability to shrink the DB or shrink the files [MDF, NDF & LDF]. Shrinking the log file/LDF is quite different from shrinking the data file/MDF, NDF. Usually we do not have to...
3 Mar 2012
© 2015 Microsoft Corporation.
Privacy & Cookies