Discuss in the Community

Blogs

Kenneth Fisher
Follow /20 Aug 2014 at 1:00pm / SQL Server

Two years!

Two years ago today I began my blog with a post about the DEFAULT keyword . I set out with the goal of building a blog I could be truly proud of in three years. One that was well liked and provided value to the community. Little did I imagine how much...
42 0 /
Pradeep Adiga
Follow /20 Aug 2014 at 12:35pm / SQL Server

Create and connect to a SQL Database on Windows Azure

Azure , is one of the fastest growing cloud platform by Microsoft. In this simple post, I will create and connect to a SQL Database on Microsoft Azure. To get started logon to the Microsoft Azure Management Portal  , navitage to SQL Database and click...
9 0 /
Mohamed Azar
Follow /20 Aug 2014 at 9:35am / Oracle

Oracle 12c (12.1.0.2.0) database step by step installation guide on redhat linux 5.6

Download Document here Oracle 12c database installation guide on redhat linux 5.6
17 0 /
gilallouche
Follow /19 Aug 2014 at 10:51pm / NoSQL

Big Data Takes Over Wimbledon

Big data technology is popping up everywhere, often times in the areas where you least expect it. 2014, especially, has been a banner year for big data. It’s entering more industries than ever and becoming more and more mainstream. It’s versatility...
16 0 /
karen.r.morton
Follow /19 Aug 2014 at 8:39pm / Oracle

Understanding Optimizer Statistics and Keeping Them Simple - Part 4

Last time, in Part 3 , I reviewed collecting statistics on data dictionary and fixed objects. In today's post, I want to continue our discussion on gathering stats from Part 2 and review setting collection parameters in more detail. Setting Parameter...
22 0 /
rickdelgado
Follow /19 Aug 2014 at 8:36pm / NoSQL

How to Tell When Your BYOD Policy is Failing

Bring Your Own Device (BYOD) was supposed to usher in the next productivity boost for businesses all over the world. It seemed so simple--just allow employees to use their personal devices for their jobs and watch as they become happier and more productive...
13 0 /
WaterOx
Follow /19 Aug 2014 at 3:00pm / SQL Server

Export a SSMS Query Result Set to CSV

Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools. The simplest way is to select all results and then copy & paste them into whichever other...
24 0 /
Syed Jaffar Hussain
Follow /19 Aug 2014 at 10:01am / Oracle

Oracle 11204 Clusterware upgrade - ASM glitch

Yet another tough challenge thrown at my team right after the disaster recovery (DR) simulation drill which performed barely couple of weeks ago. The new task (challenge) in hands is to upgrade the existing four cluster environments from 11.2.0.2 to 11...
15 0 /
Tom LaRock
Follow /19 Aug 2014 at 3:19am / SQL Server

HOW TO: Find Currently Running Long SQL Agent Jobs

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently , I decided to verify that this script still works for finding long running jobs in SQL Agent for...
30 0 /
rickdelgado
Follow /18 Aug 2014 at 8:11pm / NoSQL

3 Potential Problems with BYOD

With more and more companies opting to officially adopt a BYOD (Bring Your Own Device) workplace, it seems inevitable that the offices of the world will soon be running not on corporate-owned system and devices, but on the personal machines of the average...
16 0 /
Chris Yates
Follow /18 Aug 2014 at 8:08pm / SQL Server

And Just Like That….Three Years

Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today that three years have passed since I first started this adventure called blogging. With this blog you will not find perfection, instead...
33 0 /
Stuart Ainsworth
Follow /18 Aug 2014 at 7:05pm / SQL Server

Managing a Technical Team: Building Better

Heard a great podcast the other day from the team at Manager Tools , entitled “THE Development Question”.  I’m sorry to say that I can’t find it on their website, but it did show up in Podcast Addict for me, so hopefully you can pick it up and give...
32 0 /
Kellyn PotVin
Follow /18 Aug 2014 at 7:00pm / Oracle

Weblogic Start Failure: Empty Initial Replica

This post is to address a failed Weblogic start in EM12c.  The fix is performed on a Windows host, but the fix can easily be for any EM12c environment that experiences this issue.  In the below instructions, just replace the %OMS_BASE% for Windows Env...
28 0 /
Ryan Adams
Follow /18 Aug 2014 at 2:51pm / SQL Server

