Tuesday, October 02, 2007 - Posts
Few things you need to consider before letting the users use Reporting Services within a DMZ environment where the Servers are exposed to the INternet and to safeguard the servers from hackers. In this case you must be aware that SQL Server uses TCP port
Read More...
Yikes, I can't see the DTS package that has been migrated from DTS to SSIS. This was the expression by one of the database user at our end. As you may be aware using Package Migration wizard you can migrate the DTS packages to SSIS within SQL Server 2005
Read More...
Another common question on the forums, may be not a frequently performed task and as a DBA you should discourage in performing such actions. Microsoft SQL development team has already documented the information over the KBA 303774 and for the server name
Read More...
JDBC driver for SQL Server is not part of the Java SDK. To set the classpath to include the sqljdbc.jar file if you want to use it. The sqljdbc.jar file is installed in the following location: < installation directory >\sqljdbc_< version >\<
Read More...