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.
J.D. Edwards was big on Systems Thinking, a way of looking at your systems and improving their functions. It was applied it to IT to become one of the top IT organizations to work for. Read some of these articles for an overview of how this works.
Security in SQL Server is every DBA's concern. Your data is critical and ensuring that it is secure and intact is your responsibility. Application Security's AppRadar is reviewed by Dale Elizabeth Corey and provides monitoring of your critical databases for malicious activity and more.
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
I have a script task that tries to execute a HTTP request, which seems...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers