Standard Members Archives - Page 24 of 110

Standard Members

Undocumented SQL Server 2017 log shipping stored procedures

by Alexander Chigrik

Undocumented SQL Server 2017 log shipping stored procedures SQL Server 2017 supports the following useful undocumented log shipping stored procedures: sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_delete_log_shipping_monitor_info sp_delete_log_shipping_monitor_jobs sp_log_shipping_get_date_from_file sp_check_log_shipping_monitor_alert The sp_check_log_shipping_monitor_alert log shipping stored procedure is used to check all monitor alerts in the primary database and in the secondary database in log shipping configuration. Syntax sp_check_log_shipping_monitor_alert Return Code Values 0 (success) or...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Database Models and Relational Algebra – Part 2

by Sunny Singh

B+ Tree Index Files Any B+ tree is the n-ary tree structure with a variable however over and over again large number of children per node used to be present. A B+ tree is consisting of a root, internal nodes as well as leaves. The root might be one or the other leaf node with two (2) or more (N)...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 distributed queries stored procedures

by Alexander Chigrik

Undocumented SQL Server 2017 distributed queries stored procedures SQL Server 2017 supports the following useful undocumented distributed queries stored procedures: sp_catalogs_rowset sp_catalogs_rowset2 sp_catalogs_rowset_rmt sp_linkedservers_rowset sp_linkedservers_rowset2 sp_catalogs_rowset The sp_catalogs_rowset stored procedure returns the database name for the specified database if the current user has access for this database. Syntax sp_catalogs_rowset [ @catalog_name = ] ‘catalog_name’ Arguments [ @catalog_name = ] ‘catalog_name’...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Database Models and Relational Algebra – Part 1

by Sunny Singh

DATA MODELS The hidden structure of any database is known as the data model. To represent the idea of a data model, two data models in this part were discussed: the entity – relationship model as well as the relational model. Both the models give a method for describing the databases at the logical level. RELATIONAL MODEL The relational model...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 Database Engine Stored Procedures

by Alexander Chigrik

Undocumented SQL Server 2017 Database Engine Stored Procedures SQL Server 2017 supports the following useful undocumented database engine stored procedures: sp_bcp_dbcmptlevel sp_objectfilegroup sp_MSforeachdb sp_MSforeachtable sp_MSindexspace sp_MStablespace sp_bcp_dbcmptlevel The sp_bcp_dbcmptlevel stored procedure is used to get the database compatibility level for the specified database. Syntax sp_bcp_dbcmptlevel [ @dbname = ] ‘dbname’ Arguments [ @dbname = ] ‘dbname’ The database name to...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

How to Stay Motivated on Long-Term Projects

by Laura Lee Rose

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management, and work-life balance strategies. This question came from a small business owner. What are some...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Some tips to use System Monitor with SQL Server 2017

by Alexander Chigrik

Some tips to use System Monitor with SQL Server 2017 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2017. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. To start System...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Reasons Potential Clients Don’t Reply After Showing Interest

by Laura Lee Rose

This question came from a small business owner. What would be the reason potential clients don’t reply after showing interest? I sent some promotional emails to companies, they were interested and asked to see the catalog. Since I have a catalogue download link on my website page and I asked them to download there. Then they never replied to me,...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

SQL Server 2017 Profiler Optimization Tips

by Alexander Chigrik

SQL Server 2017 Profiler Optimization Tips SQL Server 2017 Profiler is a graphical user interface for monitoring an instance of the Database Engine or Analysis Services. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and optimize...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Tips for Starting a Blog

by Laura Lee Rose

This question came from a small business owner. What do I need to know about blogging before I start? Will this help me get more business? I’m new at this and I have no idea what I’m doing or where to start. Everyone starting out will make mistakes, but keeping these few items in mind will reduce your learning curve....

Already a member? Log in here

Continue Reading →