Blog Posts

#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.

• by Kenneth Fisher

• SQLStudies

I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading

2019-10-14

10 reads

Database Fundamentals #24: Filtering Data

• by Grant Fritchey

• The Scary DBA

If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause because of your use of it when manipulating data with DELETE and UPDATE statements. It’s...

2019-10-14

20 reads

Geneology with SQL Graph – I

• by Mala Mahadevan

• Mala's Data Blog

I have been working a lot of SQL Graph related queries and applications of the graph data concept to the extent possible within SQL Server’s graph capabilities. Genealogy, or...

2019-10-14

13 reads

Launching SQL Compare with Context

• by Steve Jones

• The Voice of the DBA

Years ago Redgate Software started some work to link our tools together. I remember early efforts, about which I had dubious thoughts as to the value. I hadn’t looked...

2019-10-14

5 reads

MSDTC Best Practices with an Availability Group

• by Ryan Adams

• Ryan Adams

In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group.  Please note that some of these recommendations change if you...

2019-10-14

Power BI Monthly Digest – October 2019

• by Devin-Knight

• Devin Knight

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI

2019-10-14

21 reads

SQL Homework – October 2019 – Code review (self and peer)

• by Kenneth Fisher

• SQLStudies

Every database person I’ve ever met writes at least some code at some point in their career. That code might ... Continue reading

2019-10-14 (first published: 2019-10-02)

426 reads

T-SQL Tuesday: Changing my mind

• by Mala Mahadevan

• Mala's Data Blog

This month’s T-SQL Tuesday is hosted by my friend across the pond – Alex Yates. Alex has a fantastic topic for us to blog about – he asks us...

2019-10-14 (first published: 2019-10-08)

423 reads

Undercover TV Podcast – Intent Locks

• by davidfowler-42596

• SQL Undercover

The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is.

2019-10-14

5 reads

"Think Like a Certification Exam" at the PASS Marathon!

• by Will Assaf

• SQL Tact

Thanks to the 56 of you who joined and actively answered my nerdy sample cert exam questions in the #PASSMarathon webinar "Think Like a Certification Exam" today. Ya'll had...

2019-10-11

15 reads