Do you know what the schema is? In Relational databases, there is the concept of a database and a table, but the schema sits between them. In SQL Server, this is known as the owner. But do we really need this additional layer? Has it ever caused you problems? Has it outlived its usefulness?
2003-05-21
5,224 reads
Microsoft has been running 2 day seminars on Windows 2003 across the country as well as at selected Enterprise Partner sites. Steve Jones recently attended one and has a first look at the next generation of Windows Servers.
2003-05-15
5,095 reads
Do you use @@version? sp_server_info? What's the difference? Read on to see what each of these methods returns and which one you should be using.
2003-04-21
7,093 reads
Expanding on the issue of reviewing software for SQL Server, Steve Jones proposes some standards for reviews in this article. Please take a moment to read and comment on this proposal to better help SQL Server Central.com provide you with the information that you need.
2003-04-14
3,226 reads
This article expands Steve Jones' look at ways to audit changes by examing how you can deal with the large amounts of data generated.
2003-04-07
10,597 reads
Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.
2003-03-31
5,384 reads
What should SQL Server Central provide to the community in a review? Read on and give us some feedback so we can make this site better.
2003-03-24
3,523 reads
The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
2003-03-10
9,947 reads
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
2003-03-04
8,824 reads
A new series that examines how you audit activity in SQL Server. The first part looks at simple data auditing in a table.
2003-02-24
13,172 reads
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Most apps that call an LLM send every request to the same model. That...
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers