Jun28

SharePoint Disaster Recovery Survey

Categories: SharePoint 2010, SQL Server, SharePoint Administration
In my new role I’m focusing a great deal on the Operations required for a successful implementation of SharePoint.  As we all know, it’s crucial to ensure that you have a valid Disaster Recovery plan in place.  To that point, DR plans are going to c...
0  Comments | 0  Links to this post
 
Apr2

Reporting Services Error

Categories: SQL Server
Getting SQL Server Reporting Services up and running and then integrated with SharePoint can be a bit of a challenge.  There are just different pieces and too many areas where something can go wrong.  When testing your Report Server, you may get t...
0  Comments | 0  Links to this post
 
Mar31

Report Builder 2.0 for SharePoint 64 bit Integration

Categories: SQL Server, SharePoint Administration
When you integrate SSRS with SharePoint, by default the Report Builder is 1.0.  You can install the Report Builder 2.0 and configure SharePoint to use it instead.  But you are going to run into issues if your SharePoint environment is 64-bit.  ...
0  Comments | 15  Links to this post
 
Dec20

SharePoint Comic Server Security

Categories: SharePoint Comic, SQL Server
  I created this comic for Joel Oleson to use in his Tech Ed presentation.  Cross-Posting it here after the fact, mainly because I have been too busy to create a new comic.  :)...
0  Comments | 0  Links to this post
 
Sep25

What service pack is on my SQL Server?

Categories: SQL Server
Quick way to determine which SP is on your SQL Server:  "If you are a DBA in a big SQL Server database shop, keeping track of what service packs are on each SQL Server can become daunting. Here are a couple of scripts that help you determine wh...
0  Comments | 0  Links to this post
 
Sep25

SharePoint Crawl and SQL Server Errors - Event ID: 17310

Categories: SQL Server
After setting up a crawl rule to crawl something other than SharePoint sites (such as a file share), you may encounter some errors for SQL Server.  If you start to see these repeatedly - check that you have the latest service pack for Microsoft SQL ...
0  Comments | 0  Links to this post
 
Sep19

Change default location for SharePoint Database files: .mdf .ldf

Categories: SQL Server
When installing SharePoint, you may have decided you want to keep your data files for the database on a separate directory / drive.  However, you need to keep in mind that the SharePoint installer is going to create the databases for you automatical...
1  Comment | 0  Links to this post
 
May8

SQL Script to attach a database

Categories: SQL Server
note: this script detaches it first   EXEC sp_detach_db @dbname = 'dbnametoattach' EXEC sp_attach_single_file_db @dbname = 'dbnametoattach', @physname = 'c:\yourdirectory\dbnametoattach.mdf'   - Dan Lewis...
0  Comments | 0  Links to this post
 
Oct2

Turn Identity Insert Off and On

Categories: SQL Server
This is a really great thing to know if you are migrating data from one database to another and absolutely must retain the Id field of your records.  You can turn Indentity Insert Off / On so that you can specify the Id during insertion. Don't get c...
3  Comments | 0  Links to this post
 
Sep12

Add a Column To An Existing Table

Categories: SQL Server
If you need to add a column to an existing table with a default value:   ALTER TABLE YourTableName ADD YourColumnName varchar(50) DEFAULT ‘your default value’ WITH VALUES...
0  Comments | 0  Links to this post
 
 Next >>

Popular Posts

Categories

Archives