Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 324 Next 30 Older Entries

Displaying posts with tag: SQL Server (reset)

Log Buffer #319, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

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...]
Log Buffer #318, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
On the threshold
+0 Vote Up -0Vote Down

When you setup a monitoring system for SQL Server, you often use thresholds to determine when an instance is healthy. You might say that you want to be alerted when CPU use is over 90% or when there’s only 10% of disk space left. The trouble with these thresholds is that they will often throw off false positives, or send you an alert when really nothing is wrong. Simple thresholds often have to be tuned to the individual instance, since a server with 10 TB still has 1 TB of space left at 90% disk use.

Baron Schwartz blogged about this issue in

  [Read more...]
Extending Reporting Services
+0 Vote Up -0Vote Down

I am doing a reporting proof-of-concept (POC) for my company. Business intelligence (BI) is often the last thing that gets thought of during an application’s life cycle because it’s only really necessary after you get customers. Before that, the main focus is on application features. Soon after launch, your coworkers and your customers start asking questions about usage and adoption, and customers start to ask for summary information on their data as well as just dumping their data. If you’re the only guy in charge of the database, this is often overwhelming.

Thankfully, we now have many options for what’s called self-service BI. The developer or DBA sets up the basic data models (say Orders) in an automated tool like SQL Server Reporting Services (SSRS) and then allows an

  [Read more...]
Log Buffer #317, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

Reminders are an inevitable part of our personal and professional lives. Keep reminding of oneself about goals, priorities, and milestones is key to stay on top of things. This Log Buffer Edition is a reminder about all those not-to-be-missed blogs out there.

Oracle:

One of the developers was performing a delete using a nested subquery, which was throwing out ORA-00600 errors. The ORA-00600 Lookup Tool on MOS suggested it was caused by a bug, Tim Hall reports.

The healthcare sector has a clear opportunity to modernize care delivery by adopting new data interchange standards and EHR systems. Kyle opines.

  [Read more...]
Log Buffer #316, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #315, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #314, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #313, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #312, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #311, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

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...]
Log Buffer #309, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #308, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #307, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
A T-SQL Table Function
+1 Vote Up -0Vote Down

I had an interesting conversation about table functions in Oracle’s PL/SQL; and the fact that they’re not available in MySQL. When I explained they’re available in Microsoft T-SQL User-Defined Functions (UDFs), my students wanted a small example. One of them said they’d tried to do it but couldn’t get it to work because they found the Microsoft web pages difficult to read and use. Specifically, they didn’t like the sparseness of this one on how to create a function.

Here’s a quick definition of a UDF table function that runs in the studentdb schema (created in this post for migrating SQL Server into a MySQL database). The following getConquistador function

  [Read more...]
Log Buffer #306, A Carnival of the Vanities for DBAs
+0 Vote Up -1Vote Down

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...]
Log Buffer #304, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #303, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Our 2013 Database survey is now live
+0 Vote Up -0Vote Down

451 Research’s 2013 Database survey is now live at http://bit.ly/451db13 investigating the current use of database technologies, including MySQL, NoSQL and NewSQL, as well as traditional relation and non-relational databases.

The aim of this survey is to identify trends in database usage, as well as changing attitudes to MySQL following its acquisition by Oracle, and the competitive dynamic between MySQL and other databases, including NoSQL and NewSQL technologies.

There are just 15 questions to answer, spread over five pages, and the entire survey should take less than ten minutes to complete.

All individual responses are of course

  [Read more...]
Log Buffer #302, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #301, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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...]
Log Buffer #300, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
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...
Log Buffer #299, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
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...
Log Buffer #298, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
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...
Log Buffer #297, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down
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...
Log Buffer #296, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
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...
Log Buffer #295, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
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...
Log Buffer #294, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down
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...
Log Buffer #292, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
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 [...]
Adapting Diagram File to Another Database
+0 Vote Up -0Vote Down
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 [...]
Previous 30 Newer Entries Showing entries 31 to 60 of 324 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

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.