내가 좋아할 만한 콘텐츠
New blog post! Disaster struck… sqlpete.wordpress.com/2022/03/10/sql…
[Blog] : Advanced report examples using PIVOT and GROUPING SETS I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel. mssqltips.com/sqlservertip/7…
![AaronBertrand's tweet image. [Blog] : Advanced report examples using PIVOT and GROUPING SETS
I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel.
mssqltips.com/sqlservertip/7…](https://pbs.twimg.com/media/FNQOSkwWYAI-CdZ.jpg)
There’s a special place in hell for people who name their sub-directories in the MMM-YY date format. #baffled
If I had 50p for every time I forgot that UNION (as opposed to UNION ALL) does an implicit DISTINCT behind the scenes, I’d have well over £5 by now.
If you ever find yourself having to use DATETIMEOFFSET in SQL Server, can I recommend (a) holy water, (b) finding a less stressful job; base-jumping with live tigers strapped to you, maybe.
New essay by me in the New Yorker. When it comes to data - in order to count - one must first decide what should be counted. newyorker.com/magazine/2021/…
Good morning! I constantly feel like a fraud. I know a few of you do too. I'm told it's normal. The principal key to dealing with this is simple: Fake it till you make it. Just do the work. Pretend you are what you are not and do the work.
New blog post: “Practical queries using binary operations” sqlpete.wordpress.com/2021/02/03/pra…
Importing data into #AzureSQL is a common task: I have created a repo to provide working code samples to that task easy and quick. Powershell, AZ CLI, BCP, BULK INSERT, Data Factory and Apache Spark are all covered. Enjoy! lnkd.in/dbnRwxs
New blog post: ‘Interest and APR: a short explainer’ sqlpete.wordpress.com/2020/12/31/int…
This was a really informative watch, recommended!
[From the best of the blog archives:] 7 Ways Your Data Is Telling You It’s a Graph by Karen López (@datachick) Read now: r.neo4j.com/2J1h4kS #GraphDatabases #DataModel #GraphDataModel
Ok, this is too much. “the introduction of LAMBDA makes the Excel formula language Turing Complete” techcommunity.microsoft.com/t5/excel-blog/… tl;dr LAMBDA() lets you name any Excel formula you have written so you can then simply call it by name.
[From the best of the blog archives:] 7 Ways Your Data Is Telling You It’s a Graph by Karen López (@datachick) Read now: r.neo4j.com/2J1h4kS #GraphDatabases #DataModel #GraphDataModel
The GREATEST holiday gift that you LEAST expected... reddit.com/r/SQLServer/co… Happy holiday everyone!
Turns out my definition of “self-join” is NOT the same as SQL Server’s ; you can’t join to the same table twice in an indexed view, which has ruined my morning’s work!
Every day, it kills me that you can’t do cross-db joins in Azure. It’s like trying to run a race with your legs tied together.
New blog post, “SQL String Fun(ctions)” sqlpete.wordpress.com/2020/03/22/sql…
“Normalise until it hurts, denormalise until the devs stop whining.”
United States 트렌드
- 1. South Carolina 16.2K posts
- 2. Bama 13.5K posts
- 3. #RollTide 3,906 posts
- 4. #HalloweenHavoc 11.3K posts
- 5. Vandy 9,395 posts
- 6. Mizzou 7,058 posts
- 7. Mississippi State 3,663 posts
- 8. Gane 129K posts
- 9. #UFC321 114K posts
- 10. Jon Jones 12.6K posts
- 11. Aspinall 117K posts
- 12. Ryan Niblett N/A
- 13. Iowa State 5,599 posts
- 14. Sark 5,580 posts
- 15. Arch 19.8K posts
- 16. Ryan Williams 1,147 posts
- 17. Ty Simpson 2,270 posts
- 18. Sellers 12.7K posts
- 19. Zollers 1,292 posts
- 20. Germie Bernard 1,016 posts
Something went wrong.
Something went wrong.