Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

August 2008 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

August 2008 - Posts

Working with DateTime data types in SQL Server, guidelines and explanations!

Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it expects raw date and time data to be in when inserting dates into a DATETIME, or SMALLDATETIME columns. If you attempt to insert a date that does not match one of the default date formats, then SQL Server will reject the date/time value. If your raw data does match one of the default formats, SQL Server will automatically convert your raw data into a DATETIME value without any special consideration.

Sometimes I get confused with how to deal with various types of formats when you have the data which is globalized in terms of users usability. So here I would like to give you a lead and links on various datetime data types within SQL Server:

Demystifying the SQL Server DATETIME Datatype (one of my favourite)

Advanced SQL Server DATE and DATETIME Handling

Date and Time Manipulation in SQL Server 2000

The ultimate guide to the datetime datatypes

SQL Server 2008 RTM Books OnLine (BOL), latest and update your local copies

Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand.

You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as the current installation is latest and updated.

MSDN Developer Center page provides wide range of users to download the BOL as follows:

Download Books Online from the Download Center

So don't wait and you can easily download the relevant language BOL to update your local copies.

Since the days of SQL 2000 version I have been doing the same and it proved very useful when you need to find about any information SQL Server in particular!

 

SQL Server 2008 installation vows on Windows Server 2008

After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet premium subscribers all over the world were attempting the same.

Ok, I have got the setup media and to test upon I have downloaded the files for following editions:

SQL Server 2008 Enterprise. SQL Server 2008 Enterprise is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics and reporting support for running business-critical applications. With this edition, it is possible to consolidate servers and perform large-scale online transactional processing.

SQL Server 2008 Web. SQL Server 2008 Web is designed for highly available, Internet-facing Web-serving environments running on Windows Server. SQL Server 2008 Web provides the tools necessary to support low-cost, large-scale, highly available Web applications or hosting solutions for customers.

As the SQL Server 2008 Web edition is quite interesting and suitable for web-related applications as referred above. I need to test the editions in order to ensure the Web edition is suitable for set of clients I support to reduce the costing of deploying the SQL Server 2008 within their data platform, interesting eh.

Extracted the setup files and as one of the best practice I haven't attempted to install SQL Server to my laptop directly (remembering the Old-CTP6 installation issue), rather I have created a new Virtual Machine (Virtual Server 2005) with Windows Server 2008 to install. So far so good, now the flurry of troubles are started after a double-click of setup  file on [en_sql_server_2008_web_....] directory!

First one is :

  • SQL Server does not install the .NET Framework 3.5 software development kit (SDK). However, the SDK contains tools that are useful when you use the .NET Framework for SQL Server development. You can download the .NET Framework SDK from the .NET Framework Web site.

  • Requirements to restart computers during SQL Server Setup: Installation of the .NET Framework requires a restart of the operating system. If Windows Installer installation also requires a restart, Setup will wait until .NET Framework and Windows Installer components have installed before restarting.

Next one is requisite for Visual Studio (for a moment I wondered what this is for!)

Rule "Previous releases of Microsoft Visual Studio 2008" failed.

Struggled to find out why the setup is bombing out with same error (2 times), a couple of searches on MVP private newsgroups found the resolution, bingo!

956139 Visual Studio 2008 SP1 may be required for SQL Server 2008 installations

Then all good with the installation and completed with no further errors, phew.

Failed to start SQL Server services, with no obvious errors or indication. Inspite of checking the local policy on the server to ensure the relevant service account has got privilege to logon locally with ADMIN privileges. Like the one below:

 

Finally I have found the detailed information and resolution on the issues that might occur on Windows Server 2008 Firewall issues - Windows-SQLServer_2008_FirewallWatchout with an excellent post by Shawn Hernan (thanks).

Hope you might fall into one of the above issues or all of them and I believe this should help.

SQL Server 2008 RTM is released, its official now!

Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease :

...announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive and intelligent platform necessary for business-critical applications.

It is indeed a great news for the SQL Server users about 2008 RTM, as their journey begins since last year from CTP4 onwards from this CTP-Post & [SQL Server 2008 features and getting through CTP, RC, RTM. Are we there yet?] here.

So now the question is about number of editions that are available, it will be (as per BOL):

SQL Server 2008 Enterprise. SQL Server 2008 Enterprise is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics and reporting support for running business-critical applications. With this edition, it is possible to consolidate servers and perform large-scale online transactional processing.

SQL Server 2008 Standard. SQL Server 2008 Standard is a complete data management and business intelligence platform that provides best-in-class ease of use and manageability for running departmental applications.

SQL Server 2008 Workgroup. SQL Server 2008 Workgroup is a reliable data management and reporting platform that delivers secure, remote synchronization and management capabilities for running branch applications. This edition includes core database features and is easy to upgrade to the Standard or Enterprise edition.

SQL Server 2008 Web. SQL Server 2008 Web is designed for highly available, Internet-facing Web-serving environments running on Windows Server. SQL Server 2008 Web provides the tools necessary to support low-cost, large-scale, highly available Web applications or hosting solutions for customers.

SQL Server 2008 Developer. SQL Server 2008 Developer allows developers to build and test any type of application with SQL Server. This edition features all of the functionality of SQL Server Enterprise but is licensed only for development, test and demo use. Applications and databases developed on this edition can easily be upgraded to SQL Server 2008 Enterprise.

SQL Server 2008 Express. SQL Server 2008 Express is a free edition of SQL Server that features core database functionality including all of the new SQL Server 2008 data types, in a small footprint. This edition is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.

SQL Server Compact 3.5. SQL Server Compact is a free embedded database designed for developers and is ideal for building stand-alone and occasionally connected applications for mobile devices, desktops and Web clients. SQL Server Compact runs on all Microsoft Windows platforms, including the Windows XP and Windows Vista operating systems, and on Pocket PC and smartphone devices.

As Microsoft keeps its words about costing on deploying this product, in terms of licensing as per License_pressrelease information.

So whats the catch on the downloads, it is now available to MSDN and TechNet subscribers and will be available for evaluation download from Aug. 7, 2008. SQL Server 2008 Express and SQL Server Compact editions are available for free download now FromHere.