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\Client\ConnectTo The alias is configured via the configuration…

2

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 account? There are a few options (Local Account, Service Network, domain User) What is the best and suitable account for the service? I will try to answer that on this blog post. It is very important for…

0

Sys.Configuration

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? So…

0

LOG PARSER.

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…

0

SQL 2014 Beta

SQL2014 BETA is available now. You can download and enjoy it.  Don’t forget to try the In memory DB   http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx

0

Replication of indexed views

Recently we created a Transactional Replication for one of our customer’s database. In addition to tables, views and procedures we had indexed view including Full Text Index base on it. Currently, we cannot specify on the management studio what we’d like to replicated with the indexed view, so the only way is to do it…

1

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…

0

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 server role except SA (assuming you…

1

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 features that are no longer supported. Each time we are approach an upgrade, we try to minimize the risk. These built-in tools can assist us: SQL Server Upgrade Advisor SQL Server Profiler deprecation events SQL Server Distributed Replay…