Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the...
2018-09-05
280 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of read-only replicas, for free. As mentioned in my blog Azure...
2018-09-05
138 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of...
2018-09-17 (first published: 2018-09-05)
2,555 reads
I will be speaking @ SQLSaturday #795 Porto
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will...
2018-09-05
266 reads
I/O vs Logical I/O
tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two...
2018-09-13 (first published: 2018-09-05)
3,680 reads
Back up Encryption
Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we...
2018-09-11 (first published: 2018-09-05)
2,120 reads
Moving an Azure SQL Database across Resource Groups
In my mind there are a couple of ways to move a database across resource groups. They vary from scripting...
2018-09-05
944 reads
Podcast Audio Now On SoundCloud
For those of you who don’t have time to watch the videos, the audio stream of our webcasts are now...
2018-09-05
309 reads
Apache Hadoop Release 3.1.1 available
Last month Apache Hadoop also release its latest Stable release version Apache Hadoop 3.1.1 which has major improvement in Hadoop system....
2018-09-05
415 reads
I will be speaking @ SQLSaturday 795 Porto
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
16 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...
Alamat BCA KCP City Center Hub/Wa. 0817-819-444
WhatsApp:0817819444 Kawasan Terpadu The City Center, Gedung Perkantoran Tower One, Ground Floor, Jl. K.H....
Alamat BCA KCP Majalaya Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
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