Standard Members Archives - Page 81 of 110

Standard Members

Exploring LINQ to Objects

by Joydip Kanjilal

Exploring LINQ to Objects LINQ to Objects allows us to query objects or collections of objects in memory. We use LINQ to Objects in the Object Model or Object Layer of our application In this article, we will cover the following points: Generic collections in C# LINQing generic collections LINQing non generic collections Using LINQ with Reflection Generic Collections in...

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

Improving Your Odds of Landing That Job

by Laura Lee Rose

Improving Your Odds of Landing That Job 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 am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Stephen Wynkoop and I regularly...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Transactional Replication

by Alexander Chigrik

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

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Configuring SQL Server Database Mail Feature

by Basit Aalishan Masood-Al-Farooq

Configuring SQL Server Database Mail Feature Author: Basit A. Farooq You can send e-mail from within stored procedures, functions, and triggers by using SQL Server Database Mail. You can also configure SQL Server Agent Mail to use Database Mail. SQL Server supports SQL Mail for backwards compatibility, but is not recommended for new implementations. Database Mail provides several enhancements over...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

Advice for people who want to do a 180? career change

by Laura Lee Rose

Advice for people who want to do a 180° career change 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– and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Stephen...

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 2

by William Pearson

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 2 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,...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Snapshot Replication

by Alexander Chigrik

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

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

Exploring LinqDataSource Control in ASP.NET – Part 2

by Joydip Kanjilal

Exploring LinqDataSource Control in ASP.NET – Part 2 Ever since the evolution of the .NET Framework, there were always attempts being made to simplify the data access. Although the data source controls in the earlier versions of the framework provided data access and retrieval operations, there were also certain complexities involved in using the controls. LinqDataSource has brought us a...

Already a member? Log in here

Continue Reading →

Oracle Pro Members Standard Members

count and NULLs

by Yuli Vasiliev

count and NULLs The Oracle SQL count function can be used to count either rows or fields in SQL queries. This article provides some examples on using the count function in both simple queries and in those that use aggregate functions and group a result set. Before going any further, you need to prepare your working environment. In particular, you...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

SQL Server Management tools

by Basit Aalishan Masood-Al-Farooq

SQL Server Management tools Author: Basit A. Farooq Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training costs, and poor DBA productivity. To keep up with these new demands of complex enterprise database management solutions,...

Already a member? Log in here

Continue Reading →