PostgreSQL

comments and questions about working with SQL Server and PostgreSQL

DB2

Questions about DB2 and SQL Server

Granting View Definition Permission to a User or Role in SQL Server

In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.

The Push to Upgrade from SQL Server 2005

There's a push to upgrade those SQL Server 2005 instances with support ending this April.

Who's Got a Preteen SQL Server?

This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.

Is It Time to Upgrade?

Today Steve Jones looks at the reasons for upgrading, or not, from SQL Server 2005.

Sweeping out SQL Server 2005

Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.

Trace Flags

Analytical functions available in SQL 2005

SQL Server Stumpers, Vol.5

Whether practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself and increase your knowledge.