SQL Server

Pro Members SQL Server Standard Members

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,...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Editorials SQL Server

A New Variable in the RFQ Process – (Recognizable) Brand Names

Some interesting things happening in the process of RFQs and software platform analysis prior to purchase.  More and more we’ve been seeing people inquiring about infrastructure.   It’s not like they didn’t care before, certainly they did.  But now, it’s about two different “levels” of infrastructure.  The first is functionality.  We’ll see a lot of questions about how things are set […]

Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

10 Things you can do to create traffic to your website (Part 1)

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. It is great that you are getting a professional website designer to work on your website. There are...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2017 Integration Services (Part 3)

Tips for using SQL Server 2017 Integration Services (Part 3) Use breakpoints when you debug the packages. SQL Server 2017 Integration Services provide the ability to set breakpoints on packages, containers, and task events. Using breakpoints can help you debug your packages and find potential problems during the testing before transferring to production environments. Consider deploying a cache file together...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

7 Things IT Professionals Can Do to Increase Their Exposure on Social Media

What can IT professionals do to increase their exposure on social media? This is a great question. Here are 7 thing an IT professional can do to increase their exposure on social media. Craft your 30 second elevator pitch Create your individual website Create valuable shareable content Post your content on your website, and business social media pages Start participating...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register