Showing entries 101 to 110 of 390
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: SQL Server (reset)
Log Buffer #316, A Carnival of the Vanities for DBAs

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 AUTOALLOCATE.

[Read more]
Log Buffer #315, A Carnival of the Vanities for DBAs

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

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

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 information security and …

[Read more]
Log Buffer #312, A Carnival of the Vanities for DBAs

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 Jonathan asks, it stays …

[Read more]
Log Buffer #311, A Carnival of the Vanities for DBAs

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

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

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 RAC? Pythian’s own …

[Read more]
Log Buffer #307, A Carnival of the Vanities for DBAs

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

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 takes a single string, which acts to filter the result set …

[Read more]
Showing entries 101 to 110 of 390
« 10 Newer Entries | 10 Older Entries »