Discuss in the Community


Chris Webb
Follow /5 Oct 2015 at 10:38pm / SQL Server

Drillthrough On Multiselect Now Works In Excel 2016 And SSAS 2016

One unadvertised – but still very welcome – feature of Excel 2016 is that it is now possible to do a drillthrough in a PivotTable when there is a multiselect on a filter or a slicer. It only works if you are using SSAS 2016 on the server, or if you’re...
22 0 /
Kellyn PotVin
Follow /5 Oct 2015 at 8:17pm / Oracle

Adding Music to Code On Your Raspberry Pi

So as I prepare for next week, coaching with some other great folks with the Oracle Education Foundation using the Raspberry Pi, I wanted to add some fun music into my code to work with our motor mascot project.  To do so, you need a few things: ...
22 0 /
Rohit Garg
Follow /5 Oct 2015 at 4:42pm / SQL Server

Implementation of Data Compression – SQL Server

Data Compression Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of Duplicates, Null & Zeroes. It’s a process of reducing size of database & its objects by increasing CPU cycle and reducing I/O effort...
99 0 /
Josh Howard
Follow /5 Oct 2015 at 4:22pm / Toad for Oracle

Toad User Forum: Wie Sie Ihr Datenmanagement einfach optimieren können

Toad User Forum: Wie Sie Ihr Datenmanagement einfach optimieren können Nehmen Sie an dieser interaktiven Trainingsveranstaltung mit dem international bekannten Senior Manager Product Management für Strategie und Roadmap der Toad Produktpalette...
108 0 /
Deiby Gomez
Follow /5 Oct 2015 at 2:43pm / Oracle

VIII Simposio de Ingeniería en Universidad Rafael Landivar

Note: This article was written originally in Spanish. If you are reading this article in other language it is because of the automatic translator of ToadWorld. La semana pasada estuve en la Universidad Rafael Landivar de Quetzaltenango impartiendo...
120 0 /
Jason Brimhall
Follow /5 Oct 2015 at 1:09pm / SQL Server

Backup Deployed Sessions

There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth of information. A good bit of this information happens to be the metadata for Extended Events, and another bit of this information...
100 0 /
Kenneth Fisher
Follow /5 Oct 2015 at 1:00pm / SQL Server

The powerpoint for my SQL Server Security Basics session

Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned along the way a bit later. But in the mean time I promised I would make the PowerPoint for my SQL Server Security Basics session available...
37 0 /
Fernando Garcia
Follow /4 Oct 2015 at 9:03pm / Oracle

Como crear tareas externas con DBMS_SCHEDULER

