-
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.…
-
View and kill processes in Linux and Solaris
On *nix system, the ps command is kind of like Windows task manager. It provides running processes information. Once you find the process ID, you can kill it using kill command. On Linux machines, you can type ps ux to list all your own running processes. The second column, PID, is Process Identifier. By looking…
-
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…