Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
2008-07-30
1,346 reads
Editorials
The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
2008-07-29
119 reads
Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
2008-07-28
498 reads
The More Things Change ...
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
2008-07-28
201 reads
Service Accounts
A Friday poll from Steve Jones looks at service accounts and how you deal with passwords.
2008-07-25
776 reads
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
2008-07-24
220 reads
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
2008-07-23
234 reads
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
2008-07-21
86 reads
The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
2008-07-21
47 reads
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
2008-07-18
383 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
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
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
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