News & Announcements #1

Welcome to a new era of Think SQLServer!

ThinkSQLServer.com was started and is run, Our website description is "Free Microsoft SQL Server helps, articles, news, forums, scripts and free source code. Latest SQL Server Technology news and reviews. Easily navigate to articles Stored Procedure, Functions, Reporting Services and more."

Hello everone we're currenly adding Transact-SQL Reference help content with easily navigate

Transact-SQL Reference help content will be live soon!, our Transact-SQL Reference is The Community Content feature provides the ability to add and edit content note. 

 

New Date Datatypes in SQL Server 2008

SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Heres can you can use these new data types to your advantage in SQL Server 2008.

As a database architect, one of the features I am most excited about in SQL Server 2008 is the new date related data types.

Read more: New Date Datatypes in SQL Server 2008

 

Stored Procedure Basics

Typical uses for stored procedures include data validation (integrated into the database) or access control mechanisms. Furthermore, stored procedures are used to consolidate and centralize logic that was originally implemented in applications. Large or complex processing that might require the execution of several SQL statements is moved into stored procedures and all applications call the procedures only.

Read more: Stored Procedure Basics

   

Reporting Services Features

SQL Server Reporting Services provides a middle-tier server that runs under Microsoft Internet Information Services (IIS), allowing you to build a reporting environment on top of an existing Web server infrastructure.

You can build reports that draw data from the data servers that you have in place for any data source type that has a Microsoft .NET

Read more: Reporting Services Features

 

Microsoft SQL Server 2005 Reporting Services (SSRS)

Microsoft SQL Server 2005 Reporting Services (SSRS) delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

Read more: Microsoft SQL Server 2005 Reporting Services (SSRS)

   

Page 1 of 2