May 2007 - Posts
I have seen mounting questions asking on support for SQL Server 2005 on Vista & Windows 2008, what a surprise! As Windows Server 2008 (aka Longhorn) is still in CTP (BETA 3) stages it is hard to comment or confirm any sort of support arrangements
Read More...
Since the days of SQL 70 automated administrative tasks are getting better with the usage of SQLAgent, you need to know how to configure alerts and set up operators, the people SQL Server contacts when alert conditions arise. SQLAgent Jobs can trigger
Read More...
Over the times managing RDBMS platform has evolved into a phase that all of the essential functionality that a Database Administrator needs to administer a multivendor or single-vendor database environment wrapped in an intuitive graphical interface.
Read More...
If you are performing a simple process to import a data using a DTS package in SQL 2000 or an SSIS package in SQL 2005, you might be very familiar with errors such as "x80040E21 & x80040E24". To put more in the sense of real error it will be " Microsoft
Read More...
Say one fine morning you had a call stating one of the databases have lost the transaction log file due to a hardwrare issue (for discussion sake). Then the recovery option is to restore from the latest backup, that is a best practice too. In case if
Read More...
You have a production database which has a very high growth rate. As a result the database transaction log gets full resulting a daily scheduled job to shrink. All the times this is affecting the performance on SQL Server, what is the best option to shrink
Read More...
Problem: SQL Server 2005 error: xp_cmdshell: a call to 'CreateProcess' failed with error code: '5'. We get above error when trying to execute XP_CMDSHELL even though it has been enabled using Surface Area Configuration tool and the login has SYSADMIN
Read More...
Snapshot backups are introduced in SQL Server 2005 version that uses: The underlying backup technology creates an instantaneous copy of the data that is being backed up. The instantaneous copying is typically accomplished by splitting a mirrored set of
Read More...
As we know you have SP_RECOMPILE to re-compile the stored procedures within the database and DBREINDEX statement to reindex the fragmented indexes. How about refreshing the views that are modified on day-to-day basis within a database? You can take help
Read More...
You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that
Read More...
At first I was amused to see the title and there is lot more information which is granular that you need to know. Replication is intended to be a way of distributing data automatically from a source database to one or more recipient databases. As such,
Read More...
Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server
Read More...
You might have come across this instance of error within your environment: Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' The above error used to drive me nuts when the users complained by specifying
Read More...
One of my Dev. DBA asked me this question about whether we need to use NOINIT or INIT for a differential backup schedule. Think about availability option in this case, you can overwrite the existing differential backup using INIT clause but when it comes
Read More...
Well another cache related blog in a row since last few days! I have had weird issues on one of the SQL Server 2005 SP1 instance that, whenever DBCC CHECKDB is executed the performance of particular stored procedure ( complexed calculations ) has gone
Read More...
I feel like there is lot of confusion ( new users ) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what
Read More...
Honestly I have had such decision time to choose whether to go to CLR (Common Language Runtime) or TSQL (Transact-SQL) to design on one aspect of component design at our place. Obviously TSQL was first choice as I have been experienced mostly, but don't
Read More...
The process is easy when you have all ingredients in place (handy) without any issues on the current environment. The Database Publishing Services are a set of ASP.NET web services you can easily deploy to make it simple for your customers to deploy SQL
Read More...
If you are a book reader to know on the new subject and that too looking for a SQL Server 2005 books then here is the place you can get upto 35% discount and also download free sample chapaters as a PDF format! DigDeep for more information on this offer,
Read More...
Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are
Read More...
There might be various questions in the forums asking what is the default datetime format in SQL Server, how to change the date format. Further into the details make a note that there is no international standard for representation of datetime values.
Read More...
Have you ever wondered you can recover a corrupted database when you have optimum backup & restore strategy in place, well I'm not talking about usage of third party tools or use high-end hardware. With simple backup and restore features in SQL Server
Read More...
JumpStartTV from Brian Knight (SQL Server MVP) has started good sessions and one of them are very useful to the beginners in SSIS, the basics of the SQL Server Integration Services Control Flow. He shows you how to orchestrate a package in the control
Read More...