Standard Members

Pro Members SQL Server Standard Members

How to Give Your Friends Advice Without Making Them Mad

A busy professional asks a question regarding his co-working relationships. How to give your friends and co-workers advice without making them mad. When is it ok to give advice? Can it ever be unsolicited? What should you do if a co-worker thinks you’re in their business too much? The risk of giving advice to friends and co-workers is that they...

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

Tips for using bulk copy in SQL Server 2017

Tips for using bulk copy in SQL Server 2017 Consider using BULK INSERT to insert data from files stored in Azure Blob storage. Beginning with SQL Server 2017 BULK INSERT command enable access data directly from a file specified as CSV format, and from files stored in Azure Blob storage through the new BLOB_STORAGE option of EXTERNAL DATA SOURCE. Use...

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

A Holistic View of Database Management System (DBMS) – Part 10

Third (3rd) Normal Form (3NF) For a table or relation to be in Third (3rd) Normal Form, it should be in Second (2nd) Normal form as well as the subsequent should be fulfills: · Certainly no non main column or attribute is transitively dependent on prime key (PK) attribute or column. · For any important functional dependency, A → B,...

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 Recover from a Bad Interview

A busy professional asks a question regarding his career. How to recover from a bad interview? Not every interview goes as planned. How can a candidate recover from a bad interview? What steps can they take to improve their standing with the hiring manager? If they blew their shot at that job, what can they do to ensure that they...

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

Tips for using Very Large Databases in SQL Server 2017

Tips for using Very Large Databases in SQL Server 2017 Create a user-defined filegroup and create some tables in it to run maintenance tasks (backups, DBCC, update statistics, and so on) against these tables. You can place a table in its own filegroup and can backup and restore only this table. So you can group user objects with similar maintenance...

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

A Holistic View of Database Management System (DBMS) – Part 9

Functional Dependency The functional dependency (FD) is a group of constrictions among two (2) columns or attributes in a table or relation. Functional dependency states that when two (2) rows or tuples is having identical data values for attributes or columns C1, C2,…, Cn, then those two (2) rows or tuples should have to have identical data values for attributes...

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

When Do You Need a New Career vs. Just a New Job?

When do you need a new career vs. just a new job? When you’re burned out in your current job, how do you know if it’s time for a new career vs. just a new job? What questions should you ask yourself? What criteria should you be thinking about? This is a question that everyone should ask – even before...

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

Tips for using SQL Server 2017 Reporting Services

Tips for using SQL Server 2017 Reporting Services SQL Server 2017 Reporting Services (SSRS) is no longer available to install through SQL Server 2017 setup. You can download SSRS 2017 at here: https://www.microsoft.com/en-us/download/details.aspx?id=55252 Consider using the Microsoft Excel rendering extension. SQL Server 2017 Reporting Services supports the Reporting Services Excel rendering extension. This extension renders a report as an Excel...

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 Can I Improve My Closing Ratio in a Very Competitive Market?

A busy professional asks a question regarding employer/employee relationships. How can I improve my closing ratio in a very competitive market? We are losing too many potential jobs in the very competitive exterior home improvement field. How can I improve my closing ratio? This question is as common as it is complicated. It also isn’t isolated to exterior home improvement...

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 AlwaysOn availability group in SQL Server 2016

Troubleshooting problems with AlwaysOn availability group in SQL Server 2016 If you have problems with AlwaysOn availability group 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 AlwaysOn availability group’s bugs were fixed in SQL Server service packs, you should install the latest...

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