Pro Members

Pro Members SQL Server Standard Members

SQL Server Interview Questions and Answers for DBAs and Developers; (Part-1)

by

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-1) Author: Basit A. Farooq In this article, I will outline interview questions you should ask to Junior SQL Server DBA or developer. These question will help you to assess the basic knowledge and skills of the candidates in relation to SQL Server product and database design. Question Difficulty...

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

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 4

by

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 4 This PART has the following example for better understanding of the code that we had already discussed in the last PART – 4 of this series (Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server). Further modification or improvement of the code can be done accordingly to 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
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using Integration Services in SQL Server 2014 (Part 1)

by

Tips for using Integration Services in SQL Server 2014 (Part 1) Try to avoid SSIS lookups. Because SSIS lookups slow down performance, try to use the Transact-SQL statements to perform the same functions. If you need to combine data rows from multiple upstream data flow components, you can use the Union All, Merge, and Merge Join transformations. These transformations make...

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

Transact-SQL Subqueries

by

Transact-SQL Subqueries You use subqueries to break a query into logical steps. By using subqueries, you can often solve a complex data retrieval or modification problem with a single statement. You use subqueries in situations in which a query depends on the results of another query. Subqueries typically aren’t the most efficient way to retrieve data. Whenever possible, it 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
Continue Reading →
Development Pro Members Standard Members

Should you optimize your career for learning or responsibility?

by

Should you optimize your career for learning or responsibility? Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they 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
Continue Reading →
Pro Members SQL Server Standard Members

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 3

by

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 3 The PART 3 is the vital and core part of this “Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server” series. Each and every part of the code has been described in details for better understanding; this part of the article has been followed by an additional PART...

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

SQL Server — Importing and exporting flat file data

by

Importing and Exporting Flat File Data Author: Basit A. Farooq File export Many companies have periodic requirements for flat files generated from database sources. You can use the SQL Server Import and Export Wizard to define the export SQL Server Integration Services package once and reuse the file as long as the export parameters don’t change any time. This means...

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

How do you recover from a mistake in an email blast?

by

How Do You Recover from a Mistake in an Email Blast? Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if...

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

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 2

by

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 2 What is Web Service? The web service is a group of utilities which offer programmable reasoning castoff by customer’s systems across the internet. The web services are grounded on the Service Oriented Architecture (SOA) plus interact by means of Simple Object Access Protocol (SOAP). Simple Object Access Protocol...

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 →
1 … 58 59 60 61 62 … 110