Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

Blog Post

September on the Road

I am so excited for the next three weeks.  This is a trip that has been in the planning for nearly 2 years.  I have always loved travelling and...

2019-09-01

15 reads

Blog Post

My Very First Azure SQL Database

I recently delivered my very first SQL Saturday pre-con for SQL Saturday Richmond on Friday, March 29, 2019.  You can read about that adventure here. As part of the...

2019-04-08

24 reads

Blog Post

Delivering My First Pre-Con

I didn’t announce this before it happened because I didn’t want to “jinx” myself, but I am happy to say that it’s finally happened.  I have delivered my very...

2019-04-06

29 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important

By

As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs

Forums

Filestream Filegroups on state RESTORING

By M@dboy

Hello All, I have a question. My SQL Servers are running SQL Server 2019...

Find dependencies on a table

By water490

I am in the process of doing a re-write for my project so I...

Career Advice

By sqlenthu 89358

hello folks, I am posting this question with heavy heart. I have been a...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers