Archive for the tag 'sql'

Microsoft SQL Server 2008 Screencast

Ivan Versluis June 8th, 2008

imageSQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi-structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. Your data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored. SQL Server 2008 enables you to consume your data within custom applications developed using Microsoft .NET and Visual Studio and within your service-oriented architecture (SOA) and business process through Microsoft BizTalk Server while information workers can access data directly in the tools they use every day, such as the 2007 Microsoft Office system. SQL Server 2008 delivers a trusted, productive, and intelligent data platform for all your data needs.

Before you evaluate and install Microsoft SQL Server 2008 on a Windows Server 2003 server please make sure the following requirements are available:

If you are ok with those than go and install the SQL server 2008. My installation took me 15 minutes and the performance was awesome within a Virtual Server 2005 R2 virtual machine. Check out my screencast with installation screenshots.

 sql-2008-19

How to shrink the SMS_SITENAME database SMS 2003?

Ivan Versluis January 24th, 2008

The SMS 2003 infrastructure I am managing has one singe SMS database which became 4 GB. 1GB data and 3GB log. Today I planned the database maintenance and managed to shrink the files with 3GB. Open the Enterprise Manager or Microsoft SQL Server Management tools and make sure the database option is set to Auto Shrink = Auto (enhancement for the future).

image

Run the following sql script:

USE [SMS_123]

GO

DBCC SHRINKFILE (N‘SMS_123_log’, 0, TRUNCATEONLY)

GO

Another useful script can be found here which will create a stored procedure and show all table space sizes with rows and MB used.

exec sp_show_huge_tables


image