Articles

You are cordially invited to attend 2021 Virtual Data.SQL.Saturday.LA event!

We are reaching out to all people that enjoyed SQL Saturday in LA 2017, 2018, 2019, and 2020 events to let you know that the 2021 event is fast approaching. Only 30+ days remain until the June 12 Virtual Data.SQL.Saturday.LA event. Please register soon to reserve your spot by using http://2021sqlsatla.eventbrite.com/ hyperlink, register using a form below or just use a QR code.

2021-05-26 (first published: )

Dimensionality Reduction Techniques - PCA, Kernel-PCA and LDA Using Python

Summary In this article, we will be looking at some of the useful techniques on how to reduce dimensionality in our datasets. When we talk about dimensionality,  we are referring to the number of columns in our dataset assuming that we are working on a tidy and a clean dataset. When we have many columns […]

4 (1)

2021-05-24

1,669 reads

SQL Server 2016 - Always Encrypted

Always Encrypted is a new security feature which was introduced in SQL Server 2016. Always Encrypted is a technology to ensure the data stored in a database remains encrypted at all times during SQL Server query processing. Always Encrypted allows clients to encrypt sensitive data, such as credit card numbers and national identification numbers, inside the […]

4.67 (6)

2021-05-21 (first published: )

10,966 reads

Hidden Pitfalls with INNER JOIN and NOT IN Operators

I want to show you how two common operators can deceive you into believing you have constructed a proper SQL statement for your solution. We may want to filter results in a table by using using a IN/NOT IN or a INNER JOIN/LEFT JOIN to another table. There are a couple of hidden dangers here […]

3.77 (13)

2021-05-19

7,681 reads

Blogs

P2 Puts Easy, Flexible Project Tracking Tools In Your Hands

By

Improve your team's workflow and productivity with these project tracking blocks.

Daily Coping 22 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Read the latest Blogs

Forums

Adding Comma , after IIF

By niteowl

So guys, I want the output value be like Opening Date, Closing Date Lets...

Handling OLEDB waits.

By JasonO

I have an application which runs on SQL 2016 & has a link server...

Finding the Group

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding the Group

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers