-
No remote connection to the other node(s) during Sql server cluster install
I have done a number of Sql Server cluster installs on a variety of platforms: 32-bit Sql Server 2000 on Windows 2000 and Windows 2003, 32-bit and 64-bit Sql Server 2005 on Windows 2003, both on AMD and Intel hardware. So I feel I am pretty experienced. Recently I did an install of Sql Server…
-
Connecting to Sql Server from Unix or Linux with FreeTDS
To connect to Sql Server from *nix environment, you can use JDBC (Java), Perl’s DBI and DBD packages, unixODBC, etc. You can also use another open source tool called FreeTDS. TDS stands for Tabular Data Stream. It is a protocol that defines how data is transmitted between computers. Both Sybase and Sql Server implement TDS.…
-
Analyzing queries using DTA
I blogged about using Database Engine Tuning Advisor (DTA) to analyze your workload here. Like Indexing Tuning Wizard, you can also use DTA to analyze your queries. However, the way to invoke that is not obvious, because you cannot do it directly from within DTA. You need to have the query open in the Query…
-
Sending right string type from JDBC to Sql Server
In Java, the char data type is 16-bit, so it can handle Unicode characters. In a mixed environment where Windows and *nix (Unix, Linux, OpenBSD, Solaris, etc.) co-exist, when an app server needs to talk to Sql Server, it is pretty common that the app server is written in Java, and the connection is done…
-
Grant user permissions to create jobs in Sql Server 2005
Security model for Sql Server Agent 2005 has been revamped. DBAs will have better granular control over job creation, execution, and browsing. There are newly created roles in msdb for those purposes: SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole. For more information, go to this url in Book On Line: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm A lot of times, you may want…