Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Denali — Day 7: Contained Database

 

Denali – Day 7 : Contained Database

Contained database is another new feature for sql server 2012 – Denali, earlier version has a big issue on logins/users associated with particular database when you want to move the database from one server to another there is a big issue of… Read more

0 comments, 606 reads

Posted in Vinay Thakur on 7 May 2012

Denali — Day 6: indirect Checkpoint

Denali – Day 6: indirect Checkpoint

I have already blog some information about checkpoint here

As I have already blog about Checkpoint and how it works. Generally it works approximately every 1
minute(internal – default) . You could do this on instance specific using EXEC sp_configure recovery…
Read more

0 comments, 820 reads

Posted in Vinay Thakur on 6 May 2012

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)

 

There is another great achievement for Denali, especially for Data warehouse, where data is static and very huge – READONLY, and user always require data to be retrieved quickly as possible. So in Denali another great feature called “Column stored”… Read more

0 comments, 486 reads

Posted in Vinay Thakur on 5 May 2012

Denali – Day 4: Editions & Licensing

Denali – Day 4: Editions & Licensing

Editions:

Here is a brief edition summary of Editions available for all sql server from 2005 to 2012.

Sql Server 2005

Sql Server 2008

Sql Server 2008 R2

Sql Server 2012

      Data Center Edition   
Enterprise Edition Enterprise Edition Enterprise Edition Enterprise Edition

Read more

0 comments, 280 reads

Posted in Vinay Thakur on 4 May 2012

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration

Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration

 

I know this should be first or second blog post when you blog on any new technology, but as I said, I write as it goes. But I will make sure when I will consolidate my… Read more

0 comments, 392 reads

Posted in Vinay Thakur on 3 May 2012

Denali – Day 2: AlwaysON High Availability (aka Project HADRON)

Denali – Day 2: AlwaysON High Availability (aka Project HADRON )

AlwaysON Availability Group:

is another very important achievement done by development team project called “HADRON”. As the name implies AlwaysON is a High availability feature on Failure Clustering where it has option to make Secondary server as “Read-Only” purpose. Read more

2 comments, 613 reads

Posted in Vinay Thakur on 2 May 2012

Denali — Day 1: Tempdb Compatibility – Bug?

Denali — Day 1: Tempdb Compatibility – Bug?

 

I have installed sql server 2012 express and evolution edition on my personal laptop, and observed that the compatibility of databases is 110 (11) for Denali.

And till now when you change the compatibility of “model” database the compatibility of “Tempdb”… Read more

0 comments, 319 reads

Posted in Vinay Thakur on 1 May 2012

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may get an error an en eventvwr as

“Could not open error log file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG’. Operating system error = 5(Access is denied.).

so you just change… Read more

1 comments, 760 reads

Posted in Vinay Thakur on 28 April 2012

Denali – Blog a Day Series : May, 2012

Denali

 

Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is also available now.

http://www.microsoft.com/sqlserver/en/us/default.aspx

After Sql server 2008 (compatibility 10) and sql server 2010 /sql server 2008 R2 (compatibility 10.5) another major release from Microsoft sql server is… Read more

0 comments, 294 reads

Posted in Vinay Thakur on 23 April 2012

More IMPORTANT miscellaneous info

 

This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.

Okay, continue with Miscellaneous Info
here is some more important stuff/ information about sql server.

>>Ghost cleanup task runs every 5minuts (in 2005) and runs every 10minuts in (2008… Read more

1 comments, 883 reads

Posted in Vinay Thakur on 19 April 2012

Restore fails with tail of log error

For sql server 2005 and above, When you take a full backup of the FULL recovered database and try to restore earlier backup it may fail with following error

Msg 3159, Level 16, State 1, Line 1

The tail of the log for the database “restoretest” has not been backed… Read more

0 comments, 350 reads

Posted in Vinay Thakur on 22 March 2012

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets fails with the following error

Message:

Executed as user: xxx\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:… Read more

1 comments, 1,382 reads

Posted in Vinay Thakur on 14 March 2012

Command Prompt connectivity –U option

When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows authentication and sql authentication.

-E option is used for windows authentication where you domain windows login which you have connected to will be used(your windows credential).

Eg. Domainname/loginname

There is… Read more

0 comments, 238 reads

Posted in Vinay Thakur on 13 March 2012

High Availability 9's

This is very important to understand what is high availability 9′s, This is a measurement of high availability  where you can tell how much downtime is feasible for your organization for a Year(annually).

the calculation is as follows

=Total Hours in a Year-(Total Hours in a Year* # of 9′s)/100 Read more

0 comments, 298 reads

Posted in Vinay Thakur on 27 February 2012

Desktop Edition Sql server 2000 MSDE Install upgrade

for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition ie MSDE is via command prompt.

you can install the setup for desktop edition for free from here.

http://www.microsoft.com/download/en/details.aspx?id=22661

to install, just download the exe. and extract it.

setup.exe /settings… Read more

0 comments, 827 reads

Posted in Vinay Thakur on 21 February 2012

Dynamic Add/Remove file in Mirroring/Logshipping

Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether can we dynamically add/drop any new file in our principle or primary database, got conclusion that YES it is possible to the same will be affects on the mirrored… Read more

2 comments, 246 reads

Posted in Vinay Thakur on 15 February 2012

Find Login in Active Directory

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

1 comments, 388 reads

Posted in Vinay Thakur on 29 January 2012

When Date Modified changes for Sql mdf/ldf files

*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

0 comments, 607 reads

Posted in Vinay Thakur on 18 January 2012

Good Bye 2011

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 24th Dec 2011, we blessed a second… Read more

0 comments, 508 reads

Posted in Vinay Thakur on 31 December 2011

Basics QA on Extended Event

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

0 comments, 692 reads

Posted in Vinay Thakur on 23 December 2011

Newer posts

Older posts