Articles

SQLServerCentral Article

ANSI Joins

Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.

5 (3)

You rated this post out of 5. Change rating

2001-05-29

10,124 reads

SQLServerCentral Article

Removing NT Administrators as Sysadmins

By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.

1 (1)

You rated this post out of 5. Change rating

2001-05-25

4,051 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

Windows auth. is much slower than SQL server auth.

By ArnolddG

Moving around in SSMS when logged on to the SQL server (2019)  with Windows...

SQL query i need each Friday count back 6 days and select each ticker record

By angang

I have a stock market table that includes 70 tickers per day: ticker date,...

If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

By VAI

If anyone used artificial intel like Gee-Pee-Tee for writing T-SQL (MS SQL server) code...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers