A Non-Technical Reason to Not Use SELECT *
I got a merge a while back that included a change I wasn’t expecting from one of my developers. All they were doing was renaming a column on a...
2021-01-19
1 reads
I got a merge a while back that included a change I wasn’t expecting from one of my developers. All they were doing was renaming a column on a...
2021-01-19
1 reads
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month James McGillivray (blog | twitter) asks us about our views on...
2021-01-13
2 reads
I had the honor of presenting a new session, Backup Basics with Powershell and dbatools, at the first Ohio North Database Training meeting this evening. Thank you to the...
2021-01-06
7 reads
I had the honor of presenting a new session, Backup Basics with Powershell and dbatools, at the first Ohio North Database Training meeting this evening. Thank you to the...
2021-01-06
5 reads
Yeah, so…that was a hell of a year, wasn’t it?
Short-Form Reviews of Year 2020 Reviewer #1: 👎
Reviewer #2: ★✩✩✩✩, would not recommend
Best Laid Plans… The year started out really...
2021-01-04
Chrissy LeMaire (blog | twitter) pinged me earlier this week to tell me about Github Discussions. It’s a new feature of Github which is similar to Stack Exchange, but...
2020-12-02
2 reads
PASS Summit 2020 has wrapped up (or is in the process of wrapping up), and as with years past, I’m getting this written while the experience is still fresh...
2020-11-17
2 reads
This week is a double-whammy of activity - T-SQL Tuesday and PASS Summit 2020. T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month,...
2020-11-11
A former colleague emailed me with a question about retaining/fixing database users and permissions after restoring a database. They were copying a database from one instance to another, with...
2020-11-04
2,400 reads
A former colleague emailed me with a question about retaining/fixing database users and permissions after restoring a database. They were copying a database from one instance to another, with...
2020-11-04
2 reads
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Comments posted to this topic are about the item The Improvement Limit
Comments posted to this topic are about the item Migrate SSRS Reports to a...