Chapter 3 from Murach’s SQL Server 2008 for Developers shows you how to retrieve data from a database table. In the process, you’ll master the basic skills that you’ll use in coding almost any SELECT statement, no matter how complex. At that point, you’ll be ready to learn how to code joins, summary queries, subqueries, and action queries, and then move on to working with server-side features like cursors and stored procedures.
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Steve Jones reminisces a bit and comments on reaching one million members in the community.
You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.
This topic is nothing new, but well worth revisiting for those who have not used CROSS JOINS. You may have faced a problem where you need to compare historical records for a particular set of records to ensure that records have been saved in the correct order.
Lynn Pettis gives us a look at a new way to solve a T-SQL problem.
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
I have found that I like to generate a script once and roll it out to multiple servers at the same time. SQL Server 2008 Management Studio makes that fairly easy by allowing one window to connect to multiple instances simultaneously
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
I am using ssrs in visual studio 2022, I work on a report, there...
Which of these is more appropriate for tomorrow?
See possible answers