Injection Recovery, Accidental DBA Tip: Auto-Grow/Shrink, etc.

New SQL Server Video Show Posted
SelectViews – Injection Recovery, Accidental DBA Tip: Auto-Grow/Shrink, Upcoming Events, Good Enough Follow-Up. Also, 60-Second Tip on Tape Rotations, Permissions Tips, New SQL Server 2008 List Server and A Lot More.

[Watch Now]

Featured Article(s)
Take advantage of Connection Pooling in ADO.NET
In any data centric application, you require to connect to databases often and perform CRUD (Create, Read, Update and Delete) operations. Connecting to a database is a resource intensive and slow operation. This article takes a look at how connection pooling comes in handy for improved performance, efficiency and scalability of your applications.

Initial SharePoint Feedback Tips
I wrote a day ago asking for your feedback, tips and "things you wish you’d known" about SharePoint. I thought I’d share a couple of the early results here today (be sure to send in your thoughts here). To-date, the most common response to this request is "YES!!! Please share these feedback items. We’re getting ready to deploy SharePoint and we need to know what to consider and think about…" – or something very close to that. So, if you have tips, please send ’em in and we’ll share them here.

Doug: "Our biggest lesson learned is that all the great analytic dashboards we created with Excel 2007 (nice 3D rendering) and SQL Server 2005 OLAP, look terrible when rendered with Excel Services for SharePoint (flat, drab colors, etc…). Apparently (if you dig hard enough) you’ll find that it’s a "known issue". I wish I had known about the issue before we pitched all of the Excel 2007 "mock ups" to our CIO and then showed him the resulting web pages a month after he green-lighted the project. Also, there are so many restrictions on what Excel Services for SharePoint will publish from Excel 2007. You have to un-group objects, un-highlight things, etc, etc…"

Hinson: "Before installing, make sure you have SQL Server installed properly or it will install on MSDE Express!"

I’ve heard from a number of people looking for planning guidelines and documents, and several others have asked about what things, if anything, need to be added to a more traditional SQL Server administration process with SharePoint installed. What do you need to be considering to make sure your system is recoverable… More to come on this as we hear back from different people using the system.

Upcoming Webcast – Register Today
SQL Server 2005 Tuning Tools and Approaches
We’ll look into the tools and techniques you have available to you in SQL Server 2005 for investigating performance issues, understanding what your server is doing and how you can use this information to tune your system. From Performance Monitor to watching queries that are executing we’ll show you some of the tools at your disposal for diagnosing server issues of performance and possible tuning targets.

> Register Now
> Live date: 6/11/2008, 12:00pm Noon Pacific

Job Postings