I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data manipulation is not the preferred mechanism. T-SQL is the right way to manipulate the data in your database. For purposes Continue reading Database Fundamentals #14: Modifying Data Through SSMS
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t be typing everything into T-SQL directly as we’ll do here. You’ll be able to use stored procedures and parameters to Continue reading Database Fundamentals #13: Data Entry Through T-SQL
The first event on my Fall tour is behind me now. I had a wonderful time at SQL Saturday Holland. A couple of great questions came up that should lead to blog posts soon! Slides and scripts can now be Continue reading Kalen Delaney : Thank you, SQLSaturday Holland!
I’m taking off tomorrow for Holland, UK, Denmark, Germany and Israel: https://www.dbbest.com/blog/im-leaving-jet-plane/#more-11622 You can read the post from DB Best, linked to above, or follow individual links to my public events from here: September 30: SQL Saturday Holland October 5: Continue reading I’m Leaving on a Jet Plane
In the previous Database Fundamentals, I argued that you should be learning T-SQL, yet the very next post I’m showing you how to use the GUI. What’s up? Why the GUI? It’s a very simple reason. I want to show Continue reading Database Fundamentals #12: Adding Data with SSMS GUI
If you’ve been following along with the previous 10 Database Fundamentals blog posts, you have a SQL Server installed and a database with a table in it. You may have more if you’ve been practicing. Now would be the time Continue reading Database Fundamentals #11: Why Learn T-SQL
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at IT/DevConnections 2017 doing several talks. First, I have an all day pre-con on the tools needed for query tuning. Then Continue reading Speaking at IT/DevConnections 2017 – Grant Fritchey
Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change or that you’ve made a mistake. Either way, you will need to modify the tables that you’ve created. Change is Continue reading Database Fundamentals #10: Modifying Tables
Codango is “Coding” in the Nyanja (Chinyanja) language, also known as Chewa (Chichewa) after the largest tribe speaking it. It is a Bantu language spoken by over 15 million people in Southern Africa. #coding #codango #developer #development #jsp #aspnet #php Continue reading Codango Means “Coding”. No, I Mean, Literally!!!!!
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how you store your data. You define these data types as you define the columns in your tables. If you wanted Continue reading Database Fundamentals #8: All About Data Types