(Linchi Shea) You may disagree, but I believe it is a good practice to cluster all the SQL Server instances. That is, even when you plan to run a SQL Server instance on a single machine, you should install it in a single node cluster.

(Szymon Wojcik) Have you ever tried creating objects and giving them strange names? I made some experiment at one of lab servers, main focus was space (you know, the long key at the bottom of the keyboard :D). So, without further ado – the first object to be tested is a database.

(Rob Kraft) Occasionally, you realize that you desire to create a lot of stored procedures, and that the information to build each stored procedure is contained within the database. But how can you best generate the code from the data? Well, assuming you like SQL, you can probably use SQL to generat

(Stacia Misner) The upcoming release of SQL Server 2012 has a lot of new features for business intelligence developers to love. The free preview of Introducing Microsoft SQL Server 2012 (Microsoft Press, 2012) does not include the chapter on Analysis Services, but you’ll be able to read the details

(Glenn Berry, Louis Davidson and Tim Ford) Every time a SQL Server session has to wait for some reason before the requested work can continue, SQL Server records the length of time waited. It also records the resource for which the transaction is waiting.

(Jugal Shah) Log shipping has been an option for creating a failover server for SQL Server for quite some time. In this tip, we look at different ways that you can monitor the status of your log shipped databases.

(Jeff Wharton) Ever been in the situation where you’re so fixated on debugging an error that you fail to see the solution which has been staring you in the face the whole time? Me too.

(Brady Upton) SQL Server Reporting Services has some cool features such as displaying maps and data points on the maps. In this tip I show how to take a list of addresses and display them as pinpoints on a map in an SSRS report.

(Ananthakumar Muthusamy) One of the many features that Microsoft is introducing to the new SQL Server 2012 is Sequence object. In this article I am going to illustrate how to create and use the Sequence object.

(Madhivanan) As you all know tempdb is responsible of storing all the temporary objects created for a server. One of my co-workers asked me “what is the scope of permanent tables created in the tempdb database?”. The answer is it can be accessed via tempdb from various connections just like objects