Quickshift and SQLServerCentral.com Database Performance Survey
If you live in the US, take a few minutes for this performance survey and you could win an Amazon gift certificate.
2005-08-02
3,266 reads
Articles
SQL Server Integration Services - Part 5
We will continue our review of Foreach enumerators starting with Foreach ADO, since this one probably qualifies as the most popular choice in its category. This is due to the fact that ADO recordsets offer a convenient way of dealing with data sources, regardless of their type (for example, within SSIS, you can easily populate a recordset by executing a SQL query or by reading the content of a flat file)
2005-08-01
1,791 reads
Attack of the predatory sales force
Most skilled professionals—be they butchers, bakers or software makers—take pride in selecting their own tools of the trade. Why is it then that developers and DBAs in large corporations often are not afforded the same professional courtesy or opportunity? The tools they use are just as vital to their livelihood, yet when it comes to high-cost software, developers and DBAs often have no input into what is purchased for their use.
2005-07-29
2,572 reads
SQL Server Spotlight - Euan Garden
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.
2005-07-28
4,360 reads
The identity crisis in replication
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.
2005-07-28
3,765 reads
Apologies to Ken Henderson
We are sorry to say that a case of plagiarism occurred recently and SQLServerCentral.com is issuing an apology to Ken Henderson.
2005-07-27
16,162 reads
Employee Retention
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.
2005-07-27
12,921 reads
SOA, Multi-Tier Architectures and Logic in the Database
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.
2005-07-27
2,811 reads
Review Armtech for SQL Server
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.
2005-07-26
5,480 reads
SQLTeam.com: Five Fabulous Years
Just a little older than SQLServerCentral.com, SQLTeam.com has been another great community for SQL Server developers. A look back from Bill Granazio
2005-07-26
1,913 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers