Communicating Effectively at the Workplace
This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-08
2 reads
Bert Wagner
More "Wrong" SQL Server Math - Floating Point Errors
Watch this week's video on YouTube
Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren't aware of how it...
2019-10-01
6 reads
More “Wrong” SQL Server Math – Floating Point Errors
Watch this week’s episode on YouTube. Last week we looked at how implicit conversions and datatype precedence can cause SQL Server to output unexpected results (if you aren’t aware of how...
2019-10-01
255 reads
SQL Server Quick Tips
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
994 reads
SQL Server’s “Wrong” Math
Watch this week’s video on YouTube! A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with...
2019-09-24
56 reads
SQL Server's "Wrong" Math
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
2 reads
Tracking Who Last Changed a Row
This post is a response to this month’s T-SQL Tuesday #118 prompt by Kevin Chant. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...
2019-09-19 (first published: 2019-09-10)
1,120 reads
SQL Server Quick Tips
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-17
3 reads
Whitespace, Letter Case, and Other Things That Prevent Plan Reuse
Watch this week’s episode on YouTube. Last week’s post briefly mentioned that SQL server may not reuse a query plan from cache if there is a small difference in whitespace....
2019-09-16 (first published: 2019-09-03)
521 reads
How I Troubleshoot SQL Server Execution Plans
Watch this week’s video on YouTube. Today I’m concluding my series on SQL Server execution plans by sharing the specific steps I take when troubleshooting a slow performing query....
2019-09-12 (first published: 2019-08-27)
1,785 reads
Blogs
A New Word: Mottleheaded
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Microsoft Purview GA menu’s
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
I have never seen an insert statement with -= tablename in place of values
We have a third part software and looking at some of their SQL we...
Question of the Day
Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers