This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It’s also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure.Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond in...

Become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. This new edition provides expanded examples, including a chapter from the world of sports, and covers the latest performance enhancements through SQL Server 2019.Window functions are useful in analytics and business intelligence reporting. They came into full blossom with SQL Server 2012, yet they are not as well kn...

A concise and up to date introduction to criminology for those undertaking degrees and foundation degrees in policing, police studies and related subjects. It provides an introduction to criminological perspectives on the development of the police service over the last 200 years alongside an overview of contemporary themes. Key topics include the changing role of policing, police governance and accountability, policing philosophies and strategies and the globalisation of policing. The book...

This book offers an applied approach to criminology suitable for prospective police officers. It covers the fundamentals of criminological knowledge, theory and research, and their relevance to policing. The book is split into two parts, the first introducing the basics of criminology, and the second connecting criminological research to police practice. It focuses on the principles of evidence-based practice and encourages students to think critically about the issues covered. Core conten...

**Dissociation 101: The go-to guide for understanding your dissociative disorder, breaking the stigma, and healing from trauma-related dissociation."Just as important as The Body Keeps the Score (but an easier read for me)."—5-star reader review**Guided by clinical counselor Jamie Marich—a trauma-informed clinician living with a dissociative disorder herself—this book tells you everything you need to know about dissociation...but were too afraid to ask.

Dissociation 101: The go-to guide for understanding your dissociative disorder, breaking the stigma, and healing from trauma-related dissociation.Guided by psychologist Jamie Marich--a trauma-informed clinician living with a dissociative disorder herself--this book tells you everything you need to know about dissociation...but were too afraid to ask.Here, you’ll learn:• What dissociation is--and why it’s a natural response to trauma• How to und...

An empowering, healing guide that reveals the true cost of avoidant behaviour in a relationship - disconnection, disengagement, and divorce - and shows how we can instead learn to speak up and start connecting with the ones we love most.'I wish I had spoken up sooner.'People think relationships fail because of deal breakers like infidelity, finances, or parenting problems. But the real culprit is often much less dramatic: emotional disconnection af...

A psychiatrist who has dedicated her life to treating global survivors of unspeakable horrors shares the three keys to resilience that we can use to weather stress, loss, and trauma in our own lives.“This book is a gift of empathy and lived wisdom—rare, real, and deeply human.”—Dr. Koen Sevenants, former global lead for Mental Health and Psychosocial Support in Emergencies for UNICEF’s Child Protection Area of ResponsibilityIn her debut boo...

**A comprehensive workbook for understanding and treating developmental trauma using the NeuroAffective Relational Model (NARM)Includes practical exercises for understanding ACEs, addressing C-PTSD, nurturing post-traumatic growth, identifying survival styles, and more**Designed for clinicians, trauma therapists, and practitioners of the NeuroAffective Relational Model, this workbook offers a blueprint to NARM’s transformative approach to healing developmental trauma. Autho...

A patient-oriented manual for complex trauma survivors.This training manual for patients who have a trauma-related dissociative disorder includes short educational pieces, homework sheets, and exercises that address ways in which dissociation interferes with essential emotional and life skills, and support inner communication and collaboration with dissociative parts of the personality. Topics include understanding dissociation and PTSD, using inner reflection, emo...

Improve your workplace performance with 50 practical, science-backed tools that build emotional resilience and neutralize negative thoughts—from the internationally bestselling author of the 13 Things Mentally Strong People Don't Do series“When work feels overwhelming, it’s easy to think you just need to push harder or hold it all together. But The Mental Strength Playbook offers a different approach.”—Lori Gottlieb, New York Times

The first major book on the uprisings in Iran in 2022 and 2023On Tuesday 13 September 2022, all Mahsa Amini has planned is a day shopping in Tehran. Her birthday is next week. But she is arrested as she comes out of the subway – the Guidance Patrol deem her hijab inadequate. On Friday she is pronounced dead. By Sunday, women have taken to the streets across Iran, setting their headscarves on fire and cursing the Supreme Leader. Months later, workers down their tools and businesses ...