Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL's roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects. Microsoft Data Platform MVP Itzik Ben-Gan shows you how to: Review core SQL concepts and its mathematical roots Create tables and enforce data integrity Perform effective single-table queries by using the SELECT statement Query multiple tables by using joins, subqueries, table expressions, and set operators Use advanced query techniques such as window functions, pivoting, and grouping sets Insert, update, delete, and merge data Use transactions in a concurrent environment Get started with programmable objects-from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL

    Cases, examples and problems from a variety of project types are used to illustrate the text.

    This jargon-free Missing Manual shows you how to use WordPress and its themes, plug-ins, and widgets to build just about any website you can imagine, from a classy blog to a basic e-commerce site.The important stuff you need to know:Create a blog. Get a free WordPress.com account, choose the right theme, and start publishing content.Build a website. Produce a professional-looking business site by customizing a WordPress theme.Add features. Choose from thousands of WordPress widgets and plug-ins to extend your site’s features.Mix in multimedia. Include slideshows, video clips, webcasts, podcasts, and music players.Involve your readers. Let readers leave comments, contribute to your site, and carry on a dialog.Build an audience. Learn search-engine optimization, measure your reader’s favorite pages, and publicize your site.Create a community. Use social media tools such as “Like” and sharing buttons, and provide RSS feeds of your posts.

    It describes the Disciplined Agile Delivery (DAD) process decision framework and then works through a case study describing a typical agile team’s experiences adopting a disciplined agile approach. The book describes how the team develops the first release of a mission-critical application while working in a legacy enterprise environment. It describes their experiences from beginning-to-end, starting with their initial team initiation efforts through construction and finally to deploying the solution into production. It also describes how the team stays together for future releases, overviewing their process improvement efforts from their Scrum-based beginnings through to a lean continuous delivery approach that fits in with their organization’s evolving DevOps strategy. The DAD framework is a hybrid of existing methods such as Scrum, Kanban, Agile Modeling, SAFe, Extreme Programming, Agile Data, Unified Process and many others. DAD provides the flexibility to use various approaches and plugs the gaps not addressed by mainstream agile methods. In a nutshell, DAD is “pragmatic agile.” DAD describes proven strategies to adapt and scale your agile initiatives to suit the unique realities of your enterprise without having to figure it all out by yourself. Here’s an overview of what each chapter covers: * Chapter 1: Introduction. This chapter provides a quick overview of the book and a brief history of Disciplined Agile. * Chapter 2: Reality over Rhetoric. This chapter explores several common myths about DAD and more importantly disproves them. * Chapter 3: Disciplined Agile Delivery in a Nutshell. This chapter provides a brief yet comprehensive overview of the DAD framework. * Chapter 4: Introduction to the Case Study. This chapter introduces us to the team, describes the market opportunity that they hope to address, and describes the environment in which they’re working. * Chapter 5: Inception. The team’s initiation effort includes initial requirements modeling and planning with their stakeholders in a streamlined manner, initial architecture modeling, setting up their physical work environment, setting up the start of their tooling infrastructure, initial risk identification, and finally securing stakeholder support and funding for the rest of the first release. * Chapters 6 through 10: Construction. These chapters each describe a single Construction iteration, sharing the team’s experiences during each of those two-week timeboxes. * Chapter 11: Transition. The two-week transition phase focuses on final testing and fixing, training the support/help-desk staff, finishing a few short end-user “how to” videos, and deploying the solution into production. * Chapter 12: Future Releases. This chapter overviews the team’s improvement efforts over the next few releases, describing how they evolve from the agile Scrum-based lifecycle to a leaner approach and eventually to continuous delivery. * Chapter 13: Closing Thoughts. This chapter overviews the disciplined agile resources that are available to you. * Appendix: The Disciplined Agile IT Department. This short appendix overviews our ongoing work on the Disciplined Agile framework to address the full scope of an IT department. At 102 pages, you should find this book to be a quick, informative read.

    There are updates throughout the book as well. These take into account important advances in cognitive psychology and the science of design while confirming and extending the book's basic thesis: that a physical symbol system has the necessary and sufficient means for intelligent action. The chapter "Economic Reality" has also been revised to reflect a change in emphasis in Simon's thinking about the respective roles of organizations and markets in economic systems."People sometimes ask me what they should read to find out about artificial intelligence. Herbert Simon's book The Sciences of the Artificial is always on the list I give them. Every page issues a challenge to conventional thinking, and the layman who digests it well will certainly understand what the field of artificial intelligence hopes to accomplish. I recommend it in the same spirit that I recommend Freud to people who ask about psychoanalysis, or Piaget to those who ask about child psychology: If you want to learn about a subject, start by reading its founding fathers." -- George A. Miller

    Unfortunately, reliable guidance on Agile management has been scarce indeed. Now, leading Agile manager Jurgen Appelo fills that gap, introducing a realistic approach to leading, managing, and growing your Agile team or organization. Writing for current managers and developers moving into management, Appelo shares insights that are grounded in modern complex systems theory, reflecting the intense complexity of modern software development. Appelo's Management 3.0 model recognizes that today's organizations are living, networked systems; and that management is primarily about people and relationships. Management 3.0 doesn't offer mere checklists or prescriptions to follow slavishly; rather, it deepens your understanding of how organizations and Agile teams work and gives you tools to solve your own problems. Drawing on his extensive experience as an Agile manager, the author identifies the most important practices of Agile management and helps you improve each of them. Coverage includes - Getting beyond "Management 1.0" control and "Management 2.0" fads - Understanding how complexity affects your organization - Keeping your people active, creative, innovative, and motivated - Giving teams the care and authority they need to grow on their own - Defining boundaries so teams can succeed in alignment with business goals - Sowing the seeds for a culture of software craftsmanship - Crafting an organizational network that promotes success - Implementing continuous improvement that actually works Thoroughly pragmatic-and never trendy-Jurgen Appelo's Management 3.0 helps you bring greater agility to any software organization, team, or project.

    Starting with Alexander Graham Bell's revolutionary "harmonic telegraph," by the middle of the twentieth century the phone system had grown into something extraordinary, a web of cutting-edge switching machines and human operators that linked together millions of people like never before. But the network had a billion-dollar flaw, and once people discovered it, things would never be the same.Exploding the Phone tells this story in full for the first time. It traces the birth of long-distance communication and the telephone, the rise of AT&T's monopoly, the creation of the sophisticated machines that made it all work, and the discovery of Ma Bell's Achilles' heel. Phil Lapsley expertly weaves together the clandestine underground of "phone phreaks" who turned the network into their electronic playground, the mobsters who exploited its flaws to avoid the feds, the explosion of telephone hacking in the counterculture, and the war between the phreaks, the phone company, and the FBI.The product of extensive original research, Exploding the Phone is a ground-breaking, captivating book.

    Polya, How to Solve It will show anyone in any field how to think straight. In lucid and appealing prose, Polya reveals how the mathematical method of demonstrating a proof or finding an unknown can be of help in attacking any problem that can be reasoned out--from building a bridge to winning a game of anagrams. Generations of readers have relished Polya's deft--indeed, brilliant--instructions on stripping away irrelevancies and going straight to the heart of the problem.

    

    In this e-book you will learn what exactly is needed to run a successful Design Thinking Workshop which is fun and at the same time generates great results. In this e-book Pauline Tonhauser, founder of designthinkingcoach.de, shares her best practices.

    

    Pattie’s Personal Narrative is a prime source for the history of the Southwest during the 1820s. He, and a group of fur trappers, set out on a journey from St. Louis to California and back. After Jed Smith’s trip this journey, which began in 1824, is the second known expedition to California. This remarkable book records an eyewitness account of what the West was like before the great swathes of migration occurred. Pattie’s book fully explores the dangers of life as a trapper in the wilderness of the far west, including during one episode after Pattie and a group of French trappers were attacked and only three of them survived. Personal Narrative provides fascinating insight into the earliest clashes that were beginning to occur between citizens of the travelers from the east, Native Americans and Mexicans as United States began its great westward expansion. Yet, Pattie also demonstrates how there was great cooperation between groups, for example when he aided Mexicans, Native Americans, missionaries and settlers with smallpox vaccinations. It is essential reading for anyone interested in finding out more about the Old West and life of this fascinating American frontiersman. James O. Pattie first published his account The Personal Narrative of James O. Pattie of Kentucky in 1831 and he passed away in 1851.

    All I Need to Know About Manufacturing I Learned in Joe's Garage: World Class Manufacturing Made Simple

    He has created a fulfilling life, which he shares with his beautiful fiancé and a world-wide circle of friends. But his inspiring life of today grew out of a dark and dangerous past.In this gripping tale, van Stratum brings a once-in-a-lifetime read of his experience growing up with one arm in a small town where he developed a savage temper and a criminal mindset. After a violent robbery by rival drug dealers he had a flash of insight that his life must change, or it would quickly end.After moving to a new country without telling a soul, Mark penetrates the secret world of pick-up artists and learns an incredible skill set that enables him to get the most desired women on the planet. In Drug of Choice, Mark offers insightful lessons about the power of choices to change your business, relationships, and life.This story teaches that your choices are both the cause of your problems and the key to your success. It will make you believe again that it’s never too late to change.

    Having herself spent several years as a paramedic, she knew too well the dangers of the emergency profession. But as fate would have it, she met Dan -- and everything changed. Suddenly she was married to a man who had wanted to be a fireman ever since he was a child, and she found herself faced with the sacrifices and struggles that accompany this challenging career. Being a fireman's wife meant relocating her family, living without her husband for days at a time, and wondering every time she heard a siren if he would make it home safely. Ultimately, it also meant receiving the phone call every fireman's wife fears may come: the news that her husband had been in an accident.Susan speaks on behalf of thousands of firemen's wives nationwide -- the women who hold down the fort while their husbands are on the job. Their sacrifice is our gain, and for the first time, this book tells their story.