Pride and Prejudice... and Triggers
This post is part of #tsql2sday event 🙂
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
24 reads
SQL Admin Best Practices with DMV's at the Houston SQL Server UG
Thanks to the full room of SQL enthusiasts who joined me today for the September Houston SQL Server UG Group Meeting! What a great crowd that enjoyed the hospitality...
2018-09-11
16 reads
Thursday Webinar Postponed due to Hurricane Florence
Hello! The webinar I was going to give this coming Thursday with MSSQLTips.com has been postponed. When we have a...
2018-09-11
242 reads
Reduce your Azure Development Subscription Cost
Azure VMs
Usually you should convey to developers and testers to shut down the VMs manually when they are not using non production virtual machines. Also there some ways to...
2018-09-11
44 reads
Do You Need a Relational Data Warehouse?
Are you looking to do a major update to your data warehouse or looking to modernize? Many technologies have come...
2018-09-27 (first published: 2018-09-11)
3,079 reads
CCI – How to load data for better Columnstore Segment Elimination
Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...
2018-09-11
202 reads
Pride and Prejudice... and Triggers
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
560 reads
SQL in the City Summits–Coming to New York, London, and Chicago
I love New York. Every time I get to travel to the city, I get excited and look forward to...
2018-09-11
320 reads
What happens in a trigger stays in the transaction: T-SQL Tuesday #106
Anything that happens in a trigger happens within the same transaction of the command that called it.
Part of me feels...
2018-09-11
223 reads
Triggers: The hidden logic that will strike back – TSQL Tuesday #106
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches...
2018-09-11
266 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