Jan 14, 2022 | General, Introduction to SQL Server |
How to Write SQL Queries | Wildcard Search using LIKE In previous posts, we introduced some database fundamentals, introduced the basics of a SELECT Statement, discussed column expressions and filtering with the WHERE clause. In this post, we take some time to look at...
Jan 13, 2022 | General, Introduction to SQL Server |
How to Write SQL Queries | Filter Rows with WHERE In previous posts, we introduced some database fundamentals, introduced the basics of a SELECT Statement and discussed column expressions. In this post, we are going to begin to look at chow we can filter the rows...
Jan 12, 2022 | General, Introduction to SQL Server |
How to Write SQL Queries | Columns and Expressions In previous posts, we introduced some database fundamentals and began introducing the basics of a SELECT Statement. In this post, we are going to begin to look at columns and columns expressions that can be used in...
Jan 11, 2022 | General, Introduction to SQL Server |
How to Write SQL Queries | Simple SELECT Statement In the previous post, we introduced some basic database fundamentals. We spoke about tables, columns, relationships and foreign and primary keys. So continuing in my series on writing SQL queries which as I said in...
Jan 10, 2022 | General, Introduction to SQL Server |
How to Write SQL Queries | Database Fundamentals Why do you need to write SQL? More and more organisations are making their way slowly on the data-driven path. It’s becoming more and more necessary for people from different backgrounds to need to access the data...
Jan 30, 2017 | DBA, Introduction to SQL Server, SQL Server DBA |
Recently I was running a health check on one of my clients SQL Servers and I noticed that access to the dedicated admin account was disabled. They would not be able to connect to the Dedicated Admin Account (DAC) remotely. It is generally good practice to enable...
