A View Will Not Make Your Query Faster
Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation...
2018-05-14
339 reads
Blog Posts
Blogging and when to keep your big mouth shut
I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few...
2018-05-14
500 reads
Day 14 MySQL sys Schema
MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as...
2018-05-14
216 reads
Defining FKs in CREATE TABLE–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-05-14 (first published: 2018-05-03)
2,953 reads
Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,433 reads
Handy TSQL for Azure SQL Database
I do not always use the Azure portal to make database changes or to check for certain information. I use...
2018-05-14
336 reads
I’m speaking: SQL Saturday Los Angeles 06-09-18
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...
2018-05-14
268 reads
Microsoft Azure – Azure Mobile App is available now
Hello friends, Please check the below link for my new post on Microsoft Azure Mobile App. https://social.technet.microsoft.com/wiki/contents/articles/51525.microsoft-azure-mobile-app-is-available-now.aspx
2018-05-14
743 reads
Monday morning comic 2018-05-18
Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.
2018-05-14
354 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
128 reads
Blogs
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
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