Featured Article(s) Oracle 2-Day DBA in x Days Post 15; Temporary Tablespaces Chapter 6 brushes over temporary tablespaces so let’s just take a deeper look. Great Microsoft Virtualization Whitepaper (Direct Link) EMC is working very closely with Microsoft on many fronts. One is the whole area of virtualization – and their support for this, and SQL Server and much more […]

Featured Article(s) Information Economics for IT Managers Information is a valuable resource in any organization. However, the preparation of formal information is not free; it costs money. How much should an organization spend for information? Some type of a cost-benefit analysis ought to be undertaken. It is more easily said, than done. Difficulties occur in measuring the cost of providing […]

Featured Article(s) Objects in XML This tutorial will introduce you to xml objects, specifically xmldom object. We shall create an xml object, create hierarchical trees to represent HTML files, use the functions associated with these objects and explore that ways and means of reading data in an xml file. Weirdness with our SQL Server…. We’re currently working through a really […]

Have You Registered Yet? Our vConferences, coming Nov 5, 6 and 7: SQL Server vConference, Business Intelligence, SharePoint and .NET Developers. 120 sessions, 40 speakers. Great online networking opportunities, amazing learning, examples and how-to information. [More Information Here] Ever Have One of THOSE Moments? Today I did. We were doing some camera work (interviews) and talking about SharePoint, installs, support, […]

Featured Article(s) Troubleshooting problems with connection to SQL Server 2005 (Part 2) In this article, you can find the description of SQL Server 2005 connection bugs and the information on how to resolve or work around these problems. SQL Server Outreach (Sounds like a new 12-step program…) My real question and thought on this is that, collectively, as DBAs and […]

Featured Article(s) Oracle 2-Day DBA in x Days Post 14; Creating a Tablespace We have taken a look at the physical storage structures for Oracle, now let’s dive into tablespaces and how to create some. Getting In Touch with Developers We’ve been debating. It all started with SQL Injection – and getting the word to people that there is an […]

Featured Article(s) Things Your Mother Never Mentioned About Setting Up an Oracle Database – Steps 3 to 5 This is the second article in the series that discuss tasks you should do to set up an Oracle database following its initial creation. This article discusses steps 3 to 5: Setting up a password file for SYS, an OPS$ account for […]

Featured Article(s) Displaying XML data in HTML files In this second tutorial of the series we shall see how we can display xml data in a html file. Rushed? Work Less. Deliver More. Give business users the ability to view, update and interact with reports – anywhere. You’ll not only have happier end users, but you’ll be happier too. Fewer […]

24 Tools in One? Everyone needs a hand from time to time working with SQL Server. There are a lot of things to keep track of, and when things happen that you need to investigate, you need tools that will help you dig down into the system and see what’s up. This is where the Idera SQL Server Toolbelt comes […]