Other SQL Server Blogs around the Web

Browse by Tags

• best practices
• blogs
• business intelligence
• credentials
• dashboard
• execute
• export to excel
• format
• integration
• olap
• pivot
• procedure
• reporting services
• security
• SharePoint 2007
• sql server
• ssas
• ssms
• stored
• T-SQL

• Take advantage of SQL Server Business Intelligence tools with Sharepoint

  BI - Business Intelligence has become an integral part of data platform since Microsoft revealed the features from SQL Server 2005 version onwards. As per this strategy of Microsoft comprises a suite of server and client-side data integration tools, not... Posted Feb 28 2010, 04:37 PM by <P>SqlServer-QA.net</P> Filed under: sql server, dashboard, integration, best practices, business intelligence, excel, SharePoint 2007

• Export to Excel - data length exceeds 255 characters

  If you use Data Transaformation Services to send data to EXCEL, you may get error about the size of the cell if length of data exceeds 255 characters. This KB from microsoft explains how to solve it http://support.microsoft.com/default.aspx?scid=kb;en... Posted Jun 22 2009, 08:14 AM by <P>SqlServer-QA.net</P> Filed under: sql server, excel, T-SQL

• Export to EXCEL with column names

  In the post Import/Export to Excel , I showed how to export data to EXCEL The problem that most users find it is it wont include column names in the file and file should exists already with headings This procedure would solve that problem create procedure... Posted Oct 14 2008, 05:03 AM by SqlServer-QA.net Filed under: sql server, excel, T-SQL, export to excel

• Interesting and useful cross-blogs

  Interesting and usefull cross-blogs from a fellow MVP on stored-procedures, transactional replication: Parse delimited string in a Stored procedure Exporting blank SRS report to excel does not render the headers Setting up Transactional Replication from... Posted Jan 17 2008, 03:26 AM by SSQA.net Filed under: sql server, procedure, reporting services, blogs, excel, format, stored

• OLAP Connectivity from Pivot Table in Excel - security permissions

  Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database... Posted Sep 25 2007, 04:14 AM by SSQA.net Filed under: olap, execute, credentials, excel, sql server, ssms, security, ssas, pivot