Featured Article(s) Increasing Performance Using the Oracle 11g PL/SQL Function Result Cache Oracle 11g has a new performance enhancing feature called the PL/SQL Function Result Cache. This feature retains the results of a PL/SQL function call in memory enhancing performance by not continually re-executing the function. This article describes the new PL/SQL Function Result Cache Not Sure What You Need […]

New SQL Server Show Posted The weekly SQL Server show has been posted – we look at injection protection and recovery today, along with server protections, data warehousing for the rest of us, events, tips, trick, news and more. [Watch the show here] Featured Article(s) Oracle 2-Day DBA in x Days Post 4; Getting Enterprise Manager (dbconsole) to work It […]

[Watch] SelectViews – the latest episode of the weekly SQL Server show like no other. Survey, and Your Chance to Win, Closes Tomorrow The survey will close tomorrow (Friday, 4/4/2008) at midnight. So, if you’re interested in providing feedback, helping shape the direction of SSWUG, and, let’s face it, WINNING one of the great prizes, now is the time to […]

Don’t Forget the Survey! Give us your feedback here. (Survey is only open to Friday – lots of prizes will be awarded!) Featured Article(s) What is a search engine? Can I build one easily? Yes indeed… If you look at what a search engine does, the solution to how to create a search engine is there. A search engine is […]

> Registration is now open for the June Virtual SQL Server Conference See What’s Going On With Your SQL Server Stop guessing. Use tools that provide you with the information you need, in a way you can quickly grasp what’s happening, to see what’s happening with your SQL Servers. With 3D visualization, a 100% web-enabled interface and full cockpit and […]

Featured Article(s) Loading image files from a directory using SQL 2005 The following procedure uses the new BULK in OPENROWSET set function in order to load all image files from a given directory location to a table inside SQL Server , If the table does not exist, the procedure creates it. The table structure is an identity column, the file […]

New SelectViews SQL Server Show Available Learn about SQL Injection, Information and Thoughts About the TJX Data Breach Lawsuit. Noise and News in the Industry, the 60-second SQL Server Tip of the Day, Upcoming Events and a LOT More. > Watch Here Also, be sure to catch the SQL on Call show: [Watch] Finding good technical managers… tips, tricks, lessons […]

New Show Posted – Watch Here SQLonCall: Manager or Leader? Where do you find good managers, how do you help them get started, etc. We take a look at the pros and cons of technical vs non-technical managers and a lot more. > Watch The Show Here SQL Connections: Orlando, FL Looking for the best in-person conference for learning about […]

Featured Article(s) Tips for using indexes in SQL Server 2005 (Part 3) Here are some helpful tips to performance tune and optimize SQL Server 2005 indexes. SQL Server Show – Watch Here SelectViews: SharePoint Feedback Results, Discussion Watch, Information Overload and Gaming – What It Could Mean For DBAs. Also – Newsletter Feedback, Upcoming SQL Server Events, Baselines and SQL […]

(Shhh…. the SQL Server Virtual Conference for June has soft-launched…) Webcast Today Data Protection and Recovery Options with SQL Server We’ll look into the various data protection options you have with SQL Server when it comes to setting up a recovery system for your server. We’ll explain the pros and cons of each and where you can apply them in […]