SQL Server

Pro Members SQL Server Standard Members

SQL Server 2005/2008/2008 R2: HTTP endpoints

by

SQL Server 2005/2008/2008R2: HTTP endpoints Author: Basit A. Farooq You can expose functionality as a Web service to allow applications to execute stored procedures, batch files, and scalar-valued functions using a Simple Object Access Protocol (SOAP) request. SOAP is a standard that calls methods on objects using XML and HTTP. Important Note: HTTP Endpoints feature has been deprecate in SQL...

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

How Do You Know When It is Time to Ask for a Raise?

by

How Do You Know When It is Time to Ask for a Raise? Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time and The Book of Answers: 105 Career Critical Situations. I help busy professionals and entreprenurs create effective systems so that they can comfortably delegate to others, be...

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 2012 DBCC Optimization Tips (Part 1)

by

SQL Server 2012 DBCC Optimization Tips (Part 1) Before executing DBCC CHECKDB command, run this command with the ESTIMATEONLY option to estimate the tempdb space needed for CHECKALLOC and CHECKTABLE. So, you can calculate the tempdb database size and run the DBCC CHECKDB command without performance degradation. When this option is used, the actual database check is not performed. 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
Continue Reading →
Pro Members SQL Server Standard Members

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3

by

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3 In the charter article of this series, DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, we introduced the powerful PowerPivot / DAX combination, noting that this add-on to Microsoft Office Excel 2010 (embedded, and only needing to be enabled,...

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

Types of Join in SQL Server – (Part 1)

by

Types of Join in SQL Server – Part 1 Author: Basit A. Farooq In this two part article series, I will discuss different types of joins available in SQL Server. You use a join to combine data from different tables into a single result set. Joins most commonly use foreign key relationships. Some important points about joins include: Joins are...

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

Troubleshooting SQL Server 2012 Bulk Copy Problems

by

Troubleshooting SQL Server 2012 Bulk Copy Problems If you have problems with SQL Server 2012 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At 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

SQL Server: Database Design Basics – (Part 2)

by

SQL Server: Database Design Basics – (Part 2) Author: Basit A. Farooq In this article, you will learn about table design, entities and attributes and their relation to the tables and columns. You will also learn how to enforce data integrity through domain integrity, entity integrity, referential integrity, and user-defined integrity, and how to use primary keys, unique constraints and...

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

Troubleshooting SQL Server 2012 XML Problems

by

Troubleshooting SQL Server 2012 XML Problems If you have problems with SQL Server 2012 XML, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server service pack. Because some SQL Server 2012 XML bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...

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: Database Design Basics – (Part 1)

by

SQL Server: Database Design Basics – (Part 1) Author: Basit A. Farooq In this article, you will learn about database design concepts. The database design concepts discussed in this article focus almost exclusively on OLTP requirements. OLAP design is beyond the scope of this article. Database design process According to Wikipedia, the term database design can be used to describe...

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

Troubleshooting problems with linked servers in SQL Server 2012

by

Troubleshooting problems with linked servers in SQL Server 2012 If you have problems with linked servers in SQL Server 2012, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 linked servers bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...

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 … 91 92 93 94 95 … 115