Agile Development and ICONIX
Lightweight and adaptable, but with proper emphasis on the design phase, the ICONIX methodology can help you avoid Constant Refactoring After Programming...
Further Your Career
Training is an important part of anyone's life in technology, especially if you are a SQL Server DBA or developer. With the release of 2005, the entire paradigm of working with SQL Server has changed and you need to be working on your own personal knowledge base. Steve Jones takes a look at how you can get training and shake the funding loose as well.
To SP or not to SP in SQL Server: an argument for stored procedures
A seemingly never-ending battle in online database forums involves the question of whether or not database application development should involve the use of stored procedures.
Management Issues - SSAS 2005
For those of you using Analysis Services, Yaniv Mor takes a look at some of the manageablity tools with SQL Server 2005. The way you work with Analysis Services and your cubes has changed dramatically and this is a good overview to get you started.
The May SQL Server Standard
Better late than never, here's a look at the May issue of the SQL Server Standard, now available as a PDF.
Quickly Viewing Available Space
As everyone moves to SQL Server 2005 from SQL Server 2000, there are quite a few pieces of information that have moved and may give you trouble finding. Boris Balinger brings us a followup to his first look at some of those changes with a quick article on how you can get the free space in your database files.
Strategy, Tactics, and Business Intelligence
There is a lot of talk these days about “business intelligence” (BI for short). Pick up any magazine aimed at business or technology professionals, and you’re sure to read about things like data warehouses, dashboards, cubes, ETL, SCD, and a seemingly endless list of other specialized terms and acronyms. One might be left wondering, is this something to which I should be paying attention?
XML - Good and Bad
XML is becoming more and more the mainstream for data transfers between systems. Web services and SOAP communications are built into SQL Server 2005, requiring the more and more DBAs understand how to work with XML. Raj Vasant has written a number of articles on XML and brings us a look at how XML should and should not be used.
Jacksonville Free HA Event From Microsoft and SQLServerCentral.com
If you're in Jacksonville next week, whether you’re a developer, DBA or manager, you’ll get something out of this all day SQL Server free event. This event is being run with Microsoft and Idea Integration (Brian from SQLServerCentral.com) and will be at a detailed tech level (no marketing). This all-day session is designed to Get You Started with Microsoft SQL Server 2005 High Availability and gotchas when upgrading to 2005. High availability is a hot topic for most enterprise customers. Any application downtime can impact your business, resulting in revenue loss, customer dissatisfaction, and damaging creditability of their business. These 300 Level sessions will be mostly demos! When you leave this, you should know how to mirror a database and cluster. RSVP required.
SQL Server Performance Testing
This (new) design bothered me. It violated one of the fundamentals that I'd learned and read about for years; namely keeping the primary key small and narrow. It also looked like it would be difficult to maintain. Finally, after arguing back and forth about the merits and drawbacks of each of the designs, we decided that testing them was the only way to be sure
Blogs
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...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Forums
MBOX Email Conversion for Backup: Which Format Is Best?
I have several important email accounts stored in MBOX format from clients like Thunderbird...
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