Why You Need A Test Environment
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
131 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
How to write a DELETE query
My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My...
2017-06-14
138 reads
How to write an UPDATE query
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
124 reads
How to write an INSERT query
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
387 reads
How to write a SELECT query
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
157 reads
Querying a Database
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
98 reads
SQL Server Management Studio v17.0
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
226 reads
SQL Server 2017 Announced
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
87 reads
Something something Production something something you idiot
You’re reading this series of posts because you want to learn about databases and how to use them. What you...
2017-04-26
92 reads
Upcoming SQLSaturdays in Alberta, Canada
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming...
2017-04-19
110 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...