SQLPFE.IL

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...

Author: Oren Bouni Date: 05/27/2014

SQL Alias PowerShell script

Hello everyone, this time I am going to show the "Server Alias". I have been asked by one...

Author: Oren Bouni Date: 03/31/2014

Using the proper login account for the correct SQL Service

I was often asked this question: I'm installing my SQL Server. What should I use as the service...

Author: Oren Bouni Date: 02/27/2014

Sys.Configuration

A while ago, I was asked by customer how to tell if an instance parameter is dynamic or rather...

Author: Oren Bouni Date: 12/10/2013

LOG PARSER.

Hello everyone, today I'd like to write about the LOG PARSER. First time I have encountered this...

Author: Oren Bouni Date: 10/30/2013

SQL 2014 Beta

SQL2014 BETA is available now. You can download and enjoy it. Don’t forget to try the In...

Author: Oren Bouni Date: 10/30/2013

Replication of indexed views

Recently we created a Transactional Replication for one of our customer's database. In addition to...

Author: Stas Bogachinsky Date: 09/30/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...

Author: Oren Bouni Date: 08/07/2013

The scenario of a missing SA password:

You are the senior DBA of your organization, responsible for all the databases that hold the...

Author: Oren Bouni Date: 07/22/2013

Discontinued and Deprecated features in SQL Server 2012

Recently we encountered a few problems with upgrades to SQL Server 2012, mainly because of usage of...

Author: Stas Bogachinsky Date: 06/29/2013

SQL Server 2014 is here !

Community Technology Preview 1 is available. You are welcome to experiment with all great new...

Author: Stas Bogachinsky Date: 06/27/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...

Author: Oren Bouni Date: 05/27/2013

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...

Author: Oren Bouni Date: 04/28/2013

SQL 2012 System health–fast analysis

Once we encounter a few problems with the SQL 2012 and we need to analyze it, what will be the first...

Author: Oren Bouni Date: 03/24/2013

Trace flag at query level is supported

Have you ever wanted to execute specific query with specific trace flag turned on, without affecting...

Author: Stas Bogachinsky Date: 02/25/2013

Check your SQL – default Trace

Every installation of SQL has a default trace. The default trace was introduced in SQL 2005, It is...

Author: Oren Bouni Date: 01/21/2013

How to avoid text-to-date conversion mismatches

  In one of our previous posts we saw how different set options can affect execution plans and...

Author: Stas Bogachinsky Date: 01/14/2013

the case of the unexplained - how we can get different execution plans and result sets for same query

The other day, my colleague and a good friend called me and told that her SQL Server gone nuts.One...

Author: Stas Bogachinsky Date: 12/12/2012

Working with SQLIO and analyzing it’s output

Introduction While working on a customer request, I faced the question what is the SQLIO? how to...

Author: Oren Bouni Date: 12/04/2012

SQL Server 2012 new feature The Snippets

Snippets In SQL 2012 we have a new feature called snippets; So what are this snippets? Lots of DBAs,...

Author: Oren Bouni Date: 11/11/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...

Author: Oren Bouni Date: 11/04/2012

Stop using TOP to page for data from now on use the OFFSET

  With all the innovation that SQL 2012 bring to us in the T-SQL area we have the offset...

Author: Oren Bouni Date: 10/29/2012

SQL Server 2012 Audit Enhancements

SQL Server Auditing is useful for auditing the usage of your database operations. We've got quite a...

Author: Stas Bogachinsky Date: 10/15/2012

User-Defined Server Roles - new server option in SQL Server 2012

Along with Organization growth and databases growth we need more specific permissions for DBAs,...

Author: Stas Bogachinsky Date: 09/04/2012

HBA, Queue Depths and inflight IO.

  I had recently received a question form one of my customers asking what is the recommended...

Author: Oren Bouni Date: 08/26/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...

Author: Oren Bouni Date: 07/14/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...

Author: Stas Bogachinsky Date: 06/13/2012

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...

Author: Stas Bogachinsky Date: 05/21/2012

Startup parameters in SQL 2012.

SQL 2012 brings us new options and cool features, one of these features is the startup parameters.On...

Author: Oren Bouni Date: 04/18/2012

Recovery models

Recovery model is our way to instruct SQL Server how to maintain the log file. We have 3 recovery...

Author: Stas Bogachinsky Date: 03/13/2012

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...

Author: Oren Bouni Date: 03/03/2012

SQL Server Service Packs and Cumulative Updates List

See below SQL Server Service Packs and Cumulative Updates List. It will be updated monthly....

Author: Oren Bouni Date: 02/23/2012

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 installationof SQL...

Author: Oren Bouni Date: 02/16/2012

Welcome to the SQL Server Israel PFE blog.

PFE delivers onsite, remote and dedicated support services forPremier customers around the world to...

Author: Oren Bouni Date: 01/26/2012