Troubleshooting SQL Server 2012 Log Shipping If you have problems with SQL Server 2012 log shipping, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 log shipping bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Standard Members
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1
DAX and PowerPivot Essentials: More about Calculated Columns and Measures, Counting and Filtering, Part 1 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,...
3 Sure-Fire Ways to Screw Up a Project
3 Sure-Fire Ways to Screw Up a Project 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 interview...
Some tips to use System Monitor with SQL Server 2012
Some tips to use System Monitor with SQL Server 2012 Don’t monitor counters you don’t need. The more counters you monitor, the more overhead that is required to perform the monitoring. So, to boost the System Monitor performance, you should monitor only those counters that you need. Stop all screen-saver and anti-virus programs on a computer you run System Monitor....
Grid computing vs cloud computing
Grid Computing V.S. Cloud Computing Let us look at the definitions of the two terms and understand the concepts: Grid computing is a collection of computer resources that are loosely coupled, heterogeneous and geographically dispersed. It is a distributed system that works well for non-interactive workloads. Computing resources can be provisioned (from a predefined resource pool) as a utility that...
A Bird’s Eye View of the LINQ Library – Part 1
A Bird’s Eye View of the LINQ Library – Part 1 In this series of articles we will explore the LINQ library. In this firrst part of this series of articles, we will cover the following points:- The System.Linq Namespace The System.Data.Linq Namespace Exceptions in the System.Data.Linq Namespace Enumerations in the System.Data.Linq Namespace Working with the LINQ Library The LINQ...
How to Deal with Competition in the Workplace
How to Deal with Competition in the Workplace Hello, this is Laura Lee Rose – author of the 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 professional development, career management, time management, and work-life balance strategies. Today we are going to talk...
Exposing Oracle Database Data Via Oracle XML DB HTTP Server
Exposing Oracle Database Data Via Oracle XML DB HTTP Server By Yuli Vasiliev If you have ever used Oracle XQuery, you already know that this tool is really good when it comes to accessing external sources and bringing data extracted from them into your Oracle database. Sometimes, however, you may need to expose data stored in your Oracle database to...
Troubleshooting SQL Server 2012 System Stored Procedures
Troubleshooting SQL Server 2012 System Stored Procedures If you have problems with SQL Server 2012 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 system stored procedures bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack....
Using SharePoint to Automate Workflows Part I
Using SharePoint to Automate Workflows Part I Every business has processes and procedures. It is the way in which work is accomplished, tracked and managed. The process may be sequential or non-sequential. It has to be mapped if it must be automated. SharePoint server allows users to map the process sequentially or non-sequentially (State machine). We shall explore, in this...