Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Denali – Day 15: Support for Windows Server Core

Denali – Day 15: Support for Windows Server Core

 

Windows Server Core: Microsoft Server has so many features which is not required on the server and would never been used, but it exists and sometime cause issue. For this reason Microsoft has introduced an operating system called “CORE” from “windows… Read more

0 comments, 686 reads

Posted in Vinay Thakur on 15 May 2012

Denali – Day 14: New DMV & DMF

Denali – Day 14: New DMV & DMF

 

As there has been so many DMV/DMF already introduced in earlier version of Sql server, Denali does not have much on this part, but 5 new dmv/dmf and 1 modified here most of the stuff is related to OS, below are the… Read more

0 comments, 595 reads

Posted in Vinay Thakur on 14 May 2012

Denali – Day 13: FileTable

Denali – Day 12: FileTable

 

“FileStream” is introduced in sql server 2008, for storing BLOB data like varbinary(max), it is integrated with NTFS file system by creating a separate FileGroup to stored BLOB data, and make it more efficient and stable in sql server”

 

FileTable is a new feature to… Read more

0 comments, 691 reads

Posted in Vinay Thakur on 13 May 2012

Denali – Day 12: More Manageability Features

Denali – Day 12: – More Manageability Features:

  1. -K switch

    With new feature added in an engine to use that feature with different way you may have to add options to use it, as HADRon – AlwaysON feature where secondary server is read-only and active, there is an option -K…

Read more

0 comments, 798 reads

Posted in Vinay Thakur on 12 May 2012

Denali — Day 11: SSMS enhancement

Denali — Day 11: SSMS enhancement

SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA to manage the system efficiently.

Like IntelliSense/Debug is introduced in sql server 2008 now in Denali it has improved.

Following are some of the new features added in… Read more

0 comments, 458 reads

Posted in Vinay Thakur on 11 May 2012

Denali — Day 10: Sequence object

Denali – Day 10: Sequence object

Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server was having identity column which is associated with particular table but now sequence is a separate object which has sequence values and can be ascending or descending order… Read more

0 comments, 950 reads

Posted in Vinay Thakur on 10 May 2012

Denali — Day 9: Additional Scalability Features

Denali – Day 9: Additional Scalability Features

  1. 15,000 Partitions earlier it was 1000

For the enterprise system having huge amount of data to achieve the best performance for huge data developer requires more partition to distribute the data and manage it appropriately, for that Microsoft were introduced partition of data… Read more

0 comments, 337 reads

Posted in Vinay Thakur on 9 May 2012

Denali — Day 8: Startup Parameter

Denali – Day 8: Startup Parameter

Startup Parameters means you are providing the parameter to sql server at the start of sql server, what needs to assign internally, by default you must have to provide following 3 parameters

-d: Specify the location of “Master” database data file.

-l: Specify the… Read more

0 comments, 511 reads

Posted in Vinay Thakur on 8 May 2012

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, 838 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, 1,118 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, 647 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, 384 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, 567 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

0 comments, 1,051 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, 391 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

0 comments, 1,101 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, 430 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

0 comments, 1,048 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, 501 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

0 comments, 2,208 reads

Posted in Vinay Thakur on 14 March 2012

Newer posts

Older posts