A Day in the Life (1/?) - August 7, 2018
This is my first installment in (I hope) a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the...
2018-08-08
13 reads
NTFS Compression and SQL Server Do Not Play Well Together
Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.
What I didn’t realize...
2018-08-08
23 reads
Power BI Custom Visuals Class (Module 114 – Overview by CloudScope)
In this module you will learn how to use the Overview by CloudScope. The Overview by CloudScope show a list...
2018-08-21 (first published: 2018-08-07)
2,289 reads
Enable SQLCMD Mode on SSMS
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,555 reads
T-SQL Tuesday #105 Invitation: Brick Wall
It’s time for another T-SQL Tuesday. The brainchild of Adam Machanic (b|l|t), and designed to strengthen the SQL Server blogging...
2018-08-07
361 reads
2018-08-07
68 reads
Identifying records with special characters (Unicode)
Occasionally Data analyst may fall in a situation, where they need to identify records holding special characters or only the...
2018-08-24 (first published: 2018-08-07)
8,207 reads
Generate Script in SQL Server With 6 Simple Steps
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like to know how to generate script with data of...
2018-08-07
39 reads
Generate Script in SQL Server With 6 Simple Steps
“I am a new user of SQL Server so I have very limited knowledge of its features. I would like...
2018-08-07
1,205 reads
Table Value Constructors in TSQL
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
57 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...
Kantor Resmi BCA KCU KUDUS Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Kantor Resmi BCA KCU GANG TENGAH Telp:0817°825°533
Telp/Wa 62817825533 Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
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