The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. In this article, I will introduce the basic SELECT statement fetching data from just one table.
2023-06-21
This article explains how these ‘ephemeral databases’ can be used to improve development and testing processes in ways that reduce the number of bugs entering the deployment pipeline, drive up the quality of database releases, and so improve the reliability and speed of database deployments to production.
2023-05-15
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
2,091 reads
In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.
2023-04-28
In this webinar, Microsoft Data Platform MVP, Grant Fritchey, is joined by our expert panel to share the pros and cons to building a monitoring system versus purchasing one.
2023-03-27
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-23 (first published: 2022-11-21)
217 reads
In this article, you will learn how to configure an RDS database for connections from client tools.
2022-11-21
2,615 reads
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
10,933 reads
Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.
2022-10-17 (first published: 2022-08-26)
11,594 reads
This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.
2022-03-23
1,386 reads
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Hi We have an stored procedure which runs frequently and it contain logic in...
Hi I am new to replication and we have database of size around 2TB...
I want to query a table that has a datetime column ([CreateDateTime]) and get...
Ask SSC