Useful undocumented SQL Server 2017 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2017 extended stored procedures. xp_availablemedia This extended stored procedure returns available drives and free space in bytes on these drives. In comparison with xp_fixeddrives, the xp_availablemedia extended stored procedure returns not only the hard drives, but all available...
Standard Members
What Makes Email Marketing Effective?
This question came from a small business owner. What makes email marketing effective? What are the best tips for email marketing success? What is the best sales automation tool for email campaigns? Effective email marketing is done by connecting with your target market or niche group of people. Therefore, you need to clearly articulate your perfect client base. Create a...
Useful Undocumented SQL Server 2017 DBCC Commands (Part 2)
Useful Undocumented SQL Server 2017 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax: DBCC addinstance (objectname, instancename)...
How to Grow Your Business with Minimal Investment
How can I grow my business with minimal investment? I have started my event management services business but I’m not sure how to convert genuine leads without much investment. It’s very easy to create a profitable business today without much investment, especially for event management services. Here are some things that you need to explore for most businesses. · Identify...
Useful Undocumented SQL Server 2017 DBCC Commands (Part 1)
Useful Undocumented SQL Server 2017 DBCC Commands (Part 1) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2017. 1. DBCC CONFIG This command shows the server’s level DS_CONFIG information. The DBCC CONFIG returns the same DS_CONFIG information as the DBCC RESOURCE returns,...
Which Business Should I Focus on First?
This question came from a professional. What kind of business should I focus on first? I plan to create a variety of companies from Construction contracting, service, and manufacturing as well. I’m just not sure which to do first or how to. Any advice and feedback are more than helpful. If you do not have a solid business plan, that...
Useful SQL Server 2017 trace flags
Useful SQL Server 2017 trace flags There are 3 types of trace flags in SQL Server 2017: query trace flags global trace flags session trace flags Query trace flags are active for the context of a specific query. A global trace flag is enabled for the entire time SQL Server 2017 service is running and is applied to each of...
Tips to work with SQL Server 2017 alerts
Tips to work with SQL Server 2017 alerts SQL Server 2017 writes the events into the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so perform the defined response. Alerts can be used to execute a SQL...
10 Things You Can Do to Create Traffic to Your Website (Part 2)
This question came from a professional. Who can help me create traffic to my website? I need someone to help me with marketing my website. I have a website designer who is working for me but looking for more advise or recommendations. This is a continuation from the initial 10 Things you can do to create traffic to your website...
Tips for using SQL Server 2017 distributed queries
Tips for using SQL Server 2017 distributed queries Try to avoid using the TOP clause in the distributed queries. Because distributed queries that involve the TOP clause are never delegated to an OLE DB provider and are always evaluated locally, you should avoid using the TOP clause in the distributed queries to increase the local SQL Server performance. The first...