El planificador de tareas interno de Oracle nos ofrece la posibilidad de crear y ejecutar tareas externas. Como su nombre lo indica, una tarea externa se ejecuta fuera de la base de datos y puede ser local (en el mismo servidor) o remota (en otro servidor...
105 0 /
Porus Homi Havewala
Follow /4 Oct 2015 at 1:35pm / Oracle

APEX mismatch when cloning PDB to the cloud

Enterprise Manager 12c Release 5 can be used to perform wizard-driven cloning of PDBs from an on-premise 12c CDB database to an Oracle Public Cloud (OPC) 12c CDB database. Recently, we have noted that if the APEX versions on the two databases do not...
54 0 /
Jean-Christophe DAUCHY
Follow /2 Oct 2015 at 11:39pm / Oracle

Oracle 12c PDB snapshot copy on regular filesystem

A month ago I was at Paris Oracle meetup with 4 great presentations from 2 cool Swiss guys that I knew from their really good blogs : http://www.meetup.com/parisoracle/events/224181879/ – Ludovico Caldara – Franck Pachot After the first...
74 0 /
Julie Hyman
Follow /2 Oct 2015 at 8:43pm / Toad Intelligence Central

Bulletproof Your Automations, Data Prep, Data Blending and Other Workflows

Pop quiz: Why don’t organizations run their production systems on the C drives of individual computers? Answer: Running important production-level work on a standalone desktop or laptop can be risky — computer failure, network failure,...
70 0 /
Julie Hyman
Follow /2 Oct 2015 at 8:41pm / Toad Data Point

Bulletproof Your Automations, Data Prep, Data Blending and Other Workflows

Pop quiz: Why don’t organizations run their production systems on the C drives of individual computers? Answer: Running important production-level work on a standalone desktop or laptop can be risky — computer failure, network failure,...
90 0 /
Follow /2 Oct 2015 at 2:30pm / SQL Server

019 – 24 HOP Questions Answered - WaterOx Consulting

  24 HOP Questions Answered In WOxPod!, episode # 019 – “24... The post 019 – 24 HOP Questions Answered appeared first on WaterOx Consulting .
96 0 /
Jason Brimhall
Follow /2 Oct 2015 at 1:47pm / SQL Server

SET Operations and Metadata

Having covered the core concepts of deployed session metadata (events, actions, targets, predicates), there is one more topic to cover. This is more of a subset of those concepts in that this applies to more than one of the core concepts, but it isn’t...
78 0 /
Paul Turley
Follow /2 Oct 2015 at 5:57am / SQL Server

Oregon SQL Saturday 2015 Keynote

This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th.  Microsoft is once again moving to a front-line position as a leader in Business Intelligence and Analytics and the Corporate Vice President...
85 0 /
Follow /2 Oct 2015 at 12:12am / SQL Server

SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing

Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple secondaries known as ‘replicas’. The secondary replicas allow direct read-only querying or can enforce connections...
92 0 /
Follow /2 Oct 2015 at 12:07am / SQL Server

SQL Server – Dynamically Generate Scripts for Configuring Read-Only Routing URLs and Lists

Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an availability group listener, to an available readable secondary replica. I find this little script very useful when I want...
90 0 /
Follow /1 Oct 2015 at 11:56pm / SQL Server

SQL Server – Script to generate Read-Only Routing URLs

If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should keep this script to generate URLs to be used in Read-Only Routing configuration. Connect to each replica in your AlwaysOn cluster and...
86 0 /
Michael J. Swart
Follow /1 Oct 2015 at 3:28pm / SQL Server

Code Review This Procedure

Earlier this week we encountered a web-site outage caused by a database procedure. I’m going to blog about that problem (in detail) in a post scheduled for next week. But before I publish that post, I want to know how subtle or obvious the problem...
141 0 /
Craig Mullins
Follow /1 Oct 2015 at 3:00pm / IBM DB2

Understanding DB2 SELECT Syntax

Most DB2 programmers think they know how to correctly code simple SQL SELECT statements. And they usually are correct, as long as you keep that adjective “simple” in the assertion. When the statement requires more than SELECT...FROM…WHERE though, problems...
135 0 /
Ayman El-Ghazali
Follow /1 Oct 2015 at 2:09pm / SQL Server

SQL 2016 Row-Level Security Demo: Users with various clearance levels

SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables.  It’s a great new feature and pretty easy to implement.  I have created a simple demo that gives various users access to data...
150 0 /
Shaun Stuart
Follow /1 Oct 2015 at 2:00pm / SQL Server

Monitoring For Endless Index Defragmenting – October 2015

This is the first of three big script updates this month, so stay tuned! I’ve written before about how my SQL script evolve over time. Well, the script I just published last month has already been updated. I had been deploying the script on all...
154 0 /
Jason Brimhall
Follow /1 Oct 2015 at 1:04pm / SQL Server

Session Target Metadata

With the ability to find the metadata for deployed session, events and actions firmly under the belt, the natural progression would lead one to find the metadata for the target(s) attached to a session. Exploring the metadata for the core components...
132 0 /
Denny Cherry
Follow /30 Sep 2015 at 7:00pm / SQL Server

Upgrading a SQL FCI to Premium Storage in Azure Without Downtime

Recently I was asked by a client to upgrade their SQL Server Failover Cluster from standard storage to Azure premium storage with as little downtime as possible. Due to the fact that the SQL Server instance was clustered already this was actually a pretty...
218 0 /
Follow /30 Sep 2015 at 6:31pm / SQL Server

SQL Server 2016 CTP4

I’ve been waiting impatiently for this release and some of the new improvements and functionality that comes with. Some of the In-Memory capabilities as well as a few new features in SSIS. Go ahead, read the announcement and download it from there...
170 0 /