SQL Server

External Article

Benefits and Limitations of SCHEMABINDING Views in SQL Server

  • Article

The tip, Views in SQL Server, explored the purpose of views, creating views examples, and benefits of views. A view is a virtual table that references the actual database tables stored in the database. What if someone changes the underlying table structure, such as renaming the column, adding a new column, or dropping the table? What is the impact of changing schema on views? How can we stop any schema changes if the view references the schema?

2023-05-08

External Article

Use DDL Triggers to Automatically Keep SQL Server Views in Sync

  • Article

As much as we tell people to use SCHEMABINDING and avoid SELECT *, there is still a wide range of reasons people do not. A well-documented problem with SELECT * in views, specifically, is that the system caches the metadata about the view from the time the view was created, not when the view is queried. If the underlying table later changes, the view doesn't reflect the updated schema without refreshing, altering, or recreating the view. Wouldn't it be great if you could stop worrying about that scenario and have the system automatically keep the metadata in sync?

2023-04-17

External Article

Enhancing SSIS ETL Tools with SolarWinds Task Factory

  • Article

SQL Server Integration Services (SSIS) has been the de facto ETL tool for over 15 years for DBAs, Developers and Business Intelligence Professionals to extract, transform and load data (i.e. ETL tasks) for specific business processes, data-centric applications, data warehousing, reporting and data exchange between organizations. SSIS is a great product with high adoption across the globe, but has some limitations related to modern data sources, performance and streamlining tedious tasks. How can we overcome these limitations and have SSIS provide greater value?

2023-04-10

SQLServerCentral Article

Can We Please Stop Sending Passwords Over the Wire?

  • Article

While analyzing SQL Server's network protocol, I came across a weird fact: when a database client logs in using SQL Server authentication (as opposed to Windows authentication), it has to send the user's password to the server, in blatant violation of common security guidelines. At first, I couldn't believe it; SQL Server generally does an […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(8)

You rated this post out of 5. Change rating

2022-03-02

5,624 reads

Technical Article

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

  • Script

This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,843 reads

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

By

One of the first things I review when I inherit a new SQL Server...

AgentDBA vs Critical SQL Server

By

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

By

I’ve had a Dropbox account for years. Like a lot of people, I started...

Read the latest Blogs

Forums

Follow Your Hunch

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Follow Your Hunch

What Happens When You Ask a Local AI to Query Your Database?

By Kumar Abhishek

Comments posted to this topic are about the item What Happens When You Ask...

Detecting Characters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Detecting Characters

Visit the forum

Question of the Day

Detecting Characters

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code: 

SELECT CustomerNameID,
       CustomerName
 FROM dbo.CustomerName
 WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with: 
CustomerNameID CustomerName
1              John Smith
2              Sarah Johnson
3              MICHAEL WILLIAMS
4              JENNIFER BROWN
5              david jones
6              emily davis
7              Robert Miller
8              LISA WILSON
9              christopher moore
10             Amanda Taylor
How many rows are returned?

See possible answers