Standard Members Archives - Page 77 of 110

Standard Members

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

by William Pearson

DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 4 After gaining an overview and performing the preparation for the four-parts of this article in Part 1, we introduced the COUNTROWS() function in Part 2. Then, in Part 3, we explored another DAX function, FILTER(). As we shall see in this, Part 4, of our...

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

Diving deep into SQL Server Integration Services Transactions

by Basit Aalishan Masood-Al-Farooq

Diving deep into SQL Server Integration Services Transactions Author: Basit A. Farooq In this article, you learn how to implement transactions in a SQL Server Integration Services package. What are transactions? A transaction is a logical unit of work made up of one or more tasks. The concept of transaction usually applies to a relational database such as those in...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

Are your meetings a waste of time?

by Laura Lee Rose

Are Your Meetings a Waste of Time? Hello, this is Laura Lee Rose. I am a speaker and author. My background is 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 don’t have time to...

Already a member? Log in here

Continue Reading →

Pro Members SharePoint Standard Members

Using SharePoint Server to Automate Workflows Part VI

by Vanitha Vaidialingam

Using SharePoint Server to Automate Workflows Part VI Remember SharePoint 2013 comes with a SharePoint Designer and Visual Studio 2012 is an alternative to creating your workflows in the designer subject to the limitations we discussed in the previous article. Let us quickly review the features of Visual Studio 2012 with specific reference to SharePoint 2013. Workflows in SharePoint 2013...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2012 DBCC Commands (Part 2)

by Alexander Chigrik

Useful Undocumented SQL Server 2012 DBCC Commands (Part 2) DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency of a database, although they are also used for a variety of miscellaneous tasks. Note, the command: DBCC TRACEON (3604) is issued before some of the following DBCC examples in order...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Why Learning Fluent SQL Will Provide More Business Opportunities

by Camille McClane

Why Learning Fluent SQL Will Provide More Business Opportunities If your business deals with records, whether of contacts, inventory or other business needs, then you know the value of organizing those records for easy access. If you use a Structured Query Language (SQL) database, then you have already positioned yourself for both simplicity and the expansion of your business. SQL...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Implementing Checkpoints – To restart SQL Server Integration Services packages from the point of failure

by Basit Aalishan Masood-Al-Farooq

Implementing Checkpoints – To restart SQL Server Integration Services packages from the point of failure Author: Basit A. Farooq An SQL Server Integration Services package often includes tasks that can take a long time to run. If the package fails in the middle of execution, you may need to repeat these tasks, which can be very slow and time-consuming. To...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

Taking over a new department with a weak team

by Laura Lee Rose

Taking Over a New Department with a Weak Team Hello, this is Laura Lee Rose. I am a speaker and author. My background is 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 don’t have...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2012 DBCC Commands (Part 1)

by Alexander Chigrik

Useful Undocumented SQL Server 2012 DBCC Commands (Part 1) DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency of a database, although they are also used for a variety of miscellaneous tasks. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in...

Already a member? Log in here

Continue Reading →

Pro Members SharePoint Standard Members

Using SharePoint to automate workflows Part V

by Vanitha Vaidialingam

This is the second article in the State Machine Workflow series and the fifth in the series titled Using SharePoint to automate Workflows. In this article we shall briefly examine the tools that are available to the workflow developer who plans to use SharePoint Server 2013. SharePoint 2013 comes with two workflow development platforms—the Workflow Manager and Visual Studio 2012....

Already a member? Log in here

Continue Reading →