Standard Members

Pro Members SQL Server Standard Members

How Can I Tell if This Person Will Make a Good Business Partner?

A busy professional asks a question regarding employer/employee relationships. How can I tell if this person will make a good business partner? I am looking for a business partner. How do I know that this person will be a strong leader and is good at execution? Is there a way to test their skills and check whether he/she possesses a...

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
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 In-Memory OLTP

Troubleshooting SQL Server 2016 In-Memory OLTP If you have problems with In-Memory OLTP in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 In-Memory OLTP bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...

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
Pro Members SQL Server Standard Members

Troubleshooting xml problems in SQL Server 2016

Troubleshooting xml problems in SQL Server 2016 If you have problems with SQL Server 2016 XML, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 XML bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this...

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
Pro Members SQL Server Standard Members

How to switch from Digital Marketing to Business Analysis

Today’s question comes from a busy professional: Is it possible to switch directions in my career, from digital marketing to business analysis? I am currently in digital marketing but I want to build a career in business analysis. Is that possible? Yes. It is possible to switch directions in your career from digital marketing to business analysis. But you don’t...

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
Pro Members SQL Server Standard Members

Troubleshooting problems with joins in SQL Server 2016

Troubleshooting problems with joins in SQL Server 2016 If you have problems with joins in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many join bugs were fixed in SQL Server 2016 service packs, you should install the latest SQL Server service pack. At the time this...

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
Development Pro Members Standard Members

Questions People Forget To Ask Their Boss

Today’s question comes from a busy professional: What are the questions you should always ask your boss? What do you need to find out, or clarify? And why? Please see my questions below. 1. What questions should people always ask their boss, and why are they important to ask? 2. Is it okay to ask your boss questions? Why might...

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
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2016 Stored Procedures (Part 4)

Useful Undocumented SQL Server 2016 Stored Procedures (Part 4) SQL Server 2016 supports the following useful undocumented stored procedures: sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_log_shipping_get_date_from_file sp_MSget_jobstate sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs 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)...

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
Pro Members SQL Server Standard Members

Things to Avoid Saying During a Salary Negotiation

What are some things to avoid saying during a salary negotiation? Please respond with any top tips for mid-career people looking to negotiate a higher salary. It’s time to ask for a raise, what are some things to avoid saying during a salary negotiation? Common Traps Meet with your manager to outline exactly what you need to accomplish and deliver...

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
Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2016 Stored Procedures (Part 3)

Useful Undocumented SQL Server 2016 Stored Procedures (Part 3) SQL Server 2016 supports the following useful undocumented stored procedures: sp_catalogs_rowset2 sp_catalogs_rowset_rmt sp_linkedservers_rowset sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_catalogs_rowset2 The sp_catalogs_rowset2 distributed queries stored procedure returns the list of the databases the current user has access to. Syntax sp_catalogs_rowset2 Return Code Values None. Result Sets Column name Data type Description CATALOG_NAME nvarchar(128) Is...

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
Development Pro Members Standard Members

5 Lies You Tell Yourself to Avoid Starting your New Year’s Resolutions

Today’s question comes from a busy professional: I can’t seem to stay motive past a few weeks on my New Year’s Resolutions. How can I stay motivated in my New Year’s Resolutions? You are not alone. Although many of us make resolutions, only 10% of us actually keep them. Some of the lies we tell ourselves are: 1. I never...

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