See all products »
Curah! curation service
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 Protocol How to secure and disable unnecessary protocol with a Power Shell script
As part of a project at one of my customers I was asked to create an automatic installation that will be a secure installation and will use an Alias, disable unnecessary protocols and use a fix port number instead of dynamic. In my last post I shared with you all a Power Shell script that helped us to...
27 May 2014
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
Network bind order warning during SQL Server installation at failover cluster
Installing SQL Server 2008, 2008R2 and 2012 on failover cluster has been significantly changed from SQL Server 2000 and 2005. Installation is performed separately on each node in order to avoid failures and downtime and much more. One of improvements is more "in-depth" pre-installation checks. One of...
21 May 2012
Hello everyone, today I'd like to write about the LOG PARSER. First time I have encountered this tool was around 2004 when I had to load a big mass of data (IIS Log) into a database. A month ago I was asked by a customer, how can is it possible to read and load into SQL Server flat files / application...
30 Oct 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
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
Four Tips for SQL Tuning for SharePoint Part 3 TEMPDB
One of the focal points in SQL Server Tuning for SharePoint is around the TEMPDB. A lot of performance issues are caused by the performance of the TEMPDB. TEMPDB is one of the four system databases. Master is the database that contains all the information about the configuration of the...
14 Jul 2012
PERFMON & SQL Server - a small useful tip
One of the best Performance tools that I use is the PERFMON. PERFMON is a tool that exists out of the box on every windows machine and has lots of counters for almost every application. Perfmon provides current, accurate information on thousands of different attributes of your system. If you open...
4 Nov 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
Keep track of the DML changes:
Last week, one of my customers asked me how to track DML code. He had a scenario in which he needed to update a table and keep the old data. In the past, developers and DBAs have used custom code to track changes, stored procedures, triggers and CDC. Starting with version 2005, SQL Server supports...
7 Aug 2013
© 2014 Microsoft Corporation.
Privacy & Cookies