Standard Members

Pro Members SQL Server Standard Members

SQL Server 2014: Stored Procedures

by

SQL Server 2014: Stored Procedures Author: Basit A. Farooq Introduction A stored procedure is a named, precompiled collection of SQL statements, variables, and control-of-flow statements. You can create stored procedures that accept input parameters and return values and status information. Typical uses for stored procedures include automating repetitive tasks, ensuring tasks are performed consistently, enhancing application and user access security...

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 data types in SQL Server 2014

by

Tips for using data types in SQL Server 2014 Use Date/Time data types to store date/time information separately. In SQL Server 2014 you can store the date and time information separately. For example, if you need to work with date data only, use the Date data type instead of datetime or smalldatetime to optimize storage space and simplify date modifications...

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

RDBMS Concept In Normalization & De-normalization of Data — Part 4

by

RDBMS Concept In Normalization & De-normalization of Data – Part 4 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning the Practical Reliance of Normalization, few rules for converting the tables from one Normal Form to another Normal Form and then focusing on what is De-Normalization?”, here is the article....

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 Replication – Part 3

by

SQL Server 2014 Replication – Part 3 Author: Basit A. Farooq Editor’s note: In this third part of my SQL Server 2014 Replication article series, you’ll learn about working and configuration of Transactional replication. You’ll also learn about working of Merge replication. Transactional replication Transactional replication sends incremental changes and transactions to the Subscribers. Transactional replication gives you a shorter...

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

Advanced Features in LINQ to SQL: Part 2

by

Advanced Features in LINQ to SQL: Part 2 In the preceding article in this series we explored deferred execution concepts in LINQ and how we can invoke stored procedures and functions using LINQ. In the concluding part of this series, we will examine the following points: ü Handling Data concurrencies Managing Transactions Handling Data Concurrencies Concurrency in database arises when...

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

RDBMS Concept In Normalization & De-normalization of Data — Part 3

by

RDBMS Concept In Normalization & De-normalization of Data – Part – 3 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning diverse Normal Forms (3NF and BCNF)”, here is the article. Defining Different Normal Forms:- The Third Normal Form (3NF):- A database table is supposed to be in Third Normal...

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

Accessing Google Searches From Within Oracle Database

by

Accessing Google Searches From Within Oracle Database By Yuli Vasiliev This article explains how you might use Google search results in programmatic ways, consolidating those results with database data. In particular, the article covers how you might use the Google Web Search API, accessing it from within SQL queries issued in Oracle Database. It is interesting to note that although...

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’s in a Job Title and What Does It Really Mean?

by

What’s in a Job Title and What Does It Really Mean? 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 →
Development Pro Members Standard Members

Advanced Features in LINQ to SQL: Part 1

by

Advanced Features in LINQ to SQL: Part 1 In this series of articles, we will cover the following points: ü U Using Stored Procedures in LINQ to SQL Deferred execution in LINQ to SQL Calling SQL Functions Handling Data concurrencies Managing Transactions Using Stored Procedures in LINQ to SQL Stored procedure is a compiled set of SQL statements referred by...

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 bulk copy in SQL Server 2014

by

Tips for using bulk copy in SQL Server 2014 Use native mode bulk copy whenever possible. Because native mode bulk copies are generally faster than character mode, you should use native mode bulk copy whenever possible. Note. Now the bcp utility supports native data files compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2,...

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 … 66 67 68 69 70 … 110