Discuss in the Community

Blogs

Chris Webb
Follow /22 Dec 2014 at 3:00pm / SQL Server

Viewing Error Messages For All Rows In Power Query

One of the great features of Power Query is the way you can view any rows that contain error values when you load data. However, even if you can see the rows that have errors you can’t see the error messages easily – without writing a little bit of M...
15 0 /
Kevin Kline
Follow /22 Dec 2014 at 1:00pm / SQL Server

DBTA – Big Data and Microsoft SQL Server HDInsight

It’s time to follow up with a discussion of Microsoft’s cloud-centric approach to big data using HDInsight. MICROSOFT SQL SERVER AND BIG DATA IN THE CLOUD HDInsight is a 100% Apache Hadoop service, currently at v2.2, available through Microsoft’s...
26 0 /
Anand
Follow /22 Dec 2014 at 11:17am / Oracle

ORA-00600: [ktbdchk1: bad dscn]

Last week I had performed switchover activity of database on version 11.2.0.3 The switchover was performed using dgmgrl “swicthover to standby” command. After sometime we started receiving “ORA-00600: [ktbdchk1: bad dscn]” on the...
29 0 /
Ajith Narayanan
Follow /22 Dec 2014 at 6:50am / Oracle

Kickstart Your Oracle Apps R12.2 Upgrade Project With Upgrade Readiness Report Analysis

