Viewing the SQL Server Procedure Cache with DMVs

In the previous blog, we took a quick look at query plan caching using the classic but still serviceable syscacheobjects view. A serious journey of exploration into the SQL procedure cache must, however, begin with the dynamic management view sys.dm_exec_cached_plans. While this view does provide us with some interesting information in its own right, the […]
Read More ›

Use a PMI Analysis to Encourage Critical Thinking

A participant in a critical thinking class I taught recently suggested a solution to a problem I’d posed to the group. “Let’s do a PMI analysis,” I suggested, expecting the class to be familiar with the tool. None were. The tool can be a very productive way to frame a discussion. What is a PMI […]
Read More ›

Techniques to Help You Manage Stakeholder Expectations

When we talk about ‘stakeholders’ there are many, many groups that fall into this category. For example colleagues, customers, employees, shareholders, suppliers, the media, regulators, competitors and special interest groups. There are too many to manage all of them individually, so it’s helpful to have some tools, techniques, and processes to help you prioritize and […]
Read More ›

Understanding Cyber Security: Confidentiality Becomes Privacy

In early August I made the heretical suggestion of replacing “CIA” with “PAR”, as in Privacy, Accuracy, and Reliability. Grim talk about “The CIA Triad” suggests to many users that it is nothing for them. But we can’t have information security without user understanding and involvement! We talk about CIA in Learning Tree’s System and […]
Read More ›

Design Thinking: The New Paradigm for Building Applications

A confluence of business trends and development best practices is changing the way developers need to think about building applications. For want of a better term, the mindset that most software developers follow when building applications might be called ‘systems thinking’: Design a database that holds the data the company needs, design the software components […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.