One of the reader Nanda of SQLAuthority.com has posted very detailed script of converting any date time in desired format. I suggest every reader of this blog to save this script in your permanent code bookmark and use it when you need it. Let us learn about User Defined Functions.
SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website
I am very pleased to announce my newly renovated website. I always liked my previous website as it was “Valid XHTML 1.1” and “Valid CSS 2.0”. Since I become MVP last month I have been receiving many emails where people were expecting more from my personal website. My blog http://www.SQLAuthority.com…
Read MoreSQLAuthority News – SQL Server 2008 Pricing and Licensing
Note: SQL Server 2008 Pricing and Licensing by Microsoft SQL Server licensing and pricing are to intervined subjects and very important. I strongly suggest to use properly licensed SQL Server in any production environment. The concept of licensing can be confusing sometime to new administrators. If there is any confusion…
Read MoreSQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. The Help viewer used by Books Online requires the Microsoft .NET Framework version 2.0. Books Online includes the following types of information: Setup and upgrade…
Read MoreSQLAuthority News – SQL Server 2008 Downloads Availables
SQL Server Compact 3.5 SP1 for Windows Mobile SQL Server Compact 3.5 SP1 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP1 on the Windows mobile devices. SQL Server Compact 3.5 SP1 and Synchronization Services for ADO.NET v1.0 SP1…
Read More
SQL SERVER – Download and Install Sample Database AdventureWorks 2005 – Detail Tutorial
Just a day ago I received a question from a reader who just installed SQL Server 2008. After the installation user did not find any sample database along with installation. The user wants to install the sample database which he is very much used to. Let us learn about Sample Database AdventureWorks.
SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server
If you are receiving the following error related to connection to SQL Server, this blog is for you.Â
SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000
If you are still using SQL Server 2000 (you should have upgraded to SQL Server 2005 by now), there is Security Upgrade for Service Pack 4 and MSDE. Download SQL Server 2000 Security Upgrade Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – 2008 – Released To Manufacturing Available
Microsoft has Released To Manufacturing available for SQL Server 2008. Released To Manufacturing (RTM) means that code of SQL Server 2008 has been approved by MS team and it is being send to manufacture. It will be while before it is available on distribute media on store shelves. Currently it…
Read More
SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
One of the JR. Developer asked me a day ago, does SQL Server has similar operation like MINUS clause in Oracle. Absolutely, EXCEPT clause in SQL Server is exactly similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are…
Read More