No Summit Submission This Year
I had three ideas I considered submitting this year:
Devops for the DBASQL ChecklistsLearning Plans v2I’ve presented the first topic a...
2018-03-29
279 reads
Moving to AWS EC2
SQLServerCentral has been stuck in the past for some time, but we’ve finally decided to move. I’ve been asking for...
2018-03-28
1,480 reads
Dates and Times in SQL Server: DATETIMEOFFSET
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-28
720 reads
SQL Server DevOps Tools
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...
2018-03-28
1,026 reads
Webinar: Is the traditional data warehouse dead?
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
105 reads
Webinar: Is the traditional data warehouse dead?
As a follow-up to my blog Is the traditional data warehouse dead?, I did a webinar on that very topic for...
2018-03-28
415 reads
Stretch Databases for the Budget Poor DBA
The post Stretch Databases for the Budget Poor DBA appeared first on WaterOx Consulting.
2018-03-28
479 reads
Rotating TDE Certificates without re-encrypting data
I talked previously about why we have each of the layers in the encryption hierarchy used to support TDE (Transparent...
2018-04-04 (first published: 2018-03-28)
3,508 reads
What’s the difference between Files and Filegroups?
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct...
2018-03-28
795 reads
SQLSaturday Orlando 2018 – Planned for October 6
Just a quick note that we’ve reserved the date for our 12th SQLSaturday here in Orlando. It will be held...
2018-03-28
297 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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