DatabaseJournal.com Staff

[From Search SQL Server] Where did the good old days of security go? I remember learning about the basic information security principles of least privilege, delegated administration and separation of duties way back when security wasn’t cool. They were the cornerstones of effective IT administration and secure systems. Fast forward to today and it’s rare […]

[From Search Oracle] Data modeling tools have advanced considerably since the concept of data modeling began to take hold in the early 1970s, but many of today’s data modeling professionals say that projects still require good old-fashioned craftsmanship. While data modeling tools and resources — which range from automated modeling software to prefabricated data models […]

Nine new webcasts are scheduled for January, covering such topics as “Unlock the Business Intelligence Capabilities of SQL Server”, “SQL Server 2008 Programming for Application Developers” and more. Momentum Webcast: Unlock the Business Intelligence Capabilities of SQL Server (Level 100) Wednesday, January 09, 2008 11:00 AM Pacific Time Join our webcast to learn more about […]

[From AdventNet] SwisSQL DBChangeManager helps to Compare and Synchronize Microsoft SQL Server databases. The new version of the tool (4.2) has the following features : 1.Open and Execute Sync script using SQL Server Management Studio/Query Analyzer. 2. Execute multiple comparison/synchronization from a single command line execution and much more. The Free edition of the tool […]

Oracle Splitting a Comma separated line. Author: dharanidhar karimojji select level, trim(‘”‘ from rtrim(regexp_substr(&str|| ‘,’,’”.*?”,|[^,]*,’,1,level),’,’)) sub_str from t connect by level

[From MSSQLTips.com] Many of our SQL Server releases include data changes, not just code changes. In some respects the SQL Server data changes are more of an issue to manage than the code changes, because we can easily isolate the code changes and roll them back as needed. With the data changes if we add […]

[From SQL Server Magazine] In my August 2007 editorial “Too Soon for SQL Server 2008?” (InstantDoc ID 96028), I claimed that many businesses running SQL Server as their database platform wouldn’t be ready to migrate to SQL Server 2008. I still think that Microsoft’s SQL Server release schedule isn’t giving its customers time to catch […]

[From Webyog Softworks Pvt Ltd.] MONyog 1.5 helps you eliminate security holes and verify your MySQL security model. MONyog does this by performing rights analysis across your MySQL servers. In addition to rights analysis, MONyog provides custom recommendations to improve server security. Version 1.5 also improves the reporting response time by 10x. Existing MONyog customers […]

[From Builder AU] Last time, I showed how to send an HTML-formatted e-mail from an Oracle PL/SQL application using utl_smtp. I promised I would extend the package a little with a second method that allows you to send Binary Large OBject (blob) attachments in the e-mails. The most common application where I work is sending […]

[From Idera] HOUSTON, TX – December 11, 2007 – Idera today released SQL job manager v1.1, an easy-to-use tool for streamlining the scheduling and management of database jobs across multiple instances of SQL Server. As a holiday gift to the SQL Server database administrator and developer community, Idera will provide SQL job manager free of […]

MSSQL This function will take a format string that has YYYY MM and DD in the string and replace it with the appropriate date element. Examples — Select dbo.FmtDate (‘YYYYMMDD’,getdate()) — Returns 20071214 — Select dbo.FmtDate (‘YYYY-MM-DD’,getdate()) — Returns 2007-12-14 — Select dbo.FmtDate (‘MM/DD/YYYY’,’10/3/2007′) — Returns 10/03/2007 — Select dbo.FmtDate (‘YYYYMM’,getdate()) — Returns 200712 — […]

[From ITTIA] December 12, 2007 — Bellevue, WA — Advances in hardware technology have provided embedded systems and mobile devices with an ever increasing capacity for information and media. To effectively manage and share this data, software developers will need to employ new techniques to keep up with growing complexity. Recognizing this trend, ITTIA has […]