Moving a SQL Server Availability Group to a different Subnet
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-09-12 (first published: 2018-09-03)
2,952 reads
Back to University, Redgate University
Let’s be really clear, Redgate makes ingeniously simple tools. That’s a fact. Nothing has changed. However, if you really want...
2018-09-03
297 reads
Calendar Reminders for SQL in the City Streamed Free Training Sessions
SQL in the City Streamed is coming up this week! This is an awesome FREE online event, and it’s all about learning new things and getting inspired. Join us...
2018-09-03
25 reads
SQL Homework – September 2018 – Backup and Restore continued.
In the very first SQL Homework post you were asked to take a backup. In fact it asked you to...
2018-09-03
814 reads
Azure SQL Database – Detecting Threats
At first I was nervous but then I realized it was me triggering “Someone has logged on to your server ...
2018-09-03
852 reads
Installing External Modules into SQL Server’s Python
So Microsoft have integrated Python into SQL Server, from the moment I heard that I thought to myself, “wow, this...
2018-09-03
369 reads
Oracle Atonomous
Last month Oracle – (Larry Ellison, CTO and Executive Chairman) has introduced Oracle Autonomous database for OLTP system Oracle has already...
2018-09-03
297 reads
What is MemSQL
yeah, MemSQL for me its a combination of RDBMS and NOSQL and more of flexibility of both per our choice,...
2018-09-03
957 reads
New – News on Database System
This month i will try to write whats new going on in the market, as i could see many new...
2018-09-02
239 reads
Fog Computing
Its been introduced by CISCO On November 19, 2015, system which helps cloud computing to reduce the response time from...
2018-09-02
286 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