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
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
Denali – Day 9: Additional Scalability Features
- 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
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
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
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
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
Denali – Day 4: Editions & Licensing
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|
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
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
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
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
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is also available now.
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
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
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
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
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
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).
There is… Read more
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
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.
to install, just download the exe. and extract it.
setup.exe /settings… Read more
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