(satnam singh) Scenario: A couple of days back, I got a call from one of my users saying that the Data is not being replicated properly onto the Production Reporting Server from the Production OLTP server.

(Pinal Dave) Social media is evolving at a rapid pace and every day I keep on getting question from different methods. Here is the latest question which I received on my Facebook page. The question was how to export the data of query into CSV using SQLCMD.

(Scott Guthrie) This past weekend we released a number of enhancements to Windows Azure. These new capabilities include:

(Derek Colley) Corrupt SQL Server databases are the worst nightmare of any SQL Server professional. In any environment, from small business to enterprise, the compromise of integrity and availability of the data can constitute a business emergency. This is especially the case in those organizations

(Rohatash Kumar) Today, I have provided an article showing you the Len and DataLength methods in SQL Server 2012. In this article, you will see the difference between the SQL Len and DataLength functions with an example.

(Jen McCown) When was the last time you looked at a SQL Server new feature list and said, gOhhh, WOW!h? Was it around March of last year? No? Then you might have missed something really, really cool.

(Shaun J Stuart) SQL 2008 saw the introduction of data compression to SQL Server. (I’m referring specifically to data compression, not backup file compression.) This Enterprise-only feature allows SQL Server to store data on disk and in memory in a compressed format. SQL can perform three types of d

(Svetlana Golovko) Brady Upton explains in his tip how to create a SharePoint KPI that will display SQL Server versions. In this tip we will show how to check SQL Server versions on multiple instances using Policy Based Management.

(Kenneth Fisher) If you are lucky you’ve never seen an error along the lines of:

(Vishal Gajjar) To rename an object in SQL Server you can use sp_rename system stored procedure or you can do this via Object Explorer in SQL Server Management Studio.