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

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

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,…

2

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…

0

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 recommended step to start with? During my last post I have discussed the default trace in SQL and its benefits. SQL 2008 introduced a new option called extended events (which is also know as…

3

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…

5

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, when required to create a new T-SQL command, check out the syntax in BOL, they try to remember on how to do it, Or sometimes we need a repeating T-SQL Command like: Select, Proc, Func, triggers,…

3