Displaying posts with tag: SQL Server (reset)
posted by
The Pythian Group
on
Fri 24 May 2013 12:34 UTC
Tags:
Can’t find what you want or need? Do you have a tip or trick to share? Do you want to lament over a technical woe? If yes then blog and send it to us for the Log Buffer :), just like this Log Buffer contains tips, tricks and woes.
Oracle:
Fahd Mirza and Tanel Poder throw spotlight on the v$cell_thread_history view with respect to the Exadata.
Mark W. Farnham‘s rightsizing goes on with a roar, as he declares that
[Read more...]
posted by
The Pythian Group
on
Fri 17 May 2013 12:23 UTC
Tags:
The red carpet has been laid down at this Log Buffer Edition, and you can witness and cheer the cat-walking blog posts from Oracle, SQL Server and MySQL. Every one of them is chic, elegant, sensual in its own right. Enjoy.
Oracle:
Create colored heat maps in SQL*Plus with Kyle Hailey.
Here’s a quick and dirty script to create a procedure (in the SYS schema – so be careful) to check the Hakan Factor for an object.
Connor has a good post about default null for collection parameter.
This is yet another blogpost on
[Read more...]
posted by
The Pythian Group
on
Fri 10 May 2013 12:52 UTC
Tags:
This week again, the Log Buffer Edition covers the exciting and ever-evolving galaxies of Oracle, MySQL and SQL Server.
Oracle:
When does an Oracle process know it’s on Exadata?
MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.
A new major release (version 3.0) of Randolf’s XPLAN_ASH tool is available for download.
Important !! Clustering Factor Calculation Improvement
[Read more...]
posted by
The Pythian Group
on
Fri 03 May 2013 11:50 UTC
Tags:
News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.
Oracle:
There is a significant update SLOB 2, Kevin Closson informs.
Charles Hooper is grouping Data Sets by Week Number of the Month.
Chris Antognini has shared a script that is used to demo ITL deadlocks.
As
[Read more...]
posted by
The Pythian Group
on
Fri 19 Apr 2013 12:36 UTC
Tags:
Just as information has become an integral part of technology, blogging has become an inseparable part of technology too. Database technologies are no exception and blogging in that arena is booming. This Log Buffer Edition is booming with some bombastic blog posts.
Oracle:
Arup Nanda asks. Application Design is the only Reason for Deadlocks? Think Again.
It’s time that businesses took a good, hard look at the way they manage their cloned database environments, Kyle Opines.
Randolf touches the interesting topic of ASM AU Size And LMT
[Read more...]
posted by
The Pythian Group
on
Fri 12 Apr 2013 12:51 UTC
Tags:
Like in love there is no precondition, there are no limits held when it comes to the labor of love called as blogging. Lovingly this Log Buffer edition brings you some more roses from database arena.
Oracle:
Marco Vigelini shares as how to duplicate a production database on a different server mantaining the same SID and directory structures with ‘duplicate’ RMAN command and how to resynchronize a duplicated remote database using RMAN backups.
[Read more...]
posted by
The Pythian Group
on
Fri 05 Apr 2013 12:26 UTC
Tags:
It is an industry norm, supported by analyst researches that blogs are the best informal medium to share the information. This unique medium provides readers with increased leverage in negotiating the hard turns in their technological lives. Log Buffer makes that leverage more powerful.
Oracle:
Alan Gardner is deploying Cloudera Impala on EC2 with Example Live Demo.
If you want to follow the real news and insight into the online learning revolution, then e-Literate has always been the blog to follow.
Tuula Fai wants to do things, and when he cannot he reverts to a little help.
[Read more...]
posted by
The Pythian Group
on
Thu 28 Mar 2013 12:33 UTC
Tags:
The answers to the questions like whether to patch now or wait a little? What quirks are there in that stunning new features? What are the limitations of that fancy index type, any working examples of a particular add-on, are best found in the blogs. This Log Buffer Edition provides you a window to those blogs out there.
Oracle:
Scott Wesley is dishing out the reasons you should upgrade your APEX environment.
In case you haven’t already noticed, PeopleTools 9.2 is out and available for download!
Since two thirds of sensitive data in most organizations resides in databases, consolidation onto private clouds represent an opportunity to improve
[Read more...]
posted by
The Pythian Group
on
Fri 22 Mar 2013 17:32 UTC
Tags:
There are no rules for blogging. There cannot be any, because you cannot trap the wind in your hands. It’s innovation, it’s creativity, and it’s right out of the core of the technology from the bleeding edge. This Log Buffer drips into that, and brings you some of the finest posts.
Oracle:
Yes its not a fad. Big Data is the commercial supercomputing in the age of Datafication.
Tanel Poder is listing Exadata storage cells and their configuration info from V$CELL_CONFIG.
How well do you know your hints? When
[Read more...]
posted by
The Pythian Group
on
Mon 18 Mar 2013 15:32 UTC
Tags:
With real possibilities and opportunities, blogging is getting mature day by day, and so is the technology and its innovations. The combination of both becomes a dazzling medley, which is called as Log Buffer. Enjoy this week’s stunning Log Buffer #311.
Oracle:
Sudip Datta is writing about database as a service.
Premature optimization, (probably) because of Donald Knuth’s famous line “premature optimization is the root of all evil,” (see Structured Programming with go to Statements) is, at the very least, a controversial topic.
Are you using the application server that best serves your changing business needs? Maybe it’s time to consider an upgrade? Suggested by
[Read more...]
posted by
The Pythian Group
on
Fri 01 Mar 2013 14:35 UTC
Tags:
Oracle, SQL Server, and MySQL; these database technologies among various other similar innovations are running this world virtually and bloggers have got lot to say in this regard. This Log Buffer Edition is yet another voice in this arena.
Oracle:
Oliver Steinmeier is explaining the JDeveloper and Fusion Applications in a lucid way.
London prepares for a surge of developer brainpower during the Devoxx UK conference on Tuesday and Wednesday, March 26th and 27th, Yolande Poirer tells us.
It’s hard to believe that another year has passed from last RSA. But, indeed, time flies when you’re busy, I guess,
[Read more...]
posted by
The Pythian Group
on
Fri 22 Feb 2013 15:18 UTC
Tags:
Oracle, MySQL, and SQL Server bloggers are not only sharing their knowledge through their blogs, moreover, they are also learning about themselves. Their posts are cementing their concepts, while opening vistas of new notions. This Log Buffer Edition is yet another vista for their blogs.
Oracle:
Where is Oracle Block Change Tracking today? World’s leading Oracle expert Alex Gorbachev answers.
Marcin Przepiorowski is asking: Oracle on AIX – where’s my cpu time?
Kyle Hailey is monitoring Oracle I/O latency.
How EBS Concurrent Processing should run on Oracle
[Read more...]
posted by
The Pythian Group
on
Fri 15 Feb 2013 14:11 UTC
Tags:
If you are looking for some of the great blog posts of the week in database technologies like Oracle, SQL Server and MySQL, then Log Buffer #307 is the place to be. Enjoy.
Oracle:
When Jeremy Schneider writes, it stays written. He relishes and shares as how to troubleshoot OEM 12c Cloud Control Auto-Discovery.
Chris Kawalek informs that Oracle VM provides SAP customers with a fully supported and certified virtualization environment for the Oracle database.
Peter Lorenzen is hardening the Apache HTTP Server.
[Read more...]
posted by
The Pythian Group
on
Fri 08 Feb 2013 14:45 UTC
Tags:
Bloggers are striving hard to up their game. They are writing, editing, formatting, trimming, enhancing their blogs to offer maximum value. This Log Buffer Edition #306 cherishes these efforts.
Oracle:
To use ASMlib or not to use ASMlib? That is the question, and James Morle has more.
This is what happens when a vacation in Hawaii fades away for Richard Foote.
Charles Hooper has a feeling ANSI About Oracle Join Syntax?
[Read more...]
posted by
The Pythian Group
on
Fri 25 Jan 2013 14:08 UTC
Tags:
When it comes to information and its management, nothing compliments information more than the database. This Log Buffer Edition #304 covers the latest and greatest database technologies related to Oracle, SQL Server and MySQL.
Oracle:
Vikram Das is discussing a case study of an error aftering cloning OTM database and the instance.
Katsumii blogs about attaching to foreground process with strace in sh script.
Is Oracle Changing The Way That Exams Are Scored? Brandye Barrington asks.
[Read more...]
posted by
The Pythian Group
on
Fri 11 Jan 2013 07:00 UTC
Tags:
Sky’s the limit for the database bloggers. They are producing awesome rants in Oracle, fabulous ramblings in MySQL, and fantastic views in SQL Server, and this Log Buffer Edition, very proudly covers all that in Log Buffer #303. Enjoy.
Oracle:
You may have encountered the problem where you can connect to your Oracle database through the listener but cannot connect locally even though the value of ORACLE_SID in your environment is correct. Iggy Fernandez has more.
We now have Oracle Tuxedo channel at youtube,
[Read more...]
posted by
The Pythian Group
on
Fri 04 Jan 2013 07:00 UTC
Tags:
There is no great joys for the bloggers to mark the holiday season with some blistering and lightweight blog posts. This Log Buffer Edition in Log Buffer #302 shares that mirth and presents you with another medley of blogs.
Oracle:
Eddie Awad asks; Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise.
It’s the end of the year, and the start of the year, and thus time for the ‘best of’,
[Read more...]
posted by
The Pythian Group
on
Fri 28 Dec 2012 09:29 UTC
Tags:
This year’s last log buffer edition looks at the marvelous and splendid blog posts of Oracle, SQL Server and the MySQL databases which promise to bring more and more next year. This Log Buffer #301 promises to be the anchor for yet another action packed blogging carnival next year.
Oracle:
Kristin Rose is asking to join hands and hearts this holiday season with Oracle.
Phill Hill has a nice post about Open as in Transparent: Instructure Conducts 2nd Public
[Read more...]
posted by
The Pythian Group
on
Fri 21 Dec 2012 05:33 UTC
Tags:
If you are reading this, it means that world moves on and somebody somewhere was wrong in predicting the end of it. The ageless Log Buffer Edition presents you yet again some cool blog posts just before the holiday season to top up your excitement. This Log Buffer #300 is as sweet as the holidays...
posted by
The Pythian Group
on
Fri 14 Dec 2012 06:48 UTC
Tags:
Screenings, shows, premieres and parties. Where the stars have been spotted this week? No not on the red carpet in LA, but in this Log Buffer Edition. In Log Buffer #299, stars of Oracle, SQL Server and MySQL are twinkling. Get mesmerized!!! Oracle: Pythian’s very own Marc Fielding is revealing the hints behind the Automatic...
posted by
The Pythian Group
on
Fri 07 Dec 2012 07:15 UTC
Tags:
It’s always sunny in the database arena, even if the data is engulfed in the clouds. Innovation rays keep databases illuminating and bloggers make hay in this sunshine and this Log Buffer Edition sift through all those blog post and brings you Log Buffer #298. Oracle: When Michael Abbey writes it, it stays written. His...
posted by
The Pythian Group
on
Sat 01 Dec 2012 00:24 UTC
Tags:
From Movember to UKOUG, Pythian is stomping the grounds with massive thuds. This Log Buffer #297 collects various great blog posts from across the database world once again. Enjoy the Log Buffer Editions. Oracle: Andre Araujo posts about the union of MoBros, all of them DBAs :) Are you in UK and got penchant for...
posted by
The Pythian Group
on
Fri 23 Nov 2012 06:00 UTC
Tags:
This week’s Log Buffer #296 focuses on Oracle, SQL, and MySQL weblogs from across the planet. Log Buffer Editions are the manifestation of the fact that nerd bloggers from databases are not only growing but they are also producing immense volume of quality ramblings. Enjoy. Oracle: Stelios Charalambides book on SQLTXPLAIN is now announced, Carlos...
posted by
The Pythian Group
on
Fri 16 Nov 2012 06:00 UTC
Tags:
Horizon is getting cloudier. But these low hanging clouds are not darker or ominuous in any way. These are the clouds of enabling technologies providing mortals, drops of technologies according to their wishes. Behind this seamless information troposphere, databases are floating, again on demand. This Log Buffer Edition showers the droplets of blogs from databases...
posted by
The Pythian Group
on
Sat 10 Nov 2012 02:34 UTC
Tags:
Log writer process of Oracle is one of the most revered background process, a real work horse, a real charming darling who keeps the whole Oracle database system consistent and humming beautifully and many technologies in Oracle sprout from this good old process. Consistency is the key in database systems, and so in the Log...
posted by
The Pythian Group
on
Fri 26 Oct 2012 07:00 UTC
Tags:
This Log Buffer Edition is once again here, packed with rocking and rolling blogs from the database world. Log Buffer#292 comprises of select few posts from Oracle, MySQL and the SQL Server. Enjoy. Oracle: Pythian’s OCM Andrey Goryunov is attracted and enticed by the silent installation of EM Cloud Control 12c. Bobby Durrett is helping [...]
posted by
Devart Team
on
Fri 19 Oct 2012 15:15 UTC
Tags:
Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file. Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database [...]
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.