SHAREPOINTBlogs.com Mirror

SQL Server Security Behavior in Windows Vista

Body: I routinely use SQL Server Management Studio to write SQL queries, ogle details of the database schema, etc. Last week, I needed to change the permissions on a SQL login, and I got the following message: That confused me, as I was logging in to Read More......( read more ) Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Moving to a new database server (or instance)

There comes a time when SharePoint databases will have to be moved to another database server. The problem is that it is not that easy to just move the databases to a new database server and have everything work. In SharePoint 2003, it was realatively simple to move all the databases, but in 2007 there is alot more involved with communication between the databases making it a more complicated scenario.Outlined below are the steps taken to move a SharePoint farm to a new database server. Perform a farm level backup of the current farm using the SharePoint backup utility in Central Administration. Make sure the backup gets saved to an accesible location either on this server or on the network. Run the SharePoint Products and Technologies Configuration Wizard to disconnect the server from the configuration database. If there is only one server in farm, then all you have to do is that server. If there are multiple servers in the farm, make sure the server running central administration is the last server disconnected from the farm. I don't believe this is a requirement, but I would recommended it anyway. Once all the servers have been removed from the farm. Run the SharePoint Products and Technologies Configuration Wizard on the server to host the central administration site first to create a new SharePoint farm. Once Server is configured, run the configuration wizard on the remaining servers adding them to the new SharePoint farm. Start both the Office SharePoint Services Search...

Introduction to the Microsoft Learning Gateway

The Microsoft Learning Gateway (MLG) consists of many products from Microsoft from Windows Operating Systems to the Office System. SharePoint is a product that is required to make up the MLG but other products that can be added, these are not necessary to make up your MLG. What does Microsoft say on the Learning Gateway? “The Learning Gateway from Microsoft is a solutions framework that helps improve education by integrating the tools you already use and putting them to work connecting people with the information and processes they need to teach and learn more effectively. “ It’s all about using Microsoft technology in teaching and learning. How it is used depends on the school/college/university and the processes within the school. What products does it include? Well it could be any of the Microsoft products – it depends on how you use it in teaching and learning. SharePoint is the main product as it can deliver content to the pupil through a web page but here is a possible list. Learning Gateway Version 3 includes the below list but you can use previous versions as they can be integrated as well. · Windows 2003 Server o All products are installed on the latest Windows Server technology o www.microsoft.com/windows2003/ · Active Directory o AD is used as the log on service for all users o www.microsoft.com/windowsserver2003/technologies/directory/activedirectory/ · SQL Server 2005 o The database server used for SharePoint, SharePoint Learning Kit as well as other products o www...

HRESULT: 0x80040E14 when added items to SharePoint

If you receive HRESULT: 0x80040E14 when trying to add an item like announcements/webpart/saving documents before running going through the Microsoft steps you have need to check the following Your SQL server data drive is not full Your mdf and ldf database files havent reached there full allocated size Your database files are set to increase when full. If you are still having this issue after checking the above follow the step listed in this link http://support.microsoft.com/kb/841216 Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Using a Web Service as a Data Source in SharePoint Designer Bug

I can set up a web service as a datasource in Share Point Designer. However, when I attempt to pull that information into a drop down list list form control it does not populate with information. I've tried it several different ways, and paralleled it with a working model using a direct sql connection. I believe this to be an error with SharePoint Designer. Please comment with any related experiences. Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Dynamic Site intergrated with a Database, List, or BDC Data

Use web parts that either actions(BDC Data), custom columns(List), or spgridview control(Database), to establish links that provide a query variable to your dynamic page. On your dynamic page, create a web part or embed server side code that creates a folder in each of your lists, document libraries, or wikki libraries. Make sure that these folder are also assigned an id value to an id field(only can be do programmatically, no default UI for this). Use the query variable given to arrange for a rootfolder query variable that navigates list web parts to their respective folders. Modify any extraneous links through javascript, utilize cookies and redirects with a custom web part to hold id values despite application page navigation. Well, I hope this helps, and good luck in the world of sharepoint! Posted on SharePoint Blogs Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

SharePoint Designer Errors When Opening, Checking-In, Checking-Out Files & Shrinking Transaction Log Files

Here’s another quirk for SharePoint Admins & Designers out there. If you ever come across something like “soap:ServerServer was unable to process request” while trying to work with pages in SharePoint Designer, congratulations! Now you can also be a part time DBA. Here’s a description of the problem: While working with custom SharePoint pages in [...] Mirrored on SharePoint Blogs Posted on SharePoint Blogs...( read more ) Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

SQL & CRM performance – GROUP BY and COUNT with CASE statements

This post is really about performance. I had a situation where I started off using subqueries: SELECT DISTINCT Account.Name AS BusinessName, Test.New_name AS TestName, (SELECT COUNT(*) FROM New_Test T2 WHERE T2.New_AccountId = Account.AccountId AND T2.new_testtypeid = Test.new_testtypeid AND new_result LIKE '%PASS%') AS PassedItems, (SELECT COUNT(*) FROM New_Test T2 WHERE T2.New_AccountId = Account.AccountId AND T2.new_testtypeid = Test.new_testtypeid AND new_result LIKE '%FAIL%') AS FailedItems FROM Account INNER JOIN New_Test Test ON Account.AccountId = Test.new_accountid Looking at the above SQL select query, for each row of the returned records two additional select statements must be executed. Well the problem is that CRM views involve a few tables, and the particular company I was doing this for had LOTS of records. While the above example is significantly simplified, reduced in size, shortened etc. etc. the query I had to use was way too much of a performance hit on a quality server. I roughly estimated it will take around 6 days to execute. And I had to use the LIKE keyword. I even tried without using the views. So after a lot of good old google searching, reading articles and blogs I came up with the following: I grouped the results and used CASE statements within the COUNT function to provide me with the sums of data that I require. SELECT DISTINCT Account.Name AS BusinessName, Test.New_name AS TestName, COUNT(CASE WHEN New_Test.new_result = 'FAIL'...

My First SharePoint Blog

Hey all, I am an IT Consultant with Levi, Ray, and Shoup, Inc. I attended their Portal University in July - October '05 and have worked with LRS as a SharePoint Consultant ever since. I have been on numerous successful engagements deploying SharePoint 2003, MOSS 2007, InfoPath 2003 and 2007. I have a strong foundation in many languages including but not limited to SQL, C#, XML, XSLT, JavaScript, CSS, HTML, ASP.NET. I have worked with SharePoint...

SharePoint Disaster Recovery Tips Using SharePoint and SQL Backups

There are a number of companies out there that utilize SQL transaction log backups for their SharePoint solution. This of course is fine and supported by Microsoft, but if there is a complete disaster then the SharePoint administrator will have to piece everything back together. My recommendation is to run the SharePoint full backup option in conjunction with the SQL Transaction log backups. SharePoint backup / restore (either through the central...

Database Mirroring or Log Shipping for SharePoint

Michael Watson posted a short blog on Database mirroring and log shipping. Which is better? but this fails to highlight that SharePoint does not support the ";Failover Partner=PartnerServerName" and therefore does not offer the benefit of automatic Read More......( read more ) Read More... Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks