Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.
A look at coding standards in SQL Server. The first part of this series deals with object naming standards.
On February 24th, 2005, Microsoft announced the new editions and pricing of SQL Server 2005. There have been quite a few changes and MVP Brian Knight has put down a comparison as well as details about which features are included with each. Read about the 4 new additions and see which one might be right for your next project.
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
Building robust functionality with maximum re-use of existing infrastructure and investment with little or no development is the goal for many businesses. This article is about using SQL Server DTS packages to achieve this goal. With minimum development, all the functionality required for data imports can be achieved with DTS programming in SQL Server.
Data cleansing is something that constantly occurs in all RDBMSes, not just SQL Server. However it's easier on some platforms than others. New Author Sureshkumar Ramakrishnan has written a script that shows how you can easily remove duplicate rows in SQL Server. Read about his technique and see if it might come in handy in your environment..
The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.
When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.
Another article from our own Chris Hedgate! This one looks at the different types of fragmentation that can exist inside your SQL Server and some ways you can go about minimizing them.
We crossed the 500,000 member mark last week and we're looking to give away some prizes!
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
I have an app that has an address field on the customer and the...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers