SharePoint With SQL Server Reinforces Key SQL Server Best Practices
Kalen Delaney, Straight to Your Computer
This week's virtual workshop is going to be very cool - Kalen Delaney will be teaching about Indexes - and it's going to be amazing! Kalen is well known for her in-depth approach to teaching workshops, classes, pre-conference sessions and so much more. We're really jazzed about bringing you more than *4 hours* of detailed information about things you need to know about Indexes and SQL Server. Learn about key aspects of indexes and, perhaps more importantly, how to apply that knowledge to get the best possible performance from your systems. Take a look here at the virtual workshop site - but don't delay - the workshop is Friday, so be sure to register today.
We'll even be giving away a copy of her book to one lucky workshop attendee!
>> [Visit the workshop site]
>> [Register for the virtual workshop]
Featured Script
Analyzing SQL Agent Job and Job Step History in SQL Server
--Analyzing SQL Agent Job and Job Step History in SQL Server -- Written By: Atif Shehzad ... (read more)
SharePoint With SQL Server Reinforces Key SQL Server Best Practices
It's interesting reading through different blogs, articles and whitepapers about SharePoint and what types of things you need to do to optimize the SharePoint environment.
What I find interesting is that it seems like so many of the suggestions for best performance are those that SQL Server administration folks will find very familiar. I'm not sure where the disconnect is between the lessons learned with SQL Server and applying them to SharePoint, but if you're administering a SharePoint system, know that the information on SSWUG about SQL Server administration, best practices and disaster recovery, planning and such -- all of it is very applicable to your SharePoint installation.
Of particular interest is that I'm seeing a lot of information about file size in your database (keep content databases under 100G) and spindles. Ah spindles. Yes, with SharePoint (and other SQL Server applications as well), it's best to pay attention to spindles on your storage subsystem. If you're not familiar with how this works, a quick primer is in order. When you lay out your disk and storage locations, make sure you are splitting databases, transaction logs and the OS across spindles (not logical drives) because spindles are where the performance will be most impacted.
By splitting apart the databases and other storage assets and placing them on different spindles, you'll be optimizing the access to that information. Let the hardware spread the load as much as possible/feasible and SQL Server won't be waiting as much on disk access, making for better performance.
Webcasts Tomorrow - Register Now
There are two great webcasts tomorrow - both focusing on backup tuning and optimization - think of it as "disaster recovery day" - and enjoy!
Optimizing Backup and Restore Performance
As databases continue to grow in size, the time it takes for backup and recovery grows in length of time. Attend this session and learn methods to minimize the time it takes for your backups to complete, as well as how to minimize the amount of time it takes to recover.
Presented by: Thomas LaRock
> Register Now
> Live date: 2/10/2010 at 12:00 Pacific
Top 10 Backup Mistakes and How to Avoid Them
You already know that backing up your SQL Server databases is essential to minimize data loss in the event of a failure. However, putting the wrong strategy in place could be just as harmful as having no plan in place at all. Tune in for Idera's February "Secrets of SQL Server" webcast and discover how to avoid common mistakes when creating and implementing a backup solution.
> Register Now
> Live date: 2/10/2010
See you online!
Stephen Wynkoop,
Founder
Microsoft SQL Server MVP
swynk@sswug.org
Facebook Twitter @swynk
|
|
 | Click Here For Free SSWUG Premium Content
