Discuss in the Community - Toad World

Discuss in the Community


Derik Hammer
Follow /13 Oct 2015 at 2:00pm / SQL Server

Counting NULLs and sub-sets of data

Quick Tip: Counting NULLs and sub-sets of data You have been asked to produce a chart which will visualize a few data points. Total work orders. Total closed work orders (work orders with EndDate populated). Total open work orders (work orders...
4 0 /
Shaun Stuart
Follow /13 Oct 2015 at 2:00pm / SQL Server

Enabling Data Compression – October 2015 Update

It’s been about a year and a half since I last posted an update to my script that scans databases for objects to compress and, optionally, compresses them. This time around, I’ve just incorporated a bug fix and added a check to make sure the...
6 0 /
Jason Brimhall
Follow /13 Oct 2015 at 1:21pm / SQL Server

Intro to Reading Event_File Target Data

Having covered the metadata for a deployed session from just about every angle (yes there is more on metadata that could be discussed, has not yet been discussed, and that I am not planning on covering at this time), it is high-time to start figuring...
14 0 /
Kenneth Fisher
Follow /13 Oct 2015 at 1:00pm / SQL Server

Keep an eye on those Audit files!

This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine ( b / t ). He has picked an interesting security subject. SQL Server Audits. Fortunately this is one I have a bit of experience with. It’s one of my favorite new features if only...
20 0 /
Craig Mullins
Follow /12 Oct 2015 at 7:48pm / IBM DB2

OK, So How Does the CURRENTDATA Parm Work?

There seems to be a LOT of confusion out there in DB2-land about the CURRENTDATA parameter, so I thought it might be helpful to blog about the subject. So first things first: CURRENTDATA is a BIND parameter that can be specified when you bind or rebind...
104 0 /
Abu Fazal Abbas
Follow /12 Oct 2015 at 5:32pm / Oracle

Oracle 12c ( Time to revoke SELECT (we have READ to offer)

In today’s post, I am going to discuss yet another enhancement that is introduced with Oracle database 12c ( Prior to Oracle 12c (, whenever we had a requirement to create read only users, we used to grant those users the SELECT...
96 0 /
Jen McCown
Follow /12 Oct 2015 at 3:37pm / SQL Server

Attending PASS Summit? Take a great Tuesday precon!

We’re just two weeks away from the PASS Summit in Seattle,  and there is most definitely still time to get into our Tuesday pre-conference session, “The Enterprise Scripting Workshop“. That’s a full day of training with 100 of...
143 0 /
Henrik Loeser
Follow /12 Oct 2015 at 3:25pm / IBM DB2

Utilizing User-Provided Services to Link Bluemix Apps to External Databases

12 0 /
Denny Cherry
Follow /12 Oct 2015 at 3:00pm / SQL Server

Your PASS Speaker Idol 2015 Top 12 Are…

The time has come. It’s time to announce who the 12 people who will be competing for the glory that comes with beating down 11 of your #sqlfamily members in public. These 12 fine folks will be competing for the grand prize … a speaking spot...
143 0 /
Guy Harrison
Follow /12 Oct 2015 at 11:22am / Oracle

Vector clocks

Once of the concepts I found difficult initially when looking at non-relational systems is the concept of the vector clock. Some databases – like Cassandra - use timestamps to work out which is the “latest” transaction. If there are...
34 0 /
Guy Harrison
Follow /12 Oct 2015 at 11:06am / Oracle

Exploring CouchBase N1QL

Couchbase recently announced Non-first Normal Form Query Language (N1QL) – pronounced “Nickel” – a virtually complete SQL language implementation for use with document databases, and implemented within the Couchbase server 4.0...
15 0 /
Chris Webb
Follow /11 Oct 2015 at 9:46pm / SQL Server

Are You Going To PASS Summit 2015? I Need Your Help!

This year at the PASS Summit I’m delivering a rather ambitious and risky session. Here’s the abstract: Analyzing Audience Reaction to the PASS Summit Keynote If you’ve been to PASS Summit before, you know that social media channels such as Twitter...
141 0 /
Fernando Garcia
Follow /11 Oct 2015 at 5:11pm / Oracle

Cómo gestionar bajas lógicas en una base de datos Oracle.

Bajas lógicas no, bajas lógicas sí. No es mi idea debatir aquí sobre la conveniencia o no del uso de bajas lógicas o físicas. En Internet hay mucha literatura al respecto. Lo que hoy quiero hacer es contarte acerca...
135 0 /
Porus Homi Havewala
Follow /11 Oct 2015 at 7:13am / Oracle

Enterprise Manager Repository in a PDB

A frequent question asked by current users of Enterprise Manager, or by totally new users who are planning to install, is: “Can the entire Enterprise Manager Repository be installed in a Pluggable Database (PDB) in an Oracle 12c Container Database...
51 0 /
Iggy Fernandez
Follow /10 Oct 2015 at 2:00pm / Oracle

Sound an alarm: Sharding in the next release of Oracle Database 12c!

Sound an alarm! Your silver trumpets sound And call the brave, and only brave, around Who listeth, follow: to the field again! Justice with courage is a thousand men. Sound an alarm. —from Handel’s oratorio “Judas Maccabeus”...
855 0 /
Arthur Olcot
Follow /10 Oct 2015 at 11:02am / SQL Server

Indexed views on any core SQL server edition–The video

A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition . It has proved to be one of my most read blog posts. Since then Webucator , provider of SQL Server training, got in contact...
60 0 /
Ed Elliott
Follow /9 Oct 2015 at 10:39pm / SQL Server

Video of #sqlrelay talk - build a ci pipeline in 55 minutes

My session yesterday was recorded, apart from the fact that me and mark were having a chat for about 25 minutes before it kicked off it seemed to work quite well: http://www.ustream.tv/recorded/75059912 Skip forward to 24:32 to get to the actual...
66 0 /
Ryan Adams
Follow /9 Oct 2015 at 1:50pm / SQL Server

Thank You Community

All I can say is, “Wow…Thank you!”.  I won a seat on the PASS Board of Directors and it’s very surreal.  I am beyond excited, but not for what happened.  I’m excited and energized for what is to come.  PASS is young and our...
57 0 /
Sten Vesterli
Follow /9 Oct 2015 at 1:20pm / Oracle

Vote for the Oracle Database Developer Choice Awards

Oracle has started a brand-new appreciation program for database developers called the Oracle Database Developer Choice Award. There are five categories: SQL PL/SQL APEX Oracle REST Data Services Database design Oracle users worldwide...
114 0 /
Mark Broadbent
Follow /9 Oct 2015 at 1:09pm / SQL Server

How I learned to stop worrying and love the b̶o̶m̶b̶ MVP

still not cutting the mustard I would like to say a big thanks to those few people who recently voted for me to receive an MVP award. Being nominated by someone you look up to or your peers is quite frankly awesome, but anyone who knows me will (I hope...
51 0 /
Brad Wulf
Follow /9 Oct 2015 at 12:05am / Toad for Hadoop - Blog

Hadoop is not a panacea, but here's what you need to know to make it a competitive differentiator for your Organization!

Hadoop World New York was last week, this is my 4th such event and the ecosystem is more vibrant than ever. Full disclosure, i spent most of the first Hadoop World I ever attended struggling to understand why anyone would need yet another entire Database...
238 0 /
Kellyn PotVin
Follow /8 Oct 2015 at 11:05pm / Oracle

Indianapolis, ECO, IOUG and Oracle Education Foundation, Ohm My!

I’ve been a bit busy traveling and speaking, but I wanted to discuss the great events I’ve been lucky enough to be part of the last couple weeks. Indianapolis Oracle User Group I spoke at the INOUG back on September 17th.  The user group...
121 0 /
Mark Kurtz
Follow /8 Oct 2015 at 10:15pm / Toad Data Modeler

Using Toad Data Modeler to Convert from Oracle 12c to SQLServer 2012.

I just needed to do a simple conversion from Oracle to SQLServer. I didn't have the need to spend time trying to customize anything but I did come across a couple of 'extra' steps that I thought I would share with you. I opened my Oracle...
144 0 /
Denny Cherry
Follow /8 Oct 2015 at 8:29pm / SQL Server

Your PASS Speaker Idol 2015 Judges

I’m pleased to announce the judges for this PASS Speaker Idol 2015 are: Mark Simms Joey D’Antoni Allen Hurt Andre Kammen Hope Folly These judges will be joined by Karen Lopez at the final session so that we have a judge who...
65 0 /
Jen Stirrup
Follow /8 Oct 2015 at 2:07pm / SQL Server

My handy IoT Toolkit: What businesses forget about IoT

I recently did a brief blog post for Izenda on IoT and business intelligence, and this part of my IoT series expands on some of the themes there. The Internet of Things is a new phenomenon; that said, a simple search for ‘Internet of Things IoT’...
44 0 /