Category Archives: Whitepapers

Sql server 2012 links

Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/ Advertisements

Posted in Denali, DMV, What I learned today, Whats New, Whitepapers | Tagged , , , | Leave a comment

Performance Tunning Part 2

After checking on the net found that there are lots of lots of good stuff (queries) already describe the performance related information, so I would like the share and refer some of the very good site. I have already blog … Continue reading

Posted in DMV, Lock/Blocking, Performance Tuning, Whitepapers | Tagged , , | Leave a comment

Failure Cluster -General

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

Posted in High Avaliability, Whitepapers | Tagged , | Leave a comment

Mirroring

As discussed about Disaster Recovery and High Availbility topic here continue on this. today would like to discuss some more information about mirroring. As stated in my ealier post about mirroring, today I would like to write about how to conifigure … Continue reading

Posted in Disaster Recovery, General, High Avaliability, Installation, Tool, Webcast, What I learned today, Whitepapers | Tagged | Leave a comment

Performance Tunning -Monitoring SQL Server health

I was going through my blog and realize that I have not done much on performance tuning, which is one of my favorite topics. so initialed the new category as performance tuning, Will try to cover most of this stuff … Continue reading

Posted in Free Stuff, Performance Tuning, What I learned today, Whitepapers | Tagged | Leave a comment

Tricks and issues Part 2

Continue to part 1  the Jet ODBC driver/OLE DB Provider as 64 bit. http://blogs.msdn.com/psssql/archive/2010/01/21/how-to-get-a-x64-version-of-jet.aspx 2010 Office System Driver Beta: Data Connectivity Components http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en Must read Paul’s Myth for April Month. http://www.sqlskills.com/BLOGS/PAUL/category/Misconceptions.aspx Must read Glenns blog for April “A DMV per … Continue reading

Posted in General, Training, What I learned today, Whitepapers | Tagged | Leave a comment

HA and DR Techniques in sql server

High Availability and Disaster recovery Techniques in sql server This blog is the introduction and brief overview for high availability and Disaster recovery techniques available in sql server, and its my understanding on it. I will write detail blog on … Continue reading

Posted in Backup and Restore, Disaster Recovery, General, High Avaliability, Tool, What I learned today, Whitepapers | Tagged | Leave a comment

my Favorite Part 1

  Hi Friends,   Today I would like to share my favorites on Sql server…   My Favorite Links A list of the bugs that are fixed in SQL Server 2000 Service Pack 4 After restore Database, transactional replication can’t … Continue reading

Posted in Computers and Internet, Experts, General, Webcast, Whitepapers | Tagged , , | 2 Comments