BakBone is providing FREE access to some of SSWUG’s best content relating to data backup, recovery and availability. Download or view the script, article or short video. |
Featured Products For Your Review
The following products are in the Product Directory, and may help in your use of your database engine. Take a look when you get
a minute.
|
Idera-SQL toolbox
|
|
SQL toolbox is an advanced collection of must-have tools for SQL Server DBAs and Developers. With tools for SQL Server database backup, virtual data recovery, data and object comparison, and more than 20 administrative tasks, SQL toolbox provides the tools DBAs and Developers need to save hours of time performing day-to-day tasks. PLUS, the SQL toolbox is a great value at over $600 off the price of purchasing the tools individually.
|
|
SQL MetaTool
|
|
SQLMetaTool is a new multi-function utility tool for that extracts and consolidates SQL Server database metadata. It includes a source code repository, database object history, search functions, a data dictionary, a 'suspect' column analyzer, graphs of index fragmentation, table sizes and database size over time and a dependency viewer. Supports SQL2000, SQL2005 and SQL2008.
|
| |
Find out about these and other products in the Product Directory.
|
Today's Articles
Note: 'Guest' articles below will be available for seven days to registered guests.
SQL Server Topics
Developer Topics
Oracle Topics
XML Topics
DB2 Topics
SSWUG.ORG Sponsors, Special Offers
| |
Thank you to our sponsors!
Special Member Offers
See the special member offers page for more information
Pay them a visit and let them know you heard about them on SSWUG.ORG!
|
Summaries
| Time Tracking for SQL Server Operations
| | (Buck Woody) When you manage a SQL Server Instance, you’re concerned with performance, maintenance and capacity. You want to ... [more]
[Click Here to Read More...] [TOP] |
Installing and configuring SQL Server 2008 and 2008 R2 Integration Services
| | (Marcin Policht) We have introduced the basic concepts of SQL Server 2008 and 2008 R2 (based on the November 2009 Community T... [more]
[Click Here to Read More...] [TOP] |
Caching Options in SSRS
| | One can enable caching for their reports in SSRS. When we do that, the data is then retrieved from the ReportServerTempDB in... [more]
[Click Here to Read More...] [TOP] |
Geek City: More About Row Overflow Columns
| | (Kalen Delaney) In my earlier post about the maximum number of row-overflow columns, I just got a comment from someone wantin... [more]
[Click Here to Read More...] [TOP] |
Built-in Charting Controls (VS 2010 and .NET 4 Series)
| | (Scott Guthrie) This is the fifteenth in a series of blog posts I’m doing on the upcoming VS 2010 and .NET 4 release. Today’... [more]
[Click Here to Read More...] [TOP] |
Performing Validation in an ASP.NET MVC Application
| | (AzamSharp) Validation is one of the most important aspects of an application. ASP.NET MVC framework provides multiple ways t... [more]
[Click Here to Read More...] [TOP] |
.NET 4.0 and System.Collections.Concurrent.ConcurrentQueue
| | (Justin Etheredge) In .NET 4.0 we have several new collection types that have been introduced inside of the System.Collection... [more]
[Click Here to Read More...] [TOP] |
Creating Nested Folders
| | (Karl E. Peterson) And now for something completely different. This column most frequently dwells on leveraging the Windows A... [more]
[Click Here to Read More...] [TOP] |
Bind Variable Peeking – execution plan inefficiency
| | (Tanel Poder) In my Beyond Oracle Wait interface article I troubleshooted a test case where an execution plan somehow went “c... [more]
[Click Here to Read More...] [TOP] |
TNS-12533: TNS:illegal ADDRESS parameters
| | (chet justice) I kept receiving this error recently but until today, never bothered to investigate it. To get around it, I wo... [more]
[Click Here to Read More...] [TOP] |
Execution Plans – What is the Plan, and Where Do I Find It 2
Creating Loops With The For-each Element In XSLT
| | (Joseph Johnson) Extensible Stylesheet Language (XSL) is an XML technology which is used to transform XML data. XML file can ... [more]
[Click Here to Read More...] [TOP] |
Controlling the XML output when using the FOR XML AUTO statement in SQL Server
| | (BackyardHackMechanic) This article describes how to get more control over the XML output when using the FOR XML AUTO stateme... [more]
[Click Here to Read More...] [TOP] |
How to create config file with xml serialization
Some Basic Information About SQL in DB2-Accessing Programs
| | (Robert Catterall) DB2 has been around for a long time (more than 25 years), and a lot of people who work with DB2 have been ... [more]
[Click Here to Read More...] [TOP] |
db2top Feature of the Day - Command Line Options (-h and -d)
| | Today, I’m going to start writing about db2top command line options. There are many. I’ll start with -h (help) and -d (databa... [more]
[Click Here to Read More...] [TOP] |
WebSphere DataPower SOA Appliance performance tuning
| | (Karim Ouda) This article provides performance tuning approaches, guidelines and tips for IBM WebSphere DataPower SOA Applian... [more]
[Click Here to Read More...] [TOP] |
|
Guest Articles [Top]
The article listings denoted as GUEST are random archive articles. Those articles are always available to dues-paying members, but are also available to guest newsletter subscribers for a period of 7 days from the release of this newsletter. Each newsletter features a new set of archive articles for each of the topics.
It's our hope that when you see the quality and range of articles in the archives, you'll see what a great value your SSWUG dues-paying membership really is.
Click Here to Activate Membership Today - it only takes a minute.
Home |
Media |
Forum |
Articles |
Scripts |
FAQ's |
List Server |
Whitepapers |
Products |
Editorials |
Original Content
Newsletters |
Upcoming Events |
News |
About Us |
Jobs |
Privacy |
Terms of Service |
Contact Us
© 2009 Bits on the Wire, Inc. All Rights Reserved.
|
|
