Database Fundamentals #14: Modifying Data Through SSMS
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
496 reads
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
496 reads
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...
2017-10-23 (first published: 2017-10-11)
1,862 reads
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing...
2017-09-25
433 reads
I am quite honored to say that I am speaking at the single largest and most important Microsoft Data Platform...
2017-09-19
427 reads
If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and...
2017-09-21 (first published: 2017-09-18)
1,963 reads
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
339 reads
Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change...
2017-09-12
390 reads
Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...
2017-09-14 (first published: 2017-09-06)
2,299 reads
I recently read an article asking the question whether or not we downplay the role that luck plays in our...
2017-09-05
319 reads
Guten Tag!
OK, switching back to English for the rest of this.
I’m going to be spending a few weeks in Germany...
2017-08-30
528 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers