You are exploring high availability and disaster recovery options and want to know more about SQL Server Availability Groups. What are some of the Frequently Asked Questions about SQL Server Availability Groups?
Please read the latest MSSQLTips post: “SQL Server Availability Groups: Your FAQs Answered“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
Learn about Microsoft Kerberos Configuration Manager and how to use it and for what.
Please read the latest MSSQLTips post: “Kerberos Configuration Manager for SQL Server SPN Validation“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
How can we configure transactional replication without primary keys?
Please read the latest MSSQLTips post: “SQL Server Transaction Replication for Tables without a Primary Key“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
How to migrate our SQL Server Analysis Services (SSAS) instances from SQL Server 2012 to SQL Server 2017. What are the steps?
Please read the latest MSSQLTips post: “SSAS Migration from SQL Server 2012 to SQL Server 2017“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
Recommendations for hardening the SQL Server installation for the configuration where SQL Server is only accessible by the application installed on the same server.
Please read the latest MSSQLTips post: “SQL Server Security Best Practices for an Application“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
Problems with SQL Server Agent Jobs can lead to missing backups, missing notifications about a failed job and sometimes missing mission critical tasks that are run as scheduled jobs.
Some of the common SQL Server Agent Job problems are described in other MSSQLTips tips. In this tip we have provided a single script that will check the jobs for a number of issues including:
Please read the latest MSSQLTips post: “SQL Server Agent Jobs Monitoring Script“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
After downgrading SQL Server Enterprise Edition to the Standard one some of the configuration settings are reset to the default values. In this tip we provide examples of some of the issues you may have after the SQL Server Edition downgrade.
Please read the latest MSSQLTips post: “SQL Server Edition Post-Downgrade Steps“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
In this tip we have provided two non-traditional ways of learning SQL Server. These methods are not for exam preparation or for learning SQL Server from scratch, but more for learning small things that you may be not aware of or forgot about.
Please read the latest MSSQLTips post: “Non-traditional ways to learn more about SQL Server“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
Database Administrator (DBA) on-boarding is not always as efficient as it could be. Whether this is for new full time employees or contractors. We often have to wait for system access, computers to be setup, the right software to be installed, etc. How can we be sure that the new DBAs are productive a soon as possible? How can we use highly qualified contractors in the most effective way from day one?
Please read the latest MSSQL Tip: “SQL Server DBA On-Boarding Checklist“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.
This is the last tip about objects dependencies.
What should you know about the sys.sql_expression_dependencies DMV (Dynamic Management View)?
Please read the latest MSSQL Tip: “Finding SQL Server Object Dependencies with DMVs“.
Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.