Contained Database – No more need for Server Level Logins
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,935 reads
Community recognition
On the first day of January 2017, I was honoured to receive an email naming me as a Microsoft MVP...
2018-07-04
320 reads
Updating VSTS to SQL Change Automation
We (Redgate) released SQL Change Automation a few weeks back. This is the first stage to implementing a combined toolset...
2018-07-04
1,009 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,767 reads
Building Better Test Data on the Redgate Hub
I have a new piece published over at the Redgate Hub: Building Better Test Data with SQL Provision. Part of...
2018-07-03
853 reads
Mastering Index Tuning–Day 3
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-03
963 reads
Half-year round-up
So, to do the name “blog” justice, I should post something every now and then. Alright, here you go, let...
2018-07-03
298 reads
A bug in merge replication with FILESTREAM data
I wish I could say that every DBA has a love/hate relationship with Replication, but, let’s face it, it’s only...
2018-07-11 (first published: 2018-07-03)
2,225 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part...
2018-07-03
274 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...
2018-07-03
9 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