Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-06-17
783 reads
It’s interesting how an OR short circuits.
I recently did a post on the case expression short circuting and received a very very interesting comment from Chad ... Continue reading
2019-06-27 (first published: 2019-06-17)
890 reads
Weekly reading #18
Ready for vacations? The CodingFamily team is almost ready – we have some vacations plans including great conferences during summer and in the autumn. T-SQL bugs, pitfalls, and best...
2019-06-17
32 reads
Last Week Reading (2019-06-16)
Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of the data platform. Here you have a big portion of news today. Press Unlock the...
2019-06-16
30 reads
Back with new focus
Back with a new focus First let me say wow can’t believe that it has been almost 3 years since I have blogged. The last few years my career...
2019-06-16
38 reads
A Double Day
I’m traveling back from Australia today. A few weeks ago I lost a day when I flew West across the Pacific. Today I get it back, with a different...
2019-06-16
43 reads
SQLSaturday Automatic Messages
For those who haven’t used the admin tools for SQLSaturday when an event is created there are a set of messages loaded automatically. It’s up the event admin if...
2019-07-12 (first published: 2019-06-15)
298 reads
Using the Announcement/News Part of SQLSaturday
One of the interesting but not often used features of the SQLSaturday tools is the announcement/news (in the admin tools, its Message Center | Announce News) to do mini-blog...
2019-07-05 (first published: 2019-06-15)
167 reads
SQLSaturday Orlando 2019 Begins
We’ll be event number 911, set for September 28th at our usual location at Seminole State College. Maybe something interesting to do there as far as a theme. Call...
2019-06-14
60 reads
Notes from Jacksonville, Atlanta, and South Florida
Misc notes: Jax. Ice cream break in the afternoon is nice, but the waffle cones on site make all the difference, the smell is hard to miss! Jax. Rooms...
2019-06-14
29 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