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?

Redgate opens the doors to cross-database DevOps Test Data Management

by Additional Articles

Redgate

Vendors/3rd-party Products

Redgate’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.

Distracted

by Grant Fritchey

SQLServerCentral

Uncategorized

I've found myself to be very distracted this week. Concentration on the task at hand has proven to be a challenge. I'm pretty sure the cause is that I just came off of three weeks of travel, which can be exhausting. Concentration, like so many things in life, requires energy. No energy, no concentration. So, […]

PostgreSQL Table Import/Export from and to CSV File

by Shivayan Mukherjee

SQLServerCentral

PostgreSQL

This article will cover exporting data from a PostgreSQL table to a CSV file, both from the command line and pgAdmin. We will also look at importing data from a CSV file.

Startup Advice

by Steve Jones

SQLServerCentral

Many technologists would love to start a company. Steve has a little advice today.

Cheat Sheet for SQL Server DBA Daily Operations

by Additional Articles

MSSQLTips.com

Database Administration

This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.

Finding External References in Database Deployments

by Additional Articles

Redgate

Vendors/3rd-party Products

This article outlines the syntax of the three and four dot references that usually denote external database references, demonstrates how to find them either from a live database or by using a text search of a script, and explains some of the complicating factors that can lead to 'false positives'.

Create an HTML Report on the Status of SQL Server Agent Jobs

by Nisarg Upadhyay

SQLServerCentral

SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]

The Public Perception of Security Issues

by Steve Jones

SQLServerCentral

Security

The way the public thinks about security issues isn't always accurate, but we have to accept that and learn to respond in a professional manner.

PASS Data Community Summit registration is open!

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.

Benefits and Limitations of SCHEMABINDING Views in SQL Server

Redgate opens the doors to cross-database DevOps Test Data Management

Distracted

PostgreSQL Table Import/Export from and to CSV File

Startup Advice

Cheat Sheet for SQL Server DBA Daily Operations

Finding External References in Database Deployments

Create an HTML Report on the Status of SQL Server Agent Jobs

The Public Perception of Security Issues

PASS Data Community Summit registration is open!

Blogs

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

Counting Groups with Window Functions: #SQLNewBlogger

The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.

Forums

Visual Studio 22 / SSIS Project / (Project) Connection problem

How to determine if a DB is currently being used

Data cleansing/conversion tool HPE

Question of the Day

The LAGging NULL