Discuss in the Community

Blogs

zaheer.appsdba
Follow /24 May 2015 at 1:21pm / Oracle

Database Instance terminated due to ZFS data pool SUSPENDED

On one of the TEST severs there are several databases hosted on one single mount-point configured on single ZFS data pool.  We received  multiple requests from users that the databases running on these servers are not accessible.  When we Investigate...
6 0 /
Porus Homi Havewala
Follow /24 May 2015 at 10:30am / Oracle

Enhancements to the Oracle Multitenant option in Oracle Database 12.1.0.2 – Part XI

In this blog post series, we are looking at noteworthy enhancements to the Oracle Multitenant option of the Oracle Database in 12.1.0.2. In the previous post, we looked at “ Rapid Home Provisioning ”. Another new feature in 12.1.0.2 is...
54 0 /
Fernando Garcia
Follow /23 May 2015 at 10:35pm / Oracle

Oracle y las contraseñas que hay que cambiar

Cuando creamos una base de datos Oracle se crean diversas cuentas de usuario. Es probable que estas cuentas hayan quedado con sus contraseñas por defecto. Si bien muchas de estas cuentas estarán expiradas y bloquedas, Oracle nos recomienda...
67 0 /
John Weathington

How to Manage Requirements The Right Way

A Requirement For All Seasons How do you manage changing requirements when you have bits and pieces documented everywhere? Your project manager may want a chunk for their standard project overview, your developers need your requirements to create design...
62 0 /
Sten Vesterli
Follow /22 May 2015 at 2:58pm / Oracle

Making Agile and Waterfall Work Together

Developers love new agile methods, not least because it focuses less on writing things down and more on writing code. That allows developers to change things faster. DBA's, on the other hand, prize stability over change. Therefore, they are often...
133 0 /
zaheer.appsdba
Follow /22 May 2015 at 2:32pm / Oracle

Oracle Database 12c – Immediate Kill Session

Recently we have deployed a new Oracle database 12c for our portal application. One of our developer complained that one of his portal schema session is getting terminated continuously. When we Investigate the alert log file then same error has been reported...
77 0 /
WaterOx
Follow /22 May 2015 at 2:30pm / SQL Server

004 – Cracked Foundation - WaterOx Consulting

Reading Time: 4 minutes Do You Have a Cracked Foundation? in WOxPod!, episode # 004 –... The post 004 – Cracked Foundation appeared first on WaterOx Consulting .
89 0 /
Dinesh Asanka
Follow /22 May 2015 at 5:56am / SQL Server

MSSQL Server 2016 coming with JSON Support

With over a thousand votes on the Microsoft Connect site, JSON support is the most requested feature for SQL Server 2016. This month, Microsoft announced that the upcoming release of SQL Server 2016 will fulfill that request. Sort of. Microsoft will certainly...
101 0 /
Josh Howard
Follow /21 May 2015 at 7:26pm / Toad for Oracle

The Most Important Roles and Responsibilities of Today’s DBA—Can You Relate?

DBAs perform a ton of tasks, and the demands on their time have changed as database technology has evolved and new capabilities have been introduced. Sure, some tasks that were once performed manually are now automated – but regardless of eased...
101 0 /
sqlkris
Follow /21 May 2015 at 1:00pm / SQL Server

What is the Difference between a Primary Key and a Foreign Key?

In this article we learn the difference between primary and foreign keys, and why both are important to maintaining a relational database structure. All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012...
160 0 /
Gethyn Ellis
Follow /21 May 2015 at 1:00pm / SQL Server

Creating an Azure SQL Database

By David Postlethwaite Once you have logged in to the Azure Management Portal you can start to create an Azure SQL Database. Azure SQL Database is an example of Platform as a Service (PaaS), we don’t have to build a Windows server or install the SQL software...
110 0 /
MattSQL
Follow /21 May 2015 at 10:25am / SQL Server

Behaviour change for delete … output … into in SQL Server 2014

