Last week, one of my customers had engaged me for consulting to configure Log Shipping on clustered instance of SQL Servers which are running in different domains. In other words, the primary and secondary servers are in different domains. While … Continue reading
Tag Archives: sql server
SQL Server Predeployment IO Stress Testing using sqlio Tweet
TweetWhile there are some really good in-depth whitepapers and blogs (specifically by CSS Team and Brent Ozar & his team) to address this topic. However the information in these blogs,whitepapers is kind-off scattered and for a novice the information in … Continue reading
Blogs on SQLServerGeeks
TweetFollowing are links to my blog post on SQLServerGeeks.com. Hope you find them useful Does Parallel Plan for rebuild index impact the fragmentation of index? http://sqlservergeeks.com/blogs/Parikshit/personal/427/does-parallel-plan-for-rebuild-index-impact-the-fragmentation-of-index Understanding SQL Server Page Allocation using new sys.dm_db_database_page_allocations introduced in SQL 2012 http://sqlservergeeks.com/blogs/Parikshit/personal/433/understanding-sql-server-page-allocation-using-new-sys-dm_db_database_page_allocations-introduced-in-sql-2012 Parikshit … Continue reading
Sql server performing slow after changing the Cost Threshold for parallelism
TweetWe have observed a few cases now where sql server has started performing slow after changing the Cost Threshold Of Parallelism server option of the sql server. Ironically in such cases we observe that sql server is performing slow even … Continue reading
Did you know… The applications like Infopath may fail to submit data into table in SQL Server if the table is included in Merge replication
TweetYou are able to submit the data in the table using the application like InfoPath 2007 but when you go ahead and add the table in the Merge Replication Publication, the insert into the table using the InfoPath form starts … Continue reading
How to change the keys for the Encryption for an already encrypted database
TweetHave you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the … Continue reading
USE OF KERBEROS AUTHENTICATION IN SQL 2005
TweetKerberos is a network authentication protocol which can be used only with TCP/IP protocol. So if the client connects to the sql server with the Named Pipe Alias Kerberos is not used. Every service that will use Kerberos authentication needs … Continue reading