SQL Server allows data access from many sources, probably any that you could want. Some, however, are easier than others. Have you ever tried to update information in Exchange from SQL Server? Not that easy, but new author Steve Boriotti has written code as well as a short article on how you can make this happen.
In this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features.
Andy has some examples of not very high tech solutions that involve some technology behind the scenes, but the binding factor was that someone had to see the problem first, and it wasn't one of those show stopper type problems. It's not about SQL, but we think it is on topic.
This article focuses on a common problem associated with conflicting locks: blocking. When blocking occurs, a single connection blocks all other connections from reading or modifying a particular piece of data. Learn here how to resolve these issues.
Working with a QA server in SQL Server 2000 is something everyone should learn to do. Having some staging area between development and production will help ensure a more stable environment and smoother deployments. After a little hiatus, Steve Jones continues with this series looking at moving the latest backup over to QA.
This article looks at the basics of storage design for cubes using Analysis services. A good starting point for those getting into the use of analysis services.
Akeel Din has written an introductory SQL book that is available for free in PDF form. It's also available in print from Amazon if you like holding something real in your hands.
A basic look at how you can start to build a data warehouse. This has some basics you need to do the design of the various fact and dimension tables.
It was an adventure. Moving a SQL Server physically from one location to another should be a simple process, but it turned out to be a bit more than Steve expected. Read about the adventure and inject a little humor into your day.
Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
Comments posted to this topic are about the item What is Between?
Comments posted to this topic are about the item Inside the Walls of Azure...
Comments posted to this topic are about the item SQL Server 2025 Excitement
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers