elementalsql.blogspot.com
Elemental SQL: Setting an Environment Variable to the "14 Hive"
http://elementalsql.blogspot.com/2010/12/setting-environment-variable-to-14-hive.html
Thursday, December 16, 2010. Setting an Environment Variable to the "14 Hive". What SharePoint pro (developer or admin) does not hate the fact that the path to the root SharePoint directory is so dang long? Create an environment variable mapped to the location. C: Program Files Common Files Microsoft Shared Web Server Extensions 14 BIN". Or open a run box and type %14%. Error Accessing SharePoint 2010 ListData.svc Syst. Creating a Drag-and-Drop Upload Web Part for Share. Free CCNA Workbook dot com.
elementalsql.blogspot.com
Elemental SQL: June 2010
http://elementalsql.blogspot.com/2010_06_01_archive.html
Wednesday, June 30, 2010. Excel Services and PowerPivot for BI. I am really impressed with the enhancements in Excel services and the addition of PowerPivot to SharePoint 2010. I'm going to have to write some sort of top 10 article on the two of them. Here is an example of a dashboard I wrote for the Shceduling Department and the Production supervisors published in Excel Services. The data is driven via T-SQL queries. The datasource can even be refreshed. I'm just amazed. Tuesday, June 29, 2010.
elementalsql.blogspot.com
Elemental SQL: July 2010
http://elementalsql.blogspot.com/2010_07_01_archive.html
Thursday, July 8, 2010. How to Remove Some Thing from a Column’s Data. Here was a problem I was faced with today. A friend of mine was experiencing issues with two databases not syncing properly because one had a column (City) that contained a special character (a single quote). We needed to craft a query that would remove the single quote without changing any other portion of the column's data. There were two considerations that needed to be made:. Tuesday, July 6, 2010. Getting Back to Basics.
elementalsql.blogspot.com
Elemental SQL: May 2012
http://elementalsql.blogspot.com/2012_05_01_archive.html
Wednesday, May 2, 2012. Rich Text to Plain Text in SharePoint Client Side Object Model. It took me a while to figure out how to do this, so I thought it would be worthwhile to document it on the Internet as no matter how I searched I could not find a good solution. Basically I have a SharePoint field of type FieldMultiLineText. On the server object model). In the server object model there is the GetFieldValueAsText(). String myString = item.FieldMultiLineText[Field Name]. Free CCNA Workbook dot com.
elementalsql.blogspot.com
Elemental SQL: November 2010
http://elementalsql.blogspot.com/2010_11_01_archive.html
Wednesday, November 10, 2010. Finding Size Information for the Content of your WSS 3.0 Webs/Lists. Today I had to hack out a T-SQL query to determine information regarding the size of indiviual lists and libraries inside of a single site collection (one content DB). I used this query and then pulled it into an Excel workbook and used pivot tables to aggregate the data. Tuesday, November 9, 2010. PowerShell Script to Monitor the Status of a SQL Job. Void][System.Reflection.Assembly]: LoadWithParti...
elementalsql.blogspot.com
Elemental SQL: December 2010
http://elementalsql.blogspot.com/2010_12_01_archive.html
Thursday, December 30, 2010. Error Accessing SharePoint 2010 ListData.svc 'System.Data.Services.Providers.IDataServiceUpdateProvider' from assembly 'System.Data.Services, Version=3.5.0.0. If you receive this error. When attempting towork with SharePoint 2010 WCF Services you need to install one of the following hotfixes:. ADONET Data Services Update for .NET Framework 3.5 SP1 for Windows 7 and Windows Server 2008 R2. Don't forget to download the x64 executable! Labels: SharePoint Foundation 2010. When I ...
elementalsql.blogspot.com
Elemental SQL: September 2010
http://elementalsql.blogspot.com/2010_09_01_archive.html
Tuesday, September 14, 2010. BDC in SharePoint 2010 Foundation for a Department Level Database. One big project we are workign on currently is using the BDC to surface our company's EDI. 65279;The steps to create a fully CRUD enabled application that looks like a SharePoint liust but has all the benefits of being backed by a SQL database are as follows:. 1 Design your database as you normally would. 2 Create a set of views that the users will access to see the data. Monday, September 6, 2010. Another ite...
elementalsql.blogspot.com
Elemental SQL: Finding the Columns in a Database with Specific Names
http://elementalsql.blogspot.com/2011/01/finding-columns-in-database-with.html
Monday, January 3, 2011. Finding the Columns in a Database with Specific Names. You can use this T-SQL Query on SQL Server 2005 or greater to find all the columns that contain a word. In this example it would look for any column with the word number in it. USE DataBase GO SELECT table name ,column name 'Column Name' ,data type 'Data Type' ,character maximum length 'Maximum Length' FROM information schema.columns WHERE column name LIKE '%number%' GO. T-SQL to Populate a Table of Country Codes with IS.
elementalsql.blogspot.com
Elemental SQL: CTP1 of SQL Server Denali (SQL Server 2011) will Blow up Your BIDS Dev Environment
http://elementalsql.blogspot.com/2011/01/ctp1-of-sql-server-denali-sql-server.html
Monday, January 3, 2011. CTP1 of SQL Server Denali (SQL Server 2011) will Blow up Your BIDS Dev Environment. If you already have SQL Server 2008 R2/SSIS installed you should not install the current CTP of Danali as BIDS 2008 will become unusable. Anytime you try to create a new project you will receive the following error:. I suspect a reinstall of SSIS will correct the issue. For the moment I suggest a VM for the CTPs, should have taken my won advice! T-SQL to Populate a Table of Country Codes with IS.
elementalsql.blogspot.com
Elemental SQL: April 2010
http://elementalsql.blogspot.com/2010_04_01_archive.html
Friday, April 30, 2010. Virtualization and SAN Basics for the DBA. Brent Ozar ( twitter. Did a really nice presentation on the basics of server virtualization and SAN for DBAs. You should be able to find a recorded copy on the Pragmatic Works. Web site along with some of their past presentations. I really like the ones I have seen so far. Friday, April 9, 2010. SQL PowerShell Extensions - SQLPSX. Well the guys in the SQLPSX. Chris Barth did a nice presentation on it at the local PASS. SQL Server 2005 DBA...
SOCIAL ENGAGEMENT