Standard Members

Pro Members SQL Server Standard Members

Tips for using SQL Server 2014 file and filegroups

by

Tips for using SQL Server 2014 file and filegroups Set the reasonable sizes for the database and transaction log. First of all, before database creation, you should estimate how large your database will be. To estimate the reasonable database size, you should estimate the size of each table individually, add some additional space (10-20%) and then add the values obtained....

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

Querying Financial Data From Yahoo! Finance From Within Oracle Database

by

Querying Financial Data From Yahoo! Finance From Within Oracle Database By Yuli Vasiliev As you no doubt know, Yahoo! Finance is a web site that provides financial information, including stock quotes, stock exchange rates, international market data, and much more. The article illustrates how you can receive financial data in XML format from Yahoo! Finance, issuing queries directly from within...

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

Microsoft SQL Server security best practices checklist – Part -2

by

Microsoft SQL Server security best practices checklist – Part – 2 Author: Basit A. Farooq Editor’s Note: This is the second part of my two part article series on SQL Server security best practices. SQL Server Administration Avoid managing SQL Server instances using sa or any other SQL login account that has been granted CONTROL SERVER permission, or is a...

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

What is the best way to handle negative online customer feedback?

by

What is the Best Way to Handle Negative Online Customer Feedback? 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

General facts of SQL SERVER – part 1

by

General facts of SQL SERVER – Part 1 Introduction:- The cutting – edge and modest atmosphere of each and every business necessities a wide – ranged, protected, trustworthy plus a fruitful information podium for its commercial systems. The SQL SERVER Database Management System offers this podium which permits constructing as well as handling information systems. Additionally SQL SERVER Database Management...

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 2014 Merge Replication Optimization Tips (Part 2)

by

SQL Server 2014 Merge Replication Optimization Tips (Part 2) Do not forgive to script your replication configuration. Because scripting the replication configuration is a key part of any disaster recovery plan for a replication topology, you should script your replication configuration from the replication wizards or from the Replication folder in Microsoft SQL Server Management Studio. If you do not...

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

Microsoft SQL Server security best practices checklist – Part -1

by

Microsoft SQL Server security best practices checklist – Part -1 Author: Basit A. Farooq Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data such as customer information and other confidential business data. Because of this, it is not wrong to say that databases such as SQL Server are 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 →
Development Pro Members Standard Members

Eating lunch at desk is a lazy man’s solution

by

Eating Lunch at Your Desk is a Lazy Man’s Solution 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...

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

Using the SSIS Merge Join to Synchronize Tables – Part 2

by

November 2014 Using the SSIS Merge Join to Synchronize Tables – Part 2 By Rocco Mastrangelo This article is Part 2 of a two-part series that describes how to keep two database tables synchronized using the Merge Join transform within Microsoft SQL Server Integration Services (SSIS). This solution is particularly useful for any ETL process that requires refreshing a target...

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 2014 Merge Replication Optimization Tips (Part 1)

by

SQL Server 2014 Merge Replication Optimization Tips (Part 1) Create an index on each of the columns that is used in the filter’s WHERE clause. If you do not use indexes on columns used in filters the SQL Server must perform a table scan, which can results in performance degradation. Set the "Maximize Throughput for Network Applications" option. This can...

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 … 62 63 64 65 66 … 110