SQLSaturday Precon Cost Structure

Many of you may already know that I am a PASS regional mentor for the South Central region of the United States.  My role is to help user group leaders obtain the tools they need to have successful groups and provide an open platform to discuss challenges...
32 0 /
Kenneth Fisher
Follow /18 Aug 2014 at 1:00pm / SQL Server

Generating a restore script

In order to speed up our backups on a large database our team decided to stripe the backup files. In case you weren’t aware of this particular backup feature it his means that a single backup is written to multiple files which can dramatically speed...
36 0 /
Chris Webb
Follow /18 Aug 2014 at 11:20am / SQL Server

Removing Punctuation From Text In Power Query

In one of my first posts on Power Query (and still my favourite) I found the top 100 words in the complete works of Shakespeare . As always when you’re learning a new tool, though, I look back at what I wrote then and realise there are better ways of...
37 0 /
Richard_RP
Follow /18 Aug 2014 at 10:27am / SQL Server

How To Split Non-Empty Partitions When A Clustered Columnstore Index Exists on The Table

Another pithily titled blog post, but this one revisits the feature of SQL Server 2014 that piqued my interest the most: Clustered Columnstore Indexes. I’ve been working with Clustered Columnstore Indexes for the past few months and recently a colleague...
36 0 /
Mohamed Azar
Follow /18 Aug 2014 at 10:04am / Oracle

find out which device mapped with oracle asm disk

Step 1 : [oracle@asmoracle ~]$ /etc/init.d/oracleasm listdisks DISK1 DISK2 DISK3 DISK4 Step 2 : [oracle@asmoracle ~]$ /etc/init.d/oracleasm querydisk -d DISK1 Disk “DISK1″ is a valid ASM disk on device /dev/sdc1[8,33] The...
35 0 /
Melissa Coates
Follow /18 Aug 2014 at 2:13am / SQL Server

Using Power Query to Get Data From an Excel File in OneDrive Via URL

In this blog entry I'm going to discuss accessing an Excel file that's stored in OneDrive. What I do *not* want to do is associate the files to my local file path such as c:\users\melissa\onedrive... because another person who downloads the workbook...
43 0 /
Jen Stirrup
Follow /17 Aug 2014 at 9:42pm / SQL Server

Day 6: The Data Analysts Toolkit: Why are Excel and R useful together, and how do we connect them?

Why is analytics interesting? Well, companies are starting to view it as profitable. For example, McKinsey showed analytics was worth 100Bn today, and estimated to be over 320Bn by 2020. When I speak to customers, this is the 'end goal' - they...
49 0 /
David Fitzjarrell
Follow /17 Aug 2014 at 8:40pm / Oracle

“You’re A Real ACE”

Recently I was declared, for want of a better word, an Oracle ACE. I was nominated by someone I respect and admire; just the nomination itself was enough, really, to make my day. When I received notification that I had been selected I was truly surprised...
50 1 /
Porus Homi Havewala
Follow /16 Aug 2014 at 3:52pm / Oracle

Managing Oracle Database 12c with Enterprise Manager – Part I

A friend from a lovely country in South America wrote to me today: “Hi My Friend!! My colleague has installed an Oracle Database 12c Container database (CDB) and he has created 2 Pluggable databases (PDBs) on it. He is keen to manage the CDB...
61 0 /
Kellyn PotVin
Follow /16 Aug 2014 at 1:15am / Oracle

Monitoring a Microsoft OS Failover Cluster

I know, I know-  none of you are using Microsoft Windows.  This is why I get so many questions on this topic and why there is so much interest in a white paper that no one thought I needed to write.  Well, while that pesky ol’ white paper is in...
55 0 /
Lukas
Follow /15 Aug 2014 at 10:22pm / Toad Extension for Eclipse

Export and Import your database data

Users call for better support on Exporting and Importing data was heard and in version 2.0.4 enhanced Export Data and Import Data features have been introduced. Export Data Export settings Export data from Object Explorer to SQL and CSV...
56 0 /
Jason Strate
Follow /15 Aug 2014 at 5:00pm / SQL Server

Reblog: August 8 to August 14

Photo credit – Jenn and Tony Bot Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s...
73 0 /