Articles

SQLServerCentral Article

Evolving Role of Data Professionals in Artificial Intelligence Era

Generative Al tools like Gemini and GPT promise to automate and augment knowledge-based work. Data professionals must adapt to this transformation by acquiring new skills and playing a central role in their organization's AI-driven future. Data preparation, curation, ethical sourcing and labeling, and collecting user feedback become crucial as high-quality data is essential for effective LLM based application.

You rated this post out of 5. Change rating

2024-03-04

1,330 reads

SQLServerCentral Article

A Few Best Practices for Strong SQL Server Security

Explore key strategies for securing SQL databases in this comprehensive guide. Learn about robust authentication, data encryption, SQL injection prevention, and more, with practical code examples. Enhance your database's security and performance by following tips from this article.

5 (2)

You rated this post out of 5. Change rating

2024-03-01

1,916 reads

External Article

Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster - Part 3

I used the guide in a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 to install a SQL Server 2008 on a Windows Server 2008 failover cluster (WSFC). Now, I would like to upgrade and migrate my SQL Server 2008 failover clusters to SQL Server 2022 running on Windows Server 2022. What is the process for installation and configuration?

2024-02-26

External Article

Redgate Summit: The Database Landscape

A series of Redgate events across the globe for data professionals who want to improve their skills and knowledge about Database DevOps, learn about moving to the Cloud, AI, and working across multiple databases. Redgate Summit aims to bring together database professionals who want to level-up their skills to navigate the increasingly complex database landscape. Learn more about emergent technologies, and reliably solve the complex challenges of database management across the entire DevOps lifecycle. Each event will all feature three separate tracks covering New and Future Technologies, Deep Dive Solutions, and Leadership, all promising to equip senior database professionals with the tools and insights needed to navigate the intricate landscape of 2024.

2024-02-23

Blogs

SQLpassion Live Training about running SQL Server in Microsoft Azure

By

From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training...

The Redgate Summit in Atlanta

By

Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on...

Friday Flyway Tips–Quick Command Line Access

By

One of the things I had to do recently in a demo was access...

Read the latest Blogs

Forums

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

row changes per hour by TagID

By Bruin

I have a large table being written too every second with equipment (PLC) information....

Indexing strategy very long text strings

By aaron.reese

Hey guys,  Just looking to see if anyone has any bright ideas how to...

Visit the forum

Question of the Day

Logical Operators

I have this table and data:

CREATE TABLE ProdList
(ProductID INT NOT NULL
, ProductName VARCHAR(100)
, ProductCategory VARCHAR(40)
, ProductSize VARCHAR(4)
, ProductColor VARCHAR(20)
)
GO
INSERT dbo.ProdList
  (ProductID, ProductName, ProductCategory, ProductSize, ProductColor)
VALUES
  (1, 'Dirt Bike', 'Bike', '26', 'Blue'),
  (2, 'Mtn Bike', 'Bike', '26', 'Red'),
  (3, 'Dirt Bike', 'Bike', '24', 'Blue'),
  (4, 'Downhill', 'Ski', '180', 'White'),
  (5, 'Telemark', 'Ski', '175', 'Blue'),
  (6, 'Snowboard', 'Ski', '182', 'Various'),
  (7, 'Goggles', 'Ski', 'L', 'Clear')
How many rows are returned from this code:
SELECT productid, pl.ProductName
 FROM dbo.ProdList AS pl
 WHERE pl.ProductCategory = 'Bike'
 OR pl.ProductCategory = 'Ski'
 AND pl.ProductColor = 'Red'

See possible answers