Find Login in AD

Many times we require to know if particular login is a part of ad user group. Or sometimes we need to know a AD group and wanted to know who all logins are part of it.

There are many different ways to achieve this.

1. I follow…

Read more

*This is related to physical file size of a MDF or LDF file not internal allocation.

One of our user asked that the ldf file is not changing, on checking the last modified date time, user was asking this.

Its a good question, the we have to educate to user… Read more

Good Bye 2011

Hey there, this year is going to an end and just want to recall what all happened this year in my life both personally (cannot disclose much J) and professionally.

The good news about this year is on 24^th Dec 2011, we blessed a second… Read more

Basics QA on Extended Event

 

 

I am learning Extended Event so this is my first blog on extended event, There is a great whitepaper on XEvent by Jonathan Kehayias.

Q1. What is extended event?

A1. It is a light weighted profiler kind of trace introduced on sql… Read more

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it.

Check the database consistence using

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

And try to understand the messages. Read more

We come across a situation where we have to kill one spid which was running for quite some time, so we though killing will help us, but after killing found that that spid is not killed but stuck in our processes spid. And we could not able to kill even Read more

As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here. I have done this month as well, I Blog about Troubleshooting sql server issues -Errors , which we get during our day to day activity.

you can download… Read more

Day 30 More Fatal Errors and BUGs

1. For sql server 2000 and earlier you may get 5242 and 5243 corruption in the record  structure(for sql server 2005 onwards you may get 824).
   

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database… Read more

Description:-

Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user database has grown high and occupying most of its space. Please see the great blog post to know about what is log and how log file works here by… Read more

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

1. Error 823: IO error OS cannot read the data
   

Error: 823, Severity: 24, State: 2.
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset xxxx in file ‘xxx.mdf’. Additional messages… Read more

This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011             Day 28: Linked server errors Linked server is another good linking took where you can linked the server access the data from different … Continue reading →

Read more

Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file for every database, >> Transaction log is always write in sequential manner , Only at redo state … Continue reading →

Read more

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk 1. Flush dirty pages to disk. 2. Flush only Data pages to disk 2. Check for available memory and removed … Continue reading →

Read more

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk 1. Flush dirty pages to disk. 2. Flush only Data pages to disk 2. Check for available memory and removed … Continue reading →

Read more

*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from disk(file). Select : The command will go to relational engine and create a query plan for the same. –compile plan … Continue reading →

Read more

Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends on isoalition level the level of isolation are as 1. Uncommitted Read (NoLock) 2. Committed Read (blocking) 3. Repeatable Read (phantom) … Continue reading →

Read more

We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”) and realized that I have not blog much about clustering, Here I will be considering 2 node clustering “Active -Passive” … Continue reading →

Read more

I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA for Access v5.0 2. SSMA for MySQL v5.0 3. SSMA for Oracle v5.0 4. SSMA for Sybase v5.0 Ref: http://blogs.technet.com/b/dataplatforminsider/archive/2011/04/28/sql-server-migration-assistant-v5-0-is-now-available.aspx

Read more

Whenever you get a call from user that they are facing any performance issue what would you do. As I blog earlier on this, we should follow the top down approach where we need to see the scenario from bigger … Continue reading →

Read more

I you liked my Powershell a day – april 2011, where every day I wrote a blog about powershell you can download the consolidated pdf file which contains all the 30 days blog post. Download the file from here

Read more