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...
Standard Members
Tips for using Integration Services in SQL Server 2014 (Part 1)
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...
Transact-SQL Subqueries
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...
Should you optimize your career for learning or responsibility?
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...
Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 3
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...
SQL Server 2014 Clustering Optimization Tips
SQL Server 2014 Clustering Optimization Tips Create a cluster resource group before installing SQL Server 2014 clustering. Avoid installing SQL Server 2014 into the default cluster group. To create cluster resource group dedicated for SQL Server 2014, you can use the Cluster Administrator tool. You should also place all the shared array drives that will be used by SQL Server...
SQL Server — Importing and exporting flat file data
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...
How do you recover from a mistake in an email blast?
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...
Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 2
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...
Tips for using linked servers in SQL Server 2014
Tips for using linked servers in SQL Server 2014 Try to avoid using distribution transaction or minimize it using. Because distribution transactions incur more overhead than general transactions, avoid using distribution transactions, whenever possible. One of the first steps to optimize remote queries against a SQL Server 2014 linked server is rewrite queries so, that the most work will be...