Office Zealot

SQL Server Data Services is Microsoft's exciting addition to their Software Plus Services strategy! It's an on-demand data storage and retrieval service that will offer customers data access from anywhere on the Web. A few good points about this new service (as of the time of this writing): Microsoft has placed no limits on the amount of data ...

Hey everyone, Happy 4th fo July! I ran across this nice article by Microsoft with detailed solutions to some of the more common T-SQL problems you may encounter. Check it out! http://code.msdn.microsoft.com/SQLExamples

There are times when creating a database backup is not convenient. For example, you may be connected remotely to a SQL Server and not have access to the backup files that may be created. For times like these, I love the SSMS Tools Pack. You can find this handy gem of a SQL Server addon at http://www.ssmstoolspack.com/Download.aspx. Once you ...

In this blog, let's take a quick look at how to use a map to display nationwide sales data on a SQL Server report. You can jump quickly to the bottom of this blog entry to see how the report will finally turn out. To try out the steps below, you first need a server running SQL Server 2005 with the AdventureWorks database. You also need SQL Server ...

When you first setup your SharePoint site, the SQL Server database that is created for that site is about 10MB by default. As time passes though and you add and remove files to your site, you will notice that the database will grow very large. This can be an issue for your nightly backups and can hurt overall SharePoint performance. In this blog, ...

Welcome back to part 2 of my blog on Database-Driven Excel Charting in SharePoint. If you followed the steps from the first part of this blog, you should have an Excel 2007 workbook with a pivot table calling a stored procedure in SQL Server. In this blog, we'll publish this workbook to Excel and configure SharePoint to allow the workbook to ...

Hello everyone. I'm Gus Collazo, a member of the speakTECH Data Services team. Welcome to my first blog entry for speakTECH. In the future I'll focus my blog entries primarily on SQL Server 2008, PerformancePoint Server, and SharePoint. For my first entry though, since I'm working on a project focused on Excel Services, I'll focus on creating ...