My recent blog posts and just learned tips - SQL Server by serverku

Recently I have posted some of the articles and some just learned from the month of October. This article just summarizes all the posts which recently published. You can find the links below to go into the details.

Blog Posts:

• The database owner SID recorded in the master database differs from the database owner SID recorded in database
• Database Backup files Verification and Details
• Grouping Sets vs Native method of Group By - Performance review
• Multi server Query with Central Management Servers
• How to reset SQL Server all default settings in SQL Server Denali CTP3
• Stored Procedure Internal Activation in Service Broker
• New Logical functions coming in SQL Server Denali CTP3
• The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
• New String functions arrived by SQL Server Denali CTP3
• Service Broker - Conversation between Databases
• Backup Statistics and History
• NOLOCK Hint & READ UNCOMMITTED Isolation level On table and Query/Session level
• Can not add a shared registered server with the same name as configuration Server
• Database Backup Compression, Amazing feature for DBA
• Review of some replication issues and workaround
• Multi Monitor Support of SSMS

Just Learned tips:

• Script to download file via FTP in SQL Server
• Perform database backup using SQLCMD utility in SQL Server
• Could not connect to server 'RemoteServer' because 'LocalServer' is not defined as a remote server in sql server
• Could not find stored procedure 'sp_MSins_TableName' in replication in sql server
• There is insufficient system memory to run this query
• Change SQL Server instance name
• Adding a transactional pull subscriptions to a publication in replication
• Adding Indexed views in publication for transactional replication
• Adding the transactional publication in Replication
• Enabling the replication database
• Add Functions in publication for transactional replication using tsql script
• Add Stored Procedures in publication for transactional replication using script
• Script to add views in existing publication in transactional replication
• Script to add table in existing publication in transactional replication

Hope these posts help you.