|
|
-
|
|
This article explains how to send an email through Powershell.
Very useful if you have a requirement to automate your scripts and send notifications .
The example is calling the SmtpClient Class , which is part of the .Net Framework.
You can call a Function – which makes your scripting ......
|
|
-
|
|
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16, State 1, Line 17 : Conversion failed when converting the nvarchar value '??u? ? ? ?AA???????????W?????????a??????K???????????????????1217' to data type int. [SQLSTATE 22018]
It was......
|
|
-
|
|
I received the following error , when attempting to connect to a DB2 database
db2 connect to MYDB
SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030
#Checked in the db2diag.log file
ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A fil......
|
|
-
|
|
Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested access to a Production database. The details were to COPY and PASTE from a Excel spreadsheet into Access , which then updated SQL Server. Upon asking him , why he used this method , he said “It’s the w......
|
|
-
|
|
A quick method to use for executing a script on Linux start.
After all the other processes are started by the init command at boot time, the script is run on Red Hat based systems:
/etc/rc.d/rc.local
Add any extra script\commands references to this file.
See Also
db2start at st......
|
|
-
|
|
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming to search for specific Messages.
It is a good idea to recycle the SQL Server Error Logs . To create a new Error Log file without restarting SQL Server , use the sp_cycle_e......
|
|
-
|
|
By default , when creating a new DB2 database , the Log path is on the same drive as the data files.
To change the log path , configure the NEWLOGPATH database parameter
db2 update db cfg for MYDB using NEWLOGPATH /newpath/
See Also
OLTP performance checklist
Republished with author's......
|
|
-
|
|
In large Tivoli environments – System Adminstrators prefer to manage the installation of the Monitoring Agents
As a DBA you may need to exclude the ITMA from the DB2 server installation. Methods are:
1) To prevent the DB2 installer from installing ITMA in a response file installation, s......
|
|
-
|
|
A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's as a nul device , anything “written” to it is discarded.Don’t confuse with the SQL reserved word NULL.
Before you run this statement , note that even as the file is not going anywhere , SQL Se......
|
|
-
|
|
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production .
Maintaining multiple environments requires consideration of various factors.
Reasons for maintaining different environments
Part of well audited database server system includ......
|
|