Discuss in the Community


Ed Elliott
Follow /27 Apr 2015 at 11:10pm / SQL Server

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare & deploy" way. Manual The manual way is where you track what changes you have made and when you want to release, build...
11 0 /
Ed Elliott
Follow /27 Apr 2015 at 10:24pm / SQL Server

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is made...
40 0 /
Follow /27 Apr 2015 at 9:26pm / SQL Server

In-Memory OLTP: Part 4 – Native Compilation

This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery In this final post for the #SQLNewBlogger challenge I want to go over another new feature of In-Memory OLTP, natively compiled stored procedures. Natively compiled stored...
42 0 /
Chris Yates
Follow /27 Apr 2015 at 5:26pm / SQL Server


It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught...
58 0 /
Natik Ameen
Follow /27 Apr 2015 at 4:43pm / Oracle

Solving RMAN-06059: Errror identifying file

During Oracle backup using RMAN an error "RMAN-06059: Errror identifying file " is returned when trying to backup the archive logfiles. The backups have been running successfully prior to this.
61 0 /
Michael J. Swart
Follow /27 Apr 2015 at 4:32pm / SQL Server

The Appeal Of Lightning Talks

Lightning talks are quick presentations, usually five-ten minutes long, and I really enjoy them. But it’s not (only) about indulging short-attention-span habits. Lightning talks tend to be really dense with interesting information. The speaker...
52 0 /
Jason Strate
Follow /27 Apr 2015 at 4:00pm / SQL Server

Monday Morning SQL Break – April 27, 2015

It’s been a while since I’ve posted a blog post.  After the new year, I had been trying to decide on a better way to share the Monday and Friday blog posts that I’ve done for the last couple of years.  Of course, analysis paralysis and...
76 0 /
Kenneth Fisher
Follow /27 Apr 2015 at 1:00pm / SQL Server

What SQL version is my SSIS package?

When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how everyone thought DTS was much better and did they really have to switch? Over the years I’ve come to appreciate SSIS. It is a very powerful and...
64 0 /
Rohit Garg
Follow /27 Apr 2015 at 6:20am / SQL Server

Cumulative Update – 5 for SQL Server 2012 Service Pack 2 Is Now Available !

The 5th cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are...
67 0 /
Rohit Garg
Follow /27 Apr 2015 at 6:18am / SQL Server

Cumulative Update – 15 for SQL Server 2012 Service Pack 1 Is Now Available !

The 15th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 15 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
66 0 /
Rohit Garg
Follow /27 Apr 2015 at 6:15am / SQL Server

Cumulative Update – 7 for SQL Server 2014 RTM Is Now Available !

The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe...
70 0 /
Follow /26 Apr 2015 at 7:36pm / Oracle

Error “Cannot Load Program” for binaries after 12c Installation

After Installation of Oracle Software on IBM-AIX 6.1, I tried to configure the listener and “lsnrctl” command failed with following error. Then tried other commands like sqlplus, tnsping and all executable’s was reporting the...
81 0 /
Fernando Garcia
Follow /26 Apr 2015 at 5:18pm / Oracle

Oracle XE, la base de datos gratuita de Oracle

¿Sabías que existe una base de datos Oracle que puedes utilizar de manera totalmente gratuita y legal? Oracle Express Edition es la base de datos que Oracle pone a disposición de manera gratuita para desarrolladores, administradores...
72 0 /
Follow /26 Apr 2015 at 12:44pm / Oracle

connection to database cannot be established - DBCA

Environment :- Oracle Grid Infrastructure Nodes # : 4 Operating system : Redhat 6.6 When trying to configure enterprise manager the following error appeared :- Connection to the database cannot be established because the listener could be down...
82 0 /
Follow /25 Apr 2015 at 10:31pm / Oracle

The Dark Side of the IoT

The Internet of Things (IoT) promises us a bright future. But what are the benefits of this technology, and what are the risks? In this article we continue our exploration of the IoT and how it applies to our daily lives in today's enterprises.
115 1 /
Mike Smithers
Follow /25 Apr 2015 at 6:32pm / Oracle

Getting a File Listing from a Directory in PL/SQL

It’s General Election time here in the UK. Rather than the traditional two-way fight to form a government, this time around we seem to have a reasonably broad range of choice. In addition to red and blue, we also have purple and – depending...
87 1 /
Ed Elliott
Follow /25 Apr 2015 at 11:26am / SQL Server

Sql Saturday Talk

I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides and say thanks to the organisers, sponsors and everyone who came along to my session - I really enjoyed it and I hope you did to. The slides...
97 0 /
Chris Webb
Follow /24 Apr 2015 at 10:02am / SQL Server

Analysing SSAS Extended Event Data With Power Query: Part 2, Storage Engine Activity

In part 1 of this series I showed how to use Power Query to extract Extended Event data generated by SSAS. Having done that, I now want to show the first (I hope of many) examples of how this data can be used for performance tuning: analysing activity...
95 0 /
Rohit Garg
Follow /24 Apr 2015 at 5:49am / SQL Server

Window Server 2008 Failover Clustering Logs

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%\Cluster folder on each node in the cluster and the name of the file is CLUSTER...
96 0 /
Porus Homi Havewala
Follow /24 Apr 2015 at 5:32am / Oracle

Oracle 12c CDB Installation now allowed with less options

A very interesting recent development in the Oracle Database 12c world, is that you are now allowed to create a CDB installation with less options . Database options such as RAC, Java, Spatial etc. are included and may not be installed. This will...
99 0 /
Follow /23 Apr 2015 at 10:49pm / Oracle

OTN EMEA Tour 2015

For second time i will be glad to Join OTN EMEA Tour 2015 with others oracle experts who consume much time in the Oracle Community. We will cover the following country :- Portugal. Jordan - Amman Johannesburg date location May 21st 2015 Lisbon, Portugal...
73 0 /
Josh Howard
Follow /23 Apr 2015 at 6:36pm / Toad for Oracle

We need your help - Vote for Toad!

We want your vote! Go to http://www.dbta.com/ReadersChoice/2015/Vote.aspx and vote for Dell Toad in the following categories: - Best DBA tool - Dell Toad DBA Suite - Best Database Development tool - Dell Toad Development Suite - Best Query and...
270 0 /
Derik Hammer
Follow /23 Apr 2015 at 2:38pm / SQL Server

PowerShell Start-Job

The Start-Job Cmdlet is a fast and extremely simple means of spawning asynchronous threads. Why do we care? Because performing parallel work is faster and our time is important. If I want to inventory the Windows services running on every server in my...
154 0 /
Richard To
Follow /23 Apr 2015 at 3:51am / SQL Optimizer for Oracle

Bind Sensitive SQL May Also be Place Sensitive

I have heard a lot of people ask "Why my SQL performance is vary depending on where the SQL is executed ?", sometimes you may notice that the same SQL is performing good in one place, but not good in another place. If your SQL has bind variables...
151 0 /
Steven Feuerstein
Follow /22 Apr 2015 at 4:58pm / Oracle

PL/SQL Brain Teaser: How can BULK COLLECT be used?

No sonnets, no songs, just a simple question that has mostly obvious answers, but maybe not completely: What are the different ways (essentially different kinds of statements) that BULK COLLECT can appear in PL/SQL code?
183 0 /