Un-concatenating row values
/* Anith Sen's achievement, in his article 'Concatenating Row Values in Transact-SQL' has been to list and illustrate the many ways...
2008-10-06
1,729 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Never say 'never' to the WHILE loop.
/* download the test text file Moby-Dyck.zip here */
/* You might notice that I refer to Moby **** in this blog. This is because the busybodyish...
2008-10-02
2,201 reads
IT Project Euthanasia
A guest editorial from Phil Factor on the kindest way to dispose of unwanted IT projects.
2008-05-26
145 reads
Every DBA's nightmare
When a copy of all 25 million of the UK’s child benefit records, including bank details, went missing in the post, whilst being sent to the NAO (National Audit Office) on 18th October, the UK government must have known that a cover-up was impossible. This sort of incident is every DBA’s nightmare.
2007-11-26
154 reads
Blogs
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Forums
Dropping a Service from Service Broker crashes server
I'm having an issue trying to drop a service. When I issue the drop...
SQL MI - SQL Jobs failing with User Manager\ContainerAdministrator.
This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are...
Tempdb: is it being used?
hi so i have a really old application that is used to process data...
Ask SSC