A Microsoft white paper comparing SQL Server 2008 with Oracle Database 11g on performance, security, BI, Office integration and total cost of ownership.
SQLAuthority News – Famous Quotes From Bill Gates
A few famous Bill Gates quotes I like, on success, the software revolution, new technology, education and reducing poverty in the world.
SQL SERVER – 2008 – SQL Server Start Time
SQL Server 2008 records when it started in sys.dm_os_sys_info. One SELECT of sqlserver_start_time gives you the SQL Server start time. It does not work on 2005.
SQL SERVER – Introduction to SERVERPROPERTY and example
SERVERPROPERTY is a handy system function that returns server values like collation, edition and instance name. My script lists every property in one result.
SQL SERVER – 2008 – Inline Variable Assignment
SQL Server 2008 adds inline variable assignment, so DECLARE @MyVar INT = 5 works in one line. I compare it with the SQL Server 2005 way of DECLARE then SET.
SQLAuthority News – 600 Article and Over 3 Million Readers
Today is the 600th article on this blog, and over 3 Million readers have visited so far. Thank you. Send me your ideas, and see my favorite and best articles.
SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server
Use Policy Management in SQL Server 2008 to enforce rules, not just list them. A short tutorial that blocks any stored procedure created without the usp prefix.
SQL SERVER – 2008 – Step By Step Installation Guide With Images
A step by step SQL Server 2008 RC0 Installation guide with images for every screen, written because so many readers asked me how to install it.
SQL SERVER – 2008 – Four Key Pillars
What is new in SQL Server 2008? Its four key pillars: Enterprise Data Platform, Beyond Relational, Dynamic Development and Pervasive Insight.
SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
The SQL Server 2008 Reporting Services Add-in for SharePoint (RC0) brings report viewing, subscriptions and report management into WSS 3.0 and SharePoint Server 2007.