Discuss in the Community - Toad World

Discuss in the Community


Follow /10 Feb 2016 at 5:00pm / IBM DB2

3 DB2 Critical Design Factors for Big Data Analytics Scalability

Faster, bigger, and better analytical insights. These are the goals that management lays out as the new big data analytics process is talked about during the startup meetings. Looking around the room and listening to the CIO’s comments it becomes abundantly...
18 0 /
Chris Yates
Follow /10 Feb 2016 at 2:30pm / SQL Server

Leadership and the Data Professional

Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in this blog post are ones that have helped me on my journey not just in a leadership role, but from a data professional perspective as...
187 0 /
Kenneth Fisher
Follow /10 Feb 2016 at 2:00pm / SQL Server

Changing to simple recovery to clear the log.

Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries and blog posts. Because of that I’m not going to talk about the correct methods of dealing with a transaction log full error. What I want...
41 0 /
Craig Mullins
Follow /10 Feb 2016 at 12:00pm / IBM DB2

The Most Misunderstood Features of DB2 – Part 3: Nulls

Welcome to Part 3 in my on-going blog series on The Most Misunderstood Features of DB2. You can find the first two parts here: Part 1 (on locking) and Part 2 (OPTIMIZE FOR v. FETCH FIRST). Today’s topic is one that confuses many SQL developers, Nulls...
30 0 /
Thomas LaRock
Follow /9 Feb 2016 at 6:20pm / SQL Server

Migrating Data From a TDE Enabled SQL Server Database Without a Key

But our database has TDE enabled, shouldn’t our data at rest in the BACPAC be protected? Nope. The post Migrating Data From a TDE Enabled SQL Server Database Without a Key appeared first on Thomas LaRock . If you liked this post then consider subscribing...
68 0 /
Fernando Garcia
Follow /9 Feb 2016 at 5:26pm / Oracle

El Datawarehouse, el OLTP, y las técnicas de modelado.

Un entorno de Datawarehousing habilita la posibilidad de obtener información de negocio valiosa a partir de datos alojados en bases de datos transaccionales. Pero la transformación de un dato transaccional puro en información de negocio...
85 0 /
Jen Stirrup
Follow /9 Feb 2016 at 4:07pm / SQL Server

Azure Architect Workshop in India – I’m presenting!

I’m over the moon to announce that, courtesy of Tech Mahindra and Microsoft, I’ll be participating and teaching in the three-day Azure Architect course in India this February – twice! It’s not just me – there is a whole team from Tech Mahindra and...
60 0 /
Marlon Ribunal
Follow /9 Feb 2016 at 2:29pm / SQL Server

How Much Hospitals Charge For The Same Type Of Cases?

How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world (limited data)? The data used in this analysis may be old but it does give us a hint of how much more or less hospitals are...
64 0 /
Gethyn Ellis
Follow /9 Feb 2016 at 1:00pm / SQL Server

Spring Training: Developing SQL Queries for SQL Server

Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries for SQL Server course in Learning Tree’s London Education Centre. It’s a four day course starting on Tuesday 19th April and will complete on Friday...
58 0 /
Follow /9 Feb 2016 at 12:00pm / IBM DB2

Transferring a DB2 LUW Fixpack Directly to a UNIX, Linux, or Windows Server

This seems to change every few years, so I thought I’d document what’s working for me today. The Problem It used to be so easy to get DB2 fixpacks from IBM at the command line. It has gotten steadily more difficult over the years. At one...
27 0 /
Kellyn PotVin
Follow /8 Feb 2016 at 8:42pm / Oracle

EM13c Upgrade Tips- Part II

There is a flurry of excitement about Enterprise Manager 13c and I’m blown away by how many customers are looking not just to install and test out the new release, but have plans already underway to upgrade to it.  At Oracle, we’re covering...
68 0 /
Chris Webb
Follow /8 Feb 2016 at 8:28pm / SQL Server

Disabling Excel PivotTable Grouping And Session Cubes In SSAS Multidimensional

The Excel PivotTable grouping functionality that is available when you are connected to an SSAS Multidimensional cube (but not a Tabular model ) is a Very Bad Thing indeed. In my experience it is a major cause of query performance problems – not just...
73 0 /
Denny Cherry
Follow /8 Feb 2016 at 7:40pm / SQL Server

