Database.ca SQL Server, TFS, Oracle, SCRUM & Agile Related Blogs

View & Delete SQL Server tables by their descending dependency order, not to violate foreign keys

All database developers and administrators, as well as QA staff have always needed to be able to wipe out all data in an entire test/dev database.

We have each contrived to accomplish this in our own way... either by deleting th...

Running Oracle stored procedures and viewing the output results in Visual Studio. Part 5 of 5

38) You could easily run Oracle stored procedures in Visual Studio and visualize the values of all the parameters without using a plugin or a third party tool such as Toad.

Since Oracle stored procedures output record s...

INS-32025 The chosen installation conflicts with software already installed in the given Oracle home

I was installing Oracle Client into an old-existing VM. Prior to installing the new 11.2.0.4 drivers, I uninstalled (or de-installed as Oracle calls it) the old drivers in that machine.

The uninstall (de-install!) went successful...

ODP.NET managed Oracle Data Provider for .NET for Oracle 11g or Oracle 12c

A common question I receive is how do I install Oracle Data Provider for .NET, otherwise known as ODP.NET managed .NET drivers for Oracle 11g or 12c?

A) 11g

To get ODP.net installed on your workstation in ...

VS 2012, SQL BI, Part 1

This is part one of a series to come on installing and using SQL Server Data Tools and creating Business Intelligence projects in Visual Studio 2012. ...

Agile DB, Part 2 of 5

*) Lesson 5: Training & Certification is of outmost importance

Ideally your Company should provide Agile Training to every...

Deny View any Database

A question I get every now and then is how to create a SQL Server login who can only view database(s) it has been assigned to, but not the list of all...

Terms of Use
IP, Trademarks, Copyrights and Domain Names Aggressively Protected by DNattorney.com
Copyright ©2013-2014 Database.ca