naveenkrishnadba.blogspot.com
ORACLE - DBA: ASM in Windows server
http://naveenkrishnadba.blogspot.com/2010/05/asm-in-windows-server.html
Thursday, May 13, 2010. ASM in Windows server. Preparing Disks for ASM: Windows NT. To simulate implementation of ASM in the Windows NT environment, I first created raw disk partitions on some of my hard drives. Fortunately, I had extra space on three of the four disks in my test server, so I created several primary disk partitions sized at 100MB on each of those three drives using the Windows Disk Partitioning utility (DISKPART.EXE):. C: select disk 2. C: Disk 2 selected. C: select disk 3. Defines the i...
andrewpakpahan.blogspot.com
Andrew Pakpahan: How to enable MySQL remote access on Ubuntu Server 12.04
http://andrewpakpahan.blogspot.com/2012/08/how-to-enable-mysql-remote-access-on.html
My Thoughts, My Ideas, My Experiences, My Friends. Monday, August 20, 2012. How to enable MySQL remote access on Ubuntu Server 12.04. By default MySQL on Ubuntu Server 12.04 can only be accessed from localhost (127.0.0.1). If we need to access it from another computer on the network, we must do the following step. Sudo vim /etc/mysql/my.cnf. Comment out this line (add # in front of the line). Bind-address = 127.0.0.1. Sudo service mysql restart. Mysql start/running, process 13081. Mysql -u root -p. Thank...
yoshinorimatsunobu.blogspot.com
Yoshinori Matsunobu's blog: MHA 0.56 is now available
http://yoshinorimatsunobu.blogspot.com/2014/03/mha-056-is-now-available.html
Monday, March 31, 2014. MHA 056 is now available. Version 0.56 today. Downloads are available here. MHA 056 includes below features. Supporting MySQL 5.6 GTID. If GTID and auto position is enabled, MHA automatically does failover with GTID SQL syntax, not using traditional relay log based failover. You don't need any explicit configuration within MHA to use GTID based failover. Supporting MySQL 5.6 Multi-Threaded slave. Supporting MySQL 5.6 binlog checksum. MHA supports new section. Is it supported too?
adamsquicklog-webissues.blogspot.com
AdamsQuickLog - Web Issues: Connecting Sqldeveloper to remote DB servers via Putty SSH Tunnels
http://adamsquicklog-webissues.blogspot.com/2011/02/connecting-sqldeveloper-to-remote-db.html
AdamsQuickLog - Web Issues. Ecommerce trips, tips and tricks, data feeds, google base, shopzilla, data quality. Sunday, February 13, 2011. Connecting Sqldeveloper to remote DB servers via Putty SSH Tunnels. As part of your security best practices, your ecommerce database server should not be accessible remotely (across the internet or WAN). For example, assuming standard ports, your firewall should block port 1521 for Oracle and port 3306 for MySQL. 1 Run Putty.exe to bring up the config dialog:. 6 Selec...
yoshinorimatsunobu.blogspot.com
Yoshinori Matsunobu's blog: Single thread performance regression in 5.6 - Replication
http://yoshinorimatsunobu.blogspot.com/2013/12/single-thread-performance-regression-in.html
Monday, December 16, 2013. Single thread performance regression in 5.6 - Replication. At Facebook, we have upgraded most of MySQL database tiers to 5.6, except very few tiers that have a special requirement - very fast single threaded replication speed. If all of the following conditions are met, SQL thread in 5.6 is significantly slower than 5.1/5.5. Almost all working sets fit in memory = Almost all INSERT/UPDATE/DELETE statements are done without reading disks. For details (how to repeat etc). Fig 1 S...
database-dba.blogspot.com
Database DBA: Real Application Testing
http://database-dba.blogspot.com/2013/02/real-application-testing.html
Database Administration Guidance and suggestion with tips and techniques. Friday, 1 February 2013. Oracle Database Management System 11g introduced a new extension to the world which quickly became indispensable for many of the leading companies of world because of its high applicability and practicality. What does it do? Work or remote dba services. If you are not knowledge about database administration. Then you should need to hire either good experienced DBA or hire remote services. ARINET DBA Service...
dba-tips.blogspot.com
Database Administration Tips: Oracle Database Administration Scripts | DBA Bundle
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html
If you can't explain it simply, you don't understand it well enough." Albert Einstein. Saturday, February 15, 2014. Oracle Database Administration Scripts DBA Bundle. In this post, I'll share with you one of the most helpful tools I ever created, to make the day to day database administration tasks more faster, safer and easier for the DBA. This tool I call it DBA Bundle. It's a tar file contains a group of shell scripts, y. The latest version from this link:. How to use the bundle:. First, download the ...
windowspbx.blogspot.com
Matt Landis Windows PBX & UC Report: Step by Step Installing Lync Server 2013 Monitoring Role Collocated on Standard Edition Front End - Part 2
http://windowspbx.blogspot.com/2012/07/aaa-donotpost-install-lync-standard.html
Installing and Upgrading Skype for Business Server 2015 Step by Step Free eBook. Skype for Business User Tips and Tricks Free eBook. Step by Step Installing Lync Server 2013 Monitoring Role Collocated on Standard Edition Front End - Part 2. In Part 1 of Installing Lync Server 2013 Standard Edition. Server is Windows Server 2012. Using SQL Server 2008. You have Lync Server 2013 Preview installed Using This Blog. Put SQL 2008 CD in place and run Setup.exe. Ok next next next…. SQL Server Books Online. Open ...
dimantdatabasesolutions.blogspot.com
Dimant DataBase Solutions: Make sure that you write/create optimized SSIS Packages
http://dimantdatabasesolutions.blogspot.com/2014/05/make-sure-that-you-writecreate.html
Wednesday, May 14, 2014. Make sure that you write/create optimized SSIS Packages. Recently I worked on the package that loops many text files and insert the data into a staging table and then from the staging into original table which has five columns only defined as VARCHAR(50) in the database. Pretty simple , not? After sometime investigations we dropped the wide stage table and created a stage table with exactly same structure as original table has. That means columns have VARCHAR(50) and we also chan...
dimantdatabasesolutions.blogspot.com
Dimant DataBase Solutions: SQL Server 2012 IIF function may replace CASE expression?
http://dimantdatabasesolutions.blogspot.com/2012/10/sql-server-2012-iif-function-may.html
Wednesday, October 31, 2012. SQL Server 2012 IIF function may replace CASE expression? Did you install already SQL Server 2012? Well, see a new T-SQL function named IIF you can use sometimes instead of CASE expression. Http:/ msdn.microsoft.com/en-us/library/hh213574.aspx. CREATE TABLE #t (id INT). INSERT INTO #t VALUES (1),(2),(3). DECLARE @a int = 3;. DECLARE @b int = 2;. SELECT * FROM #t WHERE id= IIF ( @a @b, @a, @b ). You can even using nested IIF commands. Thanks Uri for the information!
SOCIAL ENGAGEMENT