Would you like Microsoft to pay for you to move to Azure?

Have you been wanting to move some of your services up to Azure , but you don’t have the budget to move them up to th e cloud? Microsoft has an excellent deal for you. Microsoft will pay for (at least part) of the consulting time needed to get you...
67 0 /
Dan Hotka
Follow /8 Feb 2016 at 3:32pm / Oracle

Write your own hints

Ever have a need to do something with the library cache where it would be just plain convenient if the SQL always hard parsed? I’ve discussed the issues with bind variables. In recent articles and blogs, I’ve discussed Oracle’s work...
122 0 /
Dan Hotka
Follow /8 Feb 2016 at 3:29pm / Oracle

User Groups in your Area

Hi! Do you regularly attend user groups? Do you know if one is in your area? Do a little research… Many user groups, such as the Dallas OUG…meet once a month in the evenings. Many user groups such as the Twin Cities and the Heartland...
126 0 /
Gethyn Ellis
Follow /8 Feb 2016 at 3:00pm / SQL Server

Introduction to SQL Server: The Main Components

There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a new person just starting a career as a data professional using Microsoft's SQL Server data platform could use to learn all about...
143 0 /
Kenneth Fisher
Follow /8 Feb 2016 at 2:00pm / SQL Server

Impersonation can give you the wrong answer

I use impersonation all the time to let me see additional permissions information I can only get that way and, sometimes to help me see what permissions error someone is getting. For those of you who aren’t aware, with the right permissions you...
72 0 /
Jorge Segarra
Follow /8 Feb 2016 at 1:30pm / SQL Server

T-SQL Tuesday #75 Invitation: Jump into Power BI!

Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI ! If you’re reading this and thinking “crap, I’m not a BI person!”, don’t you fret. My intention is to make folks...
135 0 /
Steve Hood
Follow /8 Feb 2016 at 12:00pm / SQL Server

Database Log VLFs

Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files work in the background.  These are created automatically, but automatically doesn’t always mean perfect.  Here’s a practical...
77 0 /
Nakul Vachhrajani
Follow /8 Feb 2016 at 3:30am / SQL Server

#0373 – SQL Server – Interview Questions – Parameters required for server-side paging mechanisms

For a mid-level SQL developer profile, this is one of my favourite interview questions if their current projects involve some sort of paging mechanism while displaying results on a grid. What is the minimum number of parameters that your stored procedure...
128 0 /
Denny Cherry
Follow /8 Feb 2016 at 1:33am / SQL Server

Come See Joey or Denny in India at the Tech Mahindra Azure Architect Workshops!

Do you want to learn more about Azure, and live in India (or want to travel to India)? Have I got a deal for you. Microsoft is putting on some free workshops next week and the week after in a few cities in India and Joey and I will be presenting at some...
48 0 /
Follow /6 Feb 2016 at 10:16pm / SQL Server

SQL Server Database File Size and Free Space Revisited

I recently had a comment posted to one of my first articles I wrote way back in 2012 concerning adding a column that detailed the used space as a %age. So without any further ado, here is an updated version of a script originally blogged about here ....
85 0 /
Abu Fazal Abbas
Follow /6 Feb 2016 at 5:23pm / Oracle

Oracle 12c ( Now we can preserve the PDB state between instance startup

As we know, Oracle has introduced the multitanent architecture with Oracle version 12c, where we can have multiple pluggable databases (PDB) within a single container database (CDB). However, when we start up a container database (CDB), all of the associated...
161 1 /
Porus Homi Havewala
Follow /6 Feb 2016 at 2:44pm / Oracle

Tips for the Enterprise Manager Software Library – Part I

The Software Library is a very important and critical “core” part of Oracle Enterprise Manager . It is a file system repository associated with the Enterprise Manager system, and the prime purpose of this library is to store various software...
153 0 /
Clarisa Maman Orfali
Follow /6 Feb 2016 at 2:46am / Oracle

Access Control List (ACL) y JasperReports Integration Kit

Hola amigos, el otro día un amigo me comentó que tenía problemas al trabajar con el JasperReports Integration kit cuando cambiaba de Workspace. Básicamente cuando trabajaba con una aplicación en el workspace1 funcionaba...
84 0 /