Who builds SQL Server? It's an interesting collection of individuals and we're looking to bring you some profiles of them all. In the first installment of this series Steve Jones interviews Euan Garden, longtime member of the team.
This article discusses three common problems DBAs are likely to encounter when columns have the identity property, which is defined as an attribute of int, smallint, bigint, decimal, numeric or tinyint columns that will auto-increment their value when data is inserted. These problems are humorously referred to as the identity crisis.
We are sorry to say that a case of plagiarism occurred recently and SQLServerCentral.com is issuing an apology to Ken Henderson.
A SQL Server DBA seems to be a stable job and many of us stick with the same job for an above average length of time. However employee retention in general is important to a strong and healthy company. Steve Jones starts a new series looking at this topic and why an employer might want to worry about retention.
Programmers, webmasters, Web services developers and database administrators (DBAs) are not strangers to the "Can we have it tomorrow?" request. That's why software and web developers have embraced a continuous stream of silver bullet technologies that promised to accelerate development. The developer community has experienced "web time", object-oriented programming (OOP), rapid application development (RAD), "extreme programming" and "agile development". Accelerated development schedules put a premium on understanding architecture and knowing how to match the tools to the job. That means understanding today's model of applications as services and what role a database can play. If you understand SQL technology, for example, you can adapt databases to application and service requirements by embedding logic in a database.
How many times have you wished you could throttle the CPU use of SQL Server? Or for a database? Prevent your developers from using too many resources while sharing the server with production or QA. ArmTech for Windows can do this and Dinsesh Asanka brings us a review of how this product worked in his environment.
Just a little older than SQLServerCentral.com, SQLTeam.com has been another great community for SQL Server developers. A look back from Bill Granazio
Moving DTS Packages from one SQL Server 2000 server to another can be a real hassle. There are any number of issues that occur whenever you seek to use a package on different servers. New author Jonathan Stokes brings us a technique he's used many times to build portable DTS packages.
SQL Server Integration Services (SSIS) is an enterprise-level data integration platform. SSIS is an entirely new subsystem in SQL Server 2005. This paper tells you how to take advantage of the SSIS management and deployment features.
How many of you have asked yourself what SQL is all about anyway? Join me as I begin a venture down the road of understanding SQL and how to take advantage of this language.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers