What is an Event-Less Extended Event Session?
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-06-20 (first published: 2018-06-11)
1,749 reads
Making Sense of the Power BI Ecosystem Presentation Materials
I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in...
2018-06-09
365 reads
Double Win- Watch DeWitt and Help SQLSoldier's Loved Ones!
Brent Ozar (blog/@BrentO) is sponsoring a special webcast in a couple weeks, with an amazing presenter:
https://www.brentozar.com/archive/2018/06/announcing-a-very-special-sqlfamily-webcast-with-dr-david-dewitt/
The webcast (“SQL Query Optimization....
2018-06-09
832 reads
Building a Personal VPN Azure Solution
Since joining Denny Cherry & Associates Consulting, I tend to travel about once a month. This isn’t a huge amount and...
2018-06-08
462 reads
Project Euler
I like having problems to practice solving in computer science. It can be a fun hobby, and it exercises your...
2018-06-08
1,398 reads
No @@ServerName on Linux
I setup a new instance of SQL Server on Linux some time ago. At the time, the Linux machine didn’t...
2018-06-07
1,027 reads
Removing the time element from a datetime
Killing Time – or removing the time element from a datetime
Over the course of time, we all collect scripts and routines...
2018-06-07
2,115 reads
SQL in the City Streamed: June 2018
Next week, Redgate Software, will be putting on SQL in the City Streamed. These events are a great way to...
2018-06-07
279 reads
Upcoming: Speaking on permissions at PASS Summit 2018 and 24 Hours of PASS
I’m excited to announce that I’ve been selected to present at the PASS Summit! This will be my fourth year speaking at the Summit, and it’s always a privilege....
2018-06-07
15 reads
Upcoming: Speaking on permissions at PASS Summit 2018 and 24 Hours of PASS
I’m excited to announce that I’ve been selected to present at the PASS Summit! This will be my fourth year speaking at the Summit, and it’s always a privilege....
2018-06-07
22 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers