April 2007 - Posts
Database Mail Fails For SQL Server Agent Jobs / Maintenace plans - Why ? As you are aware Database Maintenance plans are better in SQL 2005 and more better now after Service Pack 2 release with a cumulative hotfix release. Still there are few problems
Read More...
Using SSMS tool you can get information on tables, indexes and filegroup information for a database, how about using a TSQL statement: select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid ,'filegroup'=f.name ,'file_name'=d.physical_name
Read More...
SSMS - save your passwords safely in dev. environment
Read More...
Few tips I would share with the community about usage of SSMS tool within your environment, you can get acquaintance with SSMS quickly by using these features: Use Open empty environment option to speed up the loading of SSMS, this is how you do: at SSMS
Read More...
Having a shortcut feature for a tool is handy to work quicker than clicking with a mouse on a PC, I always use Keyboard more than mouse and only when I feel lazy or not keen on the subject then will use mouse. As per the SQL Server 2000 Books Online I
Read More...
Updates to system catalogs are not allowed - a big subject and nothing but opening door to trouble by allowing direct updates or modifications to system tables in SQL Server 2005. If I remember correctly since the days of SQL 6.5 version Microsoft has
Read More...
In Reporting Services there is a feature to Cache a temporary copy of the report that can be used to paste elsewhere. If the proper username has not been granted on Report Manager the user will get error "Credentials used to run this report are not stored".
Read More...
You may be aware about SQL Server 2005 Express edition is a free and simple to manage edition in 2005 version. It has an integratin with Visual Studio 2005 to make it easier to develop data driven applications with a redistributable option, well I'm not
Read More...
On day-to-day basis a DBA might come across with the issues on the fragmentation on the database, it may not be possible to design the database that will be totally efficient and optimum to perform without any issues. Due to the fact of data inserts,
Read More...
Very interesting insight of security topics on Windows operating system by Aaron Margosis.
Read More...
There has been lot of issues with SSIS packages since the release of SQL Server 2005 and few of them were corrected in Service pack releases. Still there are few existing on SQL 2005 editions creating issues when a script task or a script component that
Read More...
TOP 100 Percent ORDER BY Considered Harmful Straight to the subject about how it works in SQL 2000 & 2005.
Read More...
When you have tested the application for SQL Server 2005 comtability and upgrade process then your UPGRADE task will be easy to manage. But if you have used the Diagrams within SQL Server during the previous version, then there is a problem and here is
Read More...
Scenario is like this: Error generated when trying to register the Linked server between 2 SQL instances. SQL Server setup information is as follows: provider:SQL native Client Product Name: SQLNCL1 Data Source: Somewhere IN this world (SQLServer 2000
Read More...
I/O means Input and Output in simple terms, but in SQL Server world it has a vast significance to handle for performance and tuning. Here are few I/O basics chapters that will help the new users in SQL Server to understand : http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
Read More...
My TEMPDB is full what to do? This is a very common question in the forums and newsgroup, the first and foremost thing to check is to ensure TEMPDB drive has got enough free space to accomodate the calculations that are involved with the queries. This
Read More...
SQL Server 2005 table partitioning provides many improvements in terms of manageability and availability. This is an enhancement on taking the performance advantage on the aspects of manageability by allowing improvements to metadata only switch-in and
Read More...
Here is another LiveLink that helps you to search the SQL Server books online on web without having them installed on your machine. Thanks Quimbo for the reference.
Read More...
As a SQL Server user have you ever looked at 'How do I....' topics in Books online? I'm afraid not many will be interested to look at it, I know if you are an expert in SQL Server then visitng BOL will be quicker for you to look for what you need. For
Read More...
There may be requirement for the Developer to embed the images or icons in the reports that are presented to the Business Users. I'm talking about using Reporting Services here and there may be other tools that might have in-built or operative mode to
Read More...
Whenever I have a problem with Cluster based issue on my SQL arena I will always refer to one resource which is Brad Clustering Resources . As you may know Brad McGeehee is a SQL Server MVP and Industry specialist, founder of SSP site that helps lot of
Read More...
One of the developer in our team gave me a call to seek help on the issue they are facing, they are unable to modify or open the DTS package in SQL Server Management Studio. The Server they are working is SQL 2000 version and due to the mixture of 2005
Read More...
I too have had problems installing the recent service pack of Visual Studio (VS) that includes the recent SQL Server Compact Edition (SQLCe) binaries. Before this problem you have to ensure and check whether you've installed any CTPs they must be uninstalled
Read More...
Using BIDS any user cannot create folders under the project like VS2005 does. As usual u ser can create more than one query folder, and the root folder can create child folders. The only way to recover this problem is to edit the XML file that is created
Read More...
Well the prime criteria for DBAs is to upgrade from the previous versions to latest version and it is not an easy option or platform to perform so quickly without having a proper testing within their environment. As far as the SQL Server is concerned
Read More...
Microsoft has invested fair amount of time in providing 'sensible' documentation or references since last few years as compared to the initial windows days. Recently with the Trustoworthy Computing intiative has made the product documentation a lot better,
Read More...
Having a feature of Notification on the server happenings is add-on for every DBA, Notification Services for SQL server 2005 has got that advantage. Microsoft confirms that capitalizing on the Microsoft .NET Framework and SQL Server, Notification Services
Read More...
With the recent release of Microsoft Office 2007 edition there has been many changes to the Business Intelligence arena that Microsoft business is offering with a flexible and various options to have a feature of 'Data Mining' in Excel spreadsheets, to
Read More...
Don't get shocked with the subject and at the same time it is true on the aspect of having free license to use for SQL Server 2005 Enterprise Edition, just the catch is as per the Service Pack 2 announcement Microsofot has enabled and expanding virtualization
Read More...
Automated indexing and all about the missing DMV on the indexes information.
Read More...
I had a problem when testing a code from a production server to development (pre-production) server, this was used by using a sync. of logins. Environment is similar on each other SQL Server 2005 on Windows 2003 server. Only change was a domain name,
Read More...
Much ADO to the subject on SQLIO testing on the hardware configuration.
Read More...
Do you want a recommended hardware configuration for SQL Server at your shop? Then here is an extensive resource list by Joe Chang, as he takes most of his experience in this aspect which helps a lot to the system administrators & DBAs out there.
Read More...
In SQL Server 2005 the good feature is a SQL user can run the PROFILER or Trace without having a SYSADMIN privilege, as referred on this FAQ . Nice feature, isn't it. At the same time few users might be interested to perform same using SQL Server Management
Read More...
The DBA checklist over here is a good one for the newbie DBAs and even experienced ones too, as sometime they forget the smaller things to check that might has impact on the issue.
Read More...
On SSP forums I have looked at the question about Update Statistics and AUTO UPDATE STATISTICS option available on a SQL server database; 1> When i say Auto create statistics, what are the columns for which statistics are collected? Are these all columns
Read More...
I have written an article explaining how effectivley you can take help of SQL Server 2005 books onilne here . I'm a big fan of BOL that has given me relevant first hand help whenever needed.
Read More...
Well not everyone will agree with me but you have to after referring to David LeBlanc's blog . Refer to BOL entry on impersonation , implementing impersonation in ASP.NET application on this KBA .
Read More...
This was the question raised by a newbie DBA at my workplace! Endpoint in generic network terms they are the objects that represent a communication point between the server and client. In SQL Server as per the Authentication mode (Windows only & mixed)
Read More...
Brad McGeehee is a SQL Server Industry expert and a founder of SSP website which is one of the popular websites in the Microsoft community. I feel great to be associated with Brad in bringing up the forums and website too. He has a vast knowledge in setting
Read More...
One of my Developer asked how to handle the concurrency and locking on one application where ASP.NET is used, by default the SQL Server 2005 behavior that allows Pessimistic & Optimistic locking for concurrency. To avoid the access of records by multi-users
Read More...
In SQL Server 2000 for index defragmentation DBCC DBREINDEX and DBCC INDEXDEFRAG statements are used, as you are aware defragmentation on table does not yield performance gains in every case. Every scenario is different. Similarly, determining when you
Read More...
Have you ever used a stored procedure to run few integrity checks or to protect such integrity on the database. I always use the stored procedure as it will come handy when there is any such need, Erland Sommarskog has written great article on how Stored
Read More...
I hope most of you have been through a webcast or a virtual labs that are setup by Microsoft. IMHO they are very useful to get to know more details than reading 100 pages books about the product knowledge. I have been through Virtual Labs and webcasts,
Read More...
Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later.
Read More...
Have you ever used the MSDN or SQL Server Books OnLine search functionality? I have used it and there are 3 types of help provided with SQL Server 2005 BOL which is a local based, Internet and Newsgroups. At the latest check out the new Books Online search
Read More...