-
Microsoft is organizing the windows Azure camp in various cities of India. It’s a great chance to learn new things about Microsoft Windows Azure. So If you want to be part of that then you must register in this event. Following are date and cities information. Ahmedabad- 10th April 2011 now postponed...
-
How often you see this message in your SQL Server platform error log? SQL Server database recovery message: Analysis of database <DatabaseName> (No) is %% complete (approximately 0 seconds remain). This is an informational message only. No user action is required When was the last time you had...
-
11th Jan 2011 - is the date to remember if you still managing SQL Server 7.0 SP4 [ 7.00.1063 or 7.00.1152 build version] (compatibility=70) instances on your production environment, end of extended support for this version! 09th April 2013 - is the date to remember if you are supporting SQL Server 2000...
Posted to
SQLMaster
by
Satya Jayanty
on
10-19-2010
Filed under:
Filed under: best practices, dba, sql server, #SQL Server, #DBA, version, security, upgrade, sessions, version control, support, lifecycle
-
As a DBA its not only we need to check for SQL Server Error Logs but often we also need to check for Windows Event Log for any Critical Error or Warning as well. Incase a daily check list needs to be followed at that time reading events if in thousands and filtering is a big pain. Here is where WMI and...
-
Getting started and find documentation for a particular component of SQL Server is bit hard for the new users. Every now and then I get to see the FAQ in forums about training and learningSQL Server. If you are a regular user (developer or DBA) then you don't need introduction to the Books Online...
-
This is a new error associated to BACKUP related issues and to be specific first time on this environment. There was no setting of BACKUP COMPRESSION enabled on the SQL 2008 instance which is used by a 24/7 application, by default after the installation backup compression is off. The default behavior...
Posted to
SQLMaster
by
Satya Jayanty
on
10-11-2010
Filed under:
Filed under: best practices, dba, #SQL Server, #DBA, #TSQL, BRH, compatibility, sql server 2008, execution, enterprise edition, backup, sp_configure, compression
-
From SQL Server 2005 version onwards database mirroring has been a good resource to provide High Availablity for the systems without having special hardware requirement. While I was assisting at the SME lounge within Database Platform area in Tech-Ed North America conference, I had few interesting questions...
Posted to
SQLMaster
by
Satya Jayanty
on
09-29-2010
Filed under:
Filed under: dba, sql server, #SQL Server, #DBA, tsql, BRH, high availability, database mirroring, login, security, partner
-
Continuing with our promise of providing you in-depth insights into latest Microsoft Technologies, Microsoft brings to you a series of exclusive webcasts on SQL Server from 29 th September to 5 th October, 2010. Join these demystifying sessions by industry veterans to get rare insights on the best practices...
-
Whenever the new version of SQL Server is released the first thing I search for Books Online update to upgrade the local copy. In similar to that Microsoft have been releasing lot of free resources and tools that can enhance the learning experience for Developers, DBA and Architects. So here are few...
Posted to
SQLMaster
by
Satya Jayanty
on
09-27-2010
Filed under:
Filed under: best practices, dba, #SQL Server, sql server 2008 r2, #DBA, developer, #DOTNET, reporting services, tools, usage, beyond relational, visual studio
-
WIKI are another popular way to share the knowledge in web world! It is driven by community and users who are interested to contribute, edit the content that is helpful to the community. In this regard here is the great resource for all SQL Server users, DBA, Developers and pros too, to follow such a...
-
If your corporate environment is monitored by System Center Operations Manager 2007 then here is the update to download the Monitoring Management Pack. This pack of SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008...
Posted to
SQLMaster
by
Satya Jayanty
on
09-20-2010
Filed under:
Filed under: best practices, dba, sql server, #SQL Server, performance, sql server 2008 r2, knowledge, monitoring, mom, tuning, #DBA, BRH
-
Learning Performance Counters : Memory/Available Mbytes and Pages/Sec. Introduction I firmly believe a DBA is only as good as how well he/she knows Performance Counters. I have been wanting to blog/learn on them for a long time and thought would start with the list of important counters as listed in...
-
In this post I would like to share some thoughts on differences between work ethic in India and the United States. These are just some lessons I have learnt the hard way, lessons I wish someone had told me when I was new to States after 10+ years of working in India. These are only generalizations and...
-
Database project is very good tool for supporting Agile development. More benefits of using this project are listed here and here . When we create a new database using SSMS, by default Page Verify Option for database is set to CHECKSUM, which is a recommended option and it helps detecting corruption...
-
SQL Server throws error of “Cannot create a row of size 8180 which is greater than the allowable maximum row size of 8060” in Insert/Update statements, This means your SQL statement having fields which are LOB data types and exceeds the limit of row size which is 8086 bytes for physical data store in...