Hi All, If you are planning for a R12.2 upgrade, To get initial idea on how much of work is required for standard & custom remediation and making it online patching compliant, we can start with upgrade readiness patch and API's Readiness Assessment...
30 0 /
Rohit Garg
Follow /22 Dec 2014 at 4:14am / SQL Server

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of RPC in cluster” ? The Remote Procedure Call (RPC) [http://support.microsoft.com/kb/832017] system service...
31 0 /
Mike Smithers
Follow /21 Dec 2014 at 6:48pm / Oracle

Installing VirtualBox on Mint with a CentOS Guest

Christmas is almost upon us. Black Friday has been followed by Small Business Saturday and Cyber Monday. The rest of the month obviously started on Skint Tuesday. Fortunately for all us geeks, Santa Claus is real. He’s currently posing as Richard...
37 0 /
Natik Ameen
Follow /21 Dec 2014 at 3:01pm / Oracle

Happy Holidays and a Prosperous New Year from VitalSoftTech!

We at VST want to thank you, our prestigious members, for making 2014 a memorable year for us!  We are ever so grateful for your continuous support, participation and words of encouragement.  As technological mavens, you help us sustain this community...
35 0 /
Melissa Coates
Follow /20 Dec 2014 at 10:14pm / SQL Server

Big Changes - What You Need to Know About the Power BI Public Preview

Yesterday Microsoft released a Public Power BI Preview for customers to evaluate new features in Power BI. This newly redesigned platform offers many familiar components, as well as some new and unique features. Which means you may be asking yourself...
49 0 /
Paul Turley
Follow /20 Dec 2014 at 9:52pm / SQL Server

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer.  What is it and why is it important?  The most significant thing about it is that report and dashboard users do not need to have...
348 0 /
Porus Homi Havewala
Follow /20 Dec 2014 at 4:51am / Oracle

Separate or one Enterprise Manager environment for managing prod and non-prod targets

A friend wrote: I know we can manage all targets using one single Enterprise Manager 12c environment but I know there are advantages of having two separate environments, one for Prod targets and the other for non-Prod targets. Please explain pros and...
80 0 /
Craig Mullins
Follow /19 Dec 2014 at 9:30pm / IBM DB2

Season's Greetings

Seasons Greetings And a hearty "Hello!" to everybody out there... just a short post today to wish everybody a very happy holiday season. This is the time of year when work starts winding down somewhat and people start to spend time with their...
22 0 /
Kevin Kline
Follow /19 Dec 2014 at 5:27pm / SQL Server

First Ask “Why”, then Ask “How”

A common refrain we hear when presenting at technical conferences and training events is “How can I get promoted into IT management?” We hear this so often that we’ve worked out a sort of mental flowchart for the subsequent dialog. (We are IT people after...
50 0 /
Tim Radney
Follow /19 Dec 2014 at 4:07pm / SQL Server

I am joining SQLskills

I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to join an incredible team of SQL Server professionals and continue growing in my SQL career.  I am very excited to be working with some of the best in the...
65 0 /
Jason Strate
Follow /19 Dec 2014 at 4:00pm / SQL Server

Reblog: December 12 to December 18

Photo credit – Travis Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing...
57 0 /
Sten Vesterli
Follow /19 Dec 2014 at 1:41pm / Oracle

Why do Clever People Use Bad Tools?

We all like to work on projects that use our favorite tools - like the Oracle database. Some organizations arrive at a good decision through a rational decision process (which often leads to proven technology like relational databases) while others...
70 0 /
Arthur Olcot
Follow /19 Dec 2014 at 1:38pm / SQL Server

XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t know or need to know the attribute names. By using this axis you can access all of the attributes within the given...
48 0 /
Tracy McKibben
Follow /19 Dec 2014 at 1:00pm / SQL Server

Friday Followup For December 19, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week sp_BackupDatabases v1.3 Cheating DBCC To Fix Index...
62 0 /
Kamran Agayev
Follow /19 Dec 2014 at 12:01pm / Oracle

Beware default tablespace during Data Pump import

Today, while importing one database to another, my colleague (Turkel) got a tablespace issue despite the fact that he used REMAP_TABLESPACE for almost all available tablespaces of the source database. After investigating, we saw that there’re a...
54 0 /
Gethyn Ellis
Follow /19 Dec 2014 at 10:58am / SQL Server

Offer – Any e-book for $5

Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5 (£3.60 in British money). This includes my book, Getting Started with SQL Server 2012 Administration The offer will run from Thursday 18th Dec...
60 0 /
Dinesh Asanka
Follow /19 Dec 2014 at 5:08am / SQL Server

SQL Server 2014 – Delayed Transaction Durability

Prior to SQL Server 2014, SQL Server used a Write Ahead Log (WAL) mechanism which means that changes are written to the transaction log before they are committed. The major advantage with this mechanism is that there will be no data loss . However, since...
127 0 /
Kellyn PotVin
Follow /19 Dec 2014 at 1:11am / Oracle

EM12c and the Optimizer Statistics Console

Today we’re going to review another great feature in the EM12c that you may not have realized was available.  Once logged into a database target, click on the Performance menu and navigate to the Optimizer Statistics Console: Optimizer Statistics...
58 0 /
Chris Reyes
Follow /18 Dec 2014 at 8:32pm / Oracle

Invoker Rights for PL/SQL Compiler Options

Invoker Rights Hi! Another blog on PL/SQL compiler options. Lets discuss invoker rights. Invoker rights controls the ownership of the objects the procedure/function/package will look at based on the option used. There are 2 options...
60 0 /
khanine
Follow /18 Dec 2014 at 6:55pm / Oracle

Database Professional's Introduction to Records Management

Virtually every medium to large organization has Information Management policies and procedures in place that are very important to its core business activities. Now, because all (or almost all) of your information is stored in the database - chances...
82 0 /
Shaun Stuart
Follow /18 Dec 2014 at 4:00pm / SQL Server

Using PowerShell For More Readable Log Files

Most of the scheduled jobs on my SQL Servers write some sort of output to a log file. Most of the time, it's just the output of a SQL statement. However, for some of my longer, more complicated routines, the procedures I write include PRINT statements...
129 0 /
Fernando Garcia
Follow /18 Dec 2014 at 12:02am / Oracle

El verdadero secreto del VI

El viejo y famoso editor vi es como Diego Armando Maradona. Por un lado están sus amantes incondicionales; por otro, sus acérrimos enemigos. Hace tiempo, un evangelizador del vi me dijo: - “ Si no utilizas correctamente el vi...
174 0 /