A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded one of our servers from SQL 2012 to SQL 2014 and a job started failing. (Although I haven’t explicitly tested this behaviour...
110 0 /
Deiby Gomez
Follow /21 May 2015 at 8:13am / Oracle

Install DB Software 12.1.0.2 for RAC in Silent Mode

First we have to have all our nodes with the process of the GI running: [root@rac2-12c ~]# crsctl check cluster -all ************************************************************** rac1-12c: CRS-4537: Cluster Ready Services is online CRS-4529: Cluster...
198 0 /
Deiby Gomez
Follow /21 May 2015 at 6:19am / Oracle

Failed to write the checkpoint 'ROOTCRS_STACK'

Hey everybody, today I will show you an error that I had yesterday while I was Installing GI 12.1.0.2 in my test environment in order to practice features of this new version. Well, everything was going well until I got the step 19 of the Installation...
213 0 /
Brad Wulf
Follow /20 May 2015 at 9:16pm / Toad - Mac Edition

Toad Mac Edition – The single most important feature you can learn before Memorial Day

Disclaimer - This article is a bit tongue in cheek, but the inspiration for the post came from real world feedback from our user community. I've had multiple comments that the behavior described below is one of the key features that users rely on...
165 0 /
Ed Elliott
Follow /20 May 2015 at 7:00pm / SQL Server

MergUi 0.1.9

What is MergeUi? A Visual Studio Addin to create and edit MERGE statements in SSDT projects. What have you done? I have released a new version of MergeUi, thanks to Luca Zavarella for prodding me into getting this release out and for pointing...
117 0 /
David Fitzjarrell
Follow /20 May 2015 at 6:00pm / Oracle

That Depends

In every universe there are questions that either: Have no answer or Have an answer that is situation-dependent and that includes the Oracle universe. Sometimes it’s difficult to get that concept across to the less knowledgeable. Let’s...
110 0 /
Ed Elliott
Follow /20 May 2015 at 5:41pm / SQL Server

Putting the ORM debate to bed

Hopefully this should put the ORM debate to bed, either use an ORM or don't but please don't access tables directly... There are obviously reasons behind all of this but if you follow this golden rule you will have a happy DBA and user base...
120 0 /
Jen McCown
Follow /20 May 2015 at 5:12pm / SQL Server

Coming soon: Minion Backup, featuring table based scheduling!

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup arrives on June 1! Minion Backup by MidnightDBA is a stand-alone database backup module.  Once installed, Minion Backup automatically backs up...
128 0 /
James Serra
Follow /20 May 2015 at 4:00pm / SQL Server

SQL Server 2016 public preview arriving this summer

SQL Server 2016 was recently announced.  Top new features include: Always Encrypted protects data at rest and in motion.  With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the...
127 0 /
WaterOx
Follow /20 May 2015 at 3:30pm / SQL Server

SQL F.A.D. – Daily Identity Reset - WaterOx Consulting

Reading Time: 3 minutes Sometimes you have to do some things considered pretty strange in your... The post SQL F.A.D. – Daily Identity Reset appeared first on WaterOx Consulting .
111 0 /
Derik Hammer
Follow /20 May 2015 at 2:05pm / SQL Server

QS-Config v2.0 Enters Open Beta: Major Refactoring

QS-Config v2.0 has passed closed beta and is now entering open beta . Feature changes / additions: Supports PowerShell v2.0 and higher. Supports SQL Server 2014. One script for all supported versions of SQL Server, rather than a script per version...
111 0 /
Michael J. Swart
Follow /20 May 2015 at 1:00pm / SQL Server

It’s Hard To Destroy Data

It is surprisingly difficult to delete data permanently. SQL Server has sophisticated features that prevent all kinds of data loss, but the opposite is not true. SQL Server has very few features that help you destroy data. But why would anyone need...
135 0 /
Kenneth Fisher
Follow /20 May 2015 at 1:00pm / SQL Server

Adding new users & groups in windows

I do a lot of testing with security in SQL Server. And of course to do a thorough job of it I need not just SQL Server logins but Windows logins. And that means I need to be able to create and delete windows users and groups. I could do this with the...
107 0 /
DuncanDavies
Follow /20 May 2015 at 1:00pm / Oracle

I’m Iouri Chadour and this is how I work

May’s entry in the ‘How I Work’ series is PeopleSoft Blogger Iouri “Yury” Chadour. Yury has been sharing his knowledge on his Working Scripts blog for 7 years, so is a valuable and consistent member of our community. Yury’s...
101 0 /