How to Bring the Best Out of Your 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...
Standard Members
SQL Server 2012 DBCC Optimization Tips (Part 2)
SQL Server 2012 DBCC Optimization Tips (Part 2) Consider using the NOINDEX option with DBCC CHECKDB and DBCC CHECKTABLE command. This option specifies that intensive checks of nonclustered indexes for user tables should not be performed. Using the NOINDEX option decreases the execution time and should be used whenever possible. If you need to run DBCC CHECKDB or DBCC CHECKFILEGROUP...
SQL Server 2005/2008/2008 R2: HTTP endpoints
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...
Using SharePoint to Automate Workflows: Part IV
In the preceding three articles in this series we had discussed the development of Sequential workflows in SharePoint Server. In this article we introduce State Machine Workflows with SharePoint Server and briefly highlight the differences between the two types of workflows that are possible in SharePoint Server. In the next few articles of this series we will be discussing State...
How Do You Know When It is Time to Ask for a Raise?
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...
SQL Server 2012 DBCC Optimization Tips (Part 1)
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...
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 3
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,...
SharePoint Server Basics for Everyone-Site Publishing—Part II
SharePoint Server Basics for Everyone-Site Publishing—Part II The site publishing features of SharePoint Server can be accessed from Publishing Portal Site Template or Enterprise Wiki Template. The former is highly structured and enables page layout control, authoring controls and define publishing schedules. The Enterprise Wiki is less structured and permits a more informal kind of content management process. The Site...
Why Are Bosses Happier Than Non-Managerial Workers?
Why Are Bosses Happier Than Non-Managerial Workers? 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 more profitable and have time to...
Types of Join in SQL Server – (Part 1)
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...