Showing entries 1 to 9
Displaying posts with tag: SSIS (reset)
SSIS Data Types: The No-Sweat Guide with Easy Examples

Consider this simple Integration Services package. It’s simple because the task is to upload a CSV file to SQL Server. No transformations. Notice the warning in the OLE DB Destination. It’s a string truncation warning. The source column has 50 characters but the target has only 20. So, what? The package may run without errors. […]

The post SSIS Data Types: The No-Sweat Guide with Easy Examples appeared first on Devart Blog.

Log Buffer #444: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers some blog posts of Oracle, SQL Server and MySQL from this past week.


Oracle:

  • Oracle Utilities Application Framework V4.3.0.1.0 includes a new help engine and changes to the organization of help.
  • Very simple oracle package for HTTPS and HTTP.
  • Tim spotted a problem with the PDB Logging Clause.
  • How to Pass Arguments to OS Shell Script from Oracle Database.

SQL Server:

  • How efficient is your covered …
[Read more]
Log Buffer #435: A Carnival of the Vanities for DBAs

Sun of database technologies is shining through the cloud technology. Oracle, SQL Server, MySQL and various other databases are bringing forth some nifty offerings and this Log Buffer Edition covers some of them.

Oracle:

  • How to create your own Oracle database merge patch.
  • Finally the work of a database designer will be recognized! Oracle has announced the Oracle Database Developer Choice Awards.
  • Oracle Documents Cloud Service R4: Why You Should Seriously Consider It for Your Enterprise.
  • Mixing Servers in a Server …
[Read more]
Log Buffer #428: A Carnival of the Vanities for DBAs

The Log Buffer Edition once again is sparkling with some gems, hand-picked from Oracle, SQL Server and MySQL.

Oracle:

  • Oracle GoldenGate 12.1.2.1.1  is now certified with Unity 14.10.  With this certification, customers can use Oracle GoldenGate to deliver data to Teradata Unity which can then automate the distribution of data to multiple Teradata databases.
  • How do I change DNS servers on Exadata storage servers.
  • Flushing Shared Pool Does Not Slow Its Growth.
[Read more]
Log Buffer #299, A Carnival of the Vanities for DBAs

Screenings, shows, premieres and parties. Where the stars have been spotted this week? No not on the red carpet in LA, but in this Log Buffer Edition. In Log Buffer #299, stars of Oracle, SQL Server and MySQL are twinkling. Get mesmerized!!! Oracle: Pythian’s very own Marc Fielding is revealing the hints behind the Automatic...

Log Buffer #289, A Carnival of the Vanities for DBAs

Oracle Open World 2012, this year, was all about Cloud, 12c, Exadata, Fusion, SuperClusters, social media, content management and much more. From operating systems to databases, and from applications to interactive media, professionals all around the world presented, attended, and networked in San Francisco. MySQL’S professionals also rocked massively. SQL Server bloggers also remained actively [...]

Log Buffer #284, A Carnival of the Vanities for DBAs

This Log Buffer Edition is encompassing various blogs across Oracle, SQL Server and MySQL arena. Enjoy the Log Buffer #284. Oracle: Dimitrios Stasinopoulos was trying to install new Guest Additions to VirtualBox4.1.14 to 4.1.18 and all of a sudden…. Denes Kubicek has a good blog post about APEX 4.2. Jonathan Lewis blogs about the bugs [...]

Log Buffer #280, A Carnival of the Vanities for DBAs

This Log Buffer Edition is sparkling with fresh and budding blogs. This Log Buffer #280 is is encompassing Oracle, SQL Server and MySQL blogs. Please give your feedback in the comments. Enjoy Oracle: Kent Graziano shares the best practice about how to create the best data model ever. To compress or not to compress, Apun [...]

The Conflicted Data Analyst

Inspired by a post from Juice Analytics.

We are a conflicted people. We love our TV and movie violence but worry that it ruins our children’s minds. We want to reduce healthcare costs, but don’t want to restrict the free market.

Conflicts like these leave little room for a satisfactory answer. Basic principles are in conflict and deeply-rooted desires run up against painful consequences. We

Showing entries 1 to 9