Adoption
Are lots of people adopting SQL Server 2008? Should you be looking at it? Steve Jones has a few comments on what the new lifecycle of SQL Server might mean for DBAs and developers.
From the Real World: SQL Server 2000 SP4 Installation Failure
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
Importing and exporting bulk data with the bcp utility
The SQL Server bcp utility can help administrators easily import or export bulk data between text files and SQL Server tables.
PASS Update #6
It's been pretty busy since my last post. Just in one week I had at least 12 hours devoted to PASS activities, and I'll share details of some of that here. To start with, I was able to mark another of my Q1 goals complete as Sanj from PASS HQ...
Perils of adding fields to database tables
Adding a field to a database table is sometimes not as simple as it may seem. If certain situations are not considered when adding fields, you may find yourself looking at some long nights fixing database code. Today, database consultant Tim Chapman looks at two such scenarios, and how you can plan for their occurrence.
Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
Creating and Modifying Tables in SSMS - SQL School Video
Learn how to use the SSMS GUI to modify tables in this SQL School video.
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers