Standard Members

Development Pro Members Standard Members

Exploring LINQ to DataSets

by

Exploring LINQ to DataSets DataSets are in-memory representations of data. In this article, we will explore the following: Understanding Typed and UnTyped DataSets Populating a Typed DataSeta Working with LINQ to DataSet Retrieving changes made to the DataSet Working with Typed DataSets using LINQ to DataSet Pre-requisites Note that to work with the code examples given in this article, you...

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

10 Career Management Tips forTelecommuters

by

10 Career Management Tips for Telecommuters Hello, this is Laura Lee Rose – author of books TimePeace: Making peace with time and the Book of Answers: 105 Career Critical Situations– and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve Wynkoop and I talk a lot about designing and managing...

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

Possible ways to secure SSIS Packages

by

Possible ways to secure SSIS Packages Author: Basit A. Farooq In this article, I’ll first give an overview of SQL Server Integration Services (SSIS) security. Then I will talk about the different package protection levels and roles. Finally, I will talk about how to sign the SSIS packages. Overview of SSIS Packages Security Whether you are developing a SSIS package...

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 indexes in SQL Server 2012

by

Tips for using indexes in SQL Server 2012 Keep your indexes as narrow as possible. Because each index takes disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Check that index you tried to create does not already...

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

Working with Operators in LINQ – Part 2

by

Working with Operators in LINQ – Part 2 Element Operators Element operators allow you to retrieve elements from a sequence at specific locations. First The First operator returns the first element in a sequence. AdventureWorksDataContext adc = new AdventureWorksDataContext(); Product query = adc.Products.AsEnumerable().First(); Console.WriteLine(String.Format("ID = {0},tName = {1}",query.ProductID,query.Name)); The example below uses a predicate in the First operator. AdventureWorksDataContext adc...

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: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 2

by

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 2 This is the second article of a new, SSWUG – exclusive series, DAX and PowerPivot Essentials. As we noted in Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1,the primary focus of this series will be an introduction to PowerPivot for...

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

10 Hidden Time Wasters That You Might Be Doing

by

10 Hidden Time Wasters That You Might Be Doing Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve Wynkoop and I talk a lot about designing and managing our professional careers on a weekly...

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

Back to basics: Transact-SQL programming fundamentals – (Part 2)

by

Back to basics: Transact-SQL programming fundamentals – (Part 2) Author: Basit A. Farooq Editor’s Note: In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL variables. In this part, you will learn about Transact-SQL control-of-flow language, including BEGIN…END, IF…ELSE, CATCH, WHILE, BREAK, CONTINUE, RETURN, and WAITFOR. Control-of-Flow Transact-SQL provides special...

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 designing SQL Server 2012 tables

by

Tips for designing SQL Server 2012 tables Try to reduce the number of columns in a table. The fewer the number of columns in a table, the less space the table will use, since more rows will fit on a single data page, and less I/O overhead will be required to access the table’s data. Use char/varchar columns instead of...

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

Working with Operators in LINQ – Part 1

by

Working with Operators in LINQ – Part 1 In this series of articles we will discuss on operators in LINQ. In this part we will explore the aggregation operators and conversion operators. Aggregation Operators Count Count operator counts the number of elements in the sequence. A check is being performed if the source of type T implements the ICollection<T> interface...

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 … 84 85 86 87 88 … 110