March 2007 - Posts
As you may aware that using F8 (function key) on keyboard you can open up Query Editor from SQL Server Management Studio, an easy shortcut to get your queries up and running. How do you close it with keyboard shortcut? Guess what, Microsoft hasn't provided
Read More...
For every DBA this is a big question about performing or following best practices to apply on domain account for SQL Server services. I've done some searching, but have found no definite answer yet. We have a various setup of SQL farm with in our environment
Read More...
Well, I'm not selling any tool to fix any issues or threats you have alread in your SQL Server environment. As you may know since the fast release of SQL Server 2005 it has been utmost importance for Trustworthy computing and security on all Microsoft
Read More...
SQL Server Books Online aka BOL has got various chapters that can help the users even the experienced ones to elevate their knowledge when there is any requirement, for me that is no doubt. Recently I have been going through the information for SSIS under
Read More...
Recently one of my colleague has asked the question that can we install SQL Server version 2005 on VMware? This is required for a consolidation exercise to reduce the data center space! The answer is yes you can, you can install required SQL instances
Read More...
I was looking for few notes and information for SSIS due to a recent development at a client's site. Bingo, great SSIS Best Practice Post. Jamie Thomson has posted a great blog post about SSIS development best practices. See here what I'm talking about
Read More...
To know more about refer to this KBA that is applicable for SQL Server 2005 Enterprise Edition on X64 & Itanium based systems.
Read More...
Recently I have had problem in connecting to a SSIS service on the SQL Server instance, instantly I was checking the SQL error log to see what is the problem behind error. Nothing found and I was baffled, then found the relevant KBA to resolve the issue
Read More...
Reporting Services in SQL Server 2005 typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues. One of its feature is: lets you embed code in a report that can be accessed by various
Read More...
I'm not sure how many Developers and Database Administrators would take help from Report Design Tips and Tricks to reduce their work load, but for me it has been a great help.
Read More...
Data Storage Architecture with SQL Server 2005 Compact Edition Being ts a Compact Edition more from above link.
Read More...
Do you want to know about taking advantage of SQL CLR in Reporting Services? CLR integration functionality is exposed in an assembly called system.data.dll, which is part of the .NET Framework. This assembly can be found in the Global Assembly Cache (GAC)
Read More...
More on what I'm referring .
Read More...
The question is simple : Write a generalized SQL query for a Search module. Use [NorthWind].[Products] for demonstration. Requirement : The requirement is to write a simplified query which will be useful in a Search module The solution is here and I have
Read More...
Having a tool to benchmark or guage the system throughput is a definite helping hand from every Database Administrator out there. The basic function that should include in such tool is 1) Establish a base-line so that you know ahead of time the maximum
Read More...
Redirect link .
Read More...
Here is the one of my favourite blogger Data Dude talks about applying Service Pack for Visual Studio where you might have a mixture of SQL Server and Vista too. Check it more from here .
Read More...
While scrubbing out the MSDN events website I have found an interesting topic (webcast) upcoming on SQL Server 2005 Analysis Services data mining subject. BI Guru Lynn Langit is hosting a webcast on how you can use Microsoft Office Excel 2007 as a data
Read More...
What happens to the Replication when the SQL instance failover to the mirroring server as it is involved in Database Mirroring session? Choosing Transactional Replication is best choice in the setup of Database Mirroring if you would like to provide such
Read More...
To accomplish the requirement to migrate data from MS Access database to SQL Server database, you can take help of SSMA tool. Recently Microsoft released a new tool to migrate the Access database to SQL 2005 compact edition (.SDF) refer to Synchronizer
Read More...
In SQL Server 2005 Dynamic Management Views (DMV) & DM Functions (DMF) allows you the look inside the server to return the required information. It will also helps you to monitor the server instance health and performance to diagnose the problem.
Read More...
In SQL Server designing efficient indexes is paramount to achieving good database and application performance. The selection of the right indexes for a database and its workload is a complex balancing act between query speed and update cost. Narrow indexes,
Read More...
I was searching for this task on my Reporting Services, but unable to find where exactly I can perform this change. Then with the help of Object explorer you can accomplish the task, this is how you have to: -Navigate the report that is required to configure,
Read More...
IMHO and expereince do not let autogrowth get out of control on your SQL Server database. This is most important factor for the databases capacity planning and with this you might need an additional check-over to confirm the database size levels. I'm
Read More...
Still I can remember the features in Office 97 with Word, Excel and Powerpoint. Office 2003 extended the features to the databases and other formats. Now Office 2007 is out now which is a 'wow' factor as I have heard. I have received the Beta copy couple
Read More...
Previously Service Broker admin tool was in Beta version and recently Microsoft release the Admin tool for RTM version and with Service Broker, a feature in Microsoft SQL Server 2005, internal or external processes can send and receive guaranteed, asynchronous
Read More...
Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies
Read More...
A big question for every SQL Server user when a new version is released! Indeed, this was my question initially when looked at Microsoft SQL Server website homepage where the site is fully equipped with SQL Server 2005 version. It is more important for
Read More...
Recently I have been asked in MSDN forums about how to start a SQL Server 2005 Reporting Services report builder from Internet Explorer, the solution is open the IE and type http://localhost/reports or in http://reportserver/reportbuilder/reportbuilder.application
Read More...
A newbie question about How can I know more about SQL Server Reporting Services 2005 verison, then here is answer: http://www.sql-server-performance.com/sm_sql_2005_reporting.asp
Read More...
How to know whether my indexes are being used or not? This is most interesting question I have come across through the forums since the SQL 2000 version usage days, you may not have easy way to find out using SQL Server 2000 or even you have to run a
Read More...
In the README.HTML for SQL Server 2005 Service Pack 2 there are install instructions that covers the uninstall procedures too: > 1.3 Uninstalling SQL Server 2005 SP2, Once SQL Server 2005 SP2 has been applied, it cannot be removed without uninstalling
Read More...
With the latest release of SP2 Update release it has been a rumour in the community that it is a SP2a release, which I believe not as it is intended to fix a particular issue with cleanup tasks and maintenance plans. As the remaining tasks with Service
Read More...
Until the Office 2003 version in Excel application there is no feature to store the data more than 65536 rows in Excel. With Office 2007 version this is not a problem, but there are few cases you might neet to use previous version of Office software then
Read More...
Now a days there has been 'good' changes within the Microsoft product development and support with more trustworthy computing features, recently I have been going through for a information in Visual Studio and then I came accross the following information
Read More...
Well this was my first question when my manager asked me about shall we look at Server Virtualization. When evaluating file virtualization solutions, you must consider how you plan to use virtualization initially, as well as how it fits into the infrastructure
Read More...
I'm great fan of Kimberly (aka 'SQL Queen') on her detailed explanation on Concurrency and performance which is a hardcore topic to go through for every DBA. I have watching closely about the debate on Clustered Indecx on SQLSkills(Kimberley's) website
Read More...
This is the question asked in MSDN forums, using SQLMAINT utility this can be achieved and also the output can be sent to a text file or HTML file. In case if the steps are defined in the DTS package then its best to use DTEXEC utility. Best to refer
Read More...
Recently when I was out for Customer call this was the question raised by the DBA, incidentally Microsoft has released a KBA http://go.microsoft.com/?linkid=6109703 that explains the cause and solution.
Read More...
For the first time I have got a chance to work with SQLCMD utility in SQL Server 2005 and I was keen to use the variables and in previous versions of SQL this was controlled by declaring them explicitly. Now in SQL Server this is not the case, using SQLCMD
Read More...
Although the guest user remains in all of the user and system databases performing the same general functionality in the SQL Server 2000 and previous versions, at the same time you can revoke the access as mentioned in BOL http://msdn2.microsoft.com/en-US/library/ms177573.aspx
Read More...