Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- One of my UK based client , wanted to upgrade its production database to SQL server 2017 version (Enterprise edition) from existing SQL server 2014 …
Continue reading Microsoft SQL Server 2017 Deprecated & Discontinued Features- Go Through
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- Have you ever tried connecting SQL server integration service through management studio and failed to connect and receive error like Class not registered? I recently …
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- Recently, I had received a request from one of the customer to send some report from SQL to his management and it looks pretty simple …
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Scenario:- During DR exercise,Prod and DR was configured with log shipping technology and once the Dbs. were brought online, somehow due to incorrect connection string settings …
Continue reading How to find who has dropped/deleted SQL server user databases
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario: Parallel backup as the name itself suggest at a time multiple databases …
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2008 and onward. Scenario: Assume its exiting or new SQL server handed over to you and you …
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario: In DBAs life, this is most important and weekly\daily kind of stuffs. Due …
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario: There might be few cases where you as a DBA need to rebuild …
Continue reading Rebuild heap tables in SQL server using cursor
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Infrastructure: This has been run and tested successfully on SQL 2005 and onward. Scenario: Many DBAs create their own lab at home for learning and r&d purpose. …
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. Error: FullText Search Error 1075: The dependency service does not exist or has been marked for deletion Infrastructure: SQL server 2005 and onward Scenario: While I was working …
ADsql-Tech Forever 
You must be logged in to post a comment.