Take the SQLChallenge: Tuning a Stored Procedure
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
I’m Joining Redgate Software!
I’m excited to announce that I’m joining the evangelist team at Redgate. Starting next Monday, I’ll be working with Steve Jones, Grant Fritchey, and Kathi Kellenberger — plus the whole...
2018-08-15
2 reads
Employee Agreements & Contracts: Anti-Patterns (31 minute video)
When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In...
2018-08-13
Table Value Constructors in TSQL
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
18 reads
Upcoming Live Podcast Recording Sessions: Employee Agreements and Contracts for DBAs and Devs
I’ve just scheduled two new podcast recording sessions! These are live, half hour sessions – you can join in listen, or share comments. Here’s what we’ll be talking about…....
2018-08-03
2 reads
Dear SQL DBA: Remembering Robert Davis, DBA Hero
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
6 reads
SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
1 reads
Changing Your Highlight Color in SQL Operations Studio
I’ve been enjoying working with SQL Operations Studio lately – a new, free, cross-platform editor from Microsoft. The tool is under active development and it’s a great time to...
2018-07-25
1 reads
What the Microsoft MVP Award Means to Me in 2018
I recently received my seventh “Most Valuable Professional” award from Microsoft. Oddly, I don’t think I’ve ever written about what this award means to me until this point. In...
2018-07-11
2 reads
The Right to Be Erased is Coming to California, Along with Other Privacy Rights
In the last year, developers and DBAs have heard a lot about the General Data Protection Regulation (GDPR) law passed by the European Union. These regulations not only impact...
2018-07-05
1 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
DBATools in a agent job
Hi Dbatools is used to copy table data from domain a to domain b...
SQL server help (converting rows to columns)
I am using the following sql to convert rows into columns for each pid,...
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Comments posted to this topic are about the item Ingesting Data From REST API...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers