What do you do when you inherit a mess at work?
I have seen three common responses to database messes. My favorite is nuclear.
2016-12-06
236 reads
Technical Debt
RE: Using osql.exe cannot handle ascii extended characters
Hi Newbie, I have actually had an inverse of your experience where I have to use OSQL to handle our patch files that have extended ascii and Unicode characters. Could you post some sample data and a snippet of code that demonstrates your problem? -Jim
2005-04-14
RE: sp_who2 output
The easiest thing to do here is go to the sp_who2 proc (in master database) and alter it by uncommenting the order by in the dynamic SQL.
2005-04-06
RE: SQL Agent won''''t start
Brian,Thanks for your help. I ran netstat -an, I did not see the sql server listening. Here is a view of the log file for the primary server:2005-03-16 09:36:35.62 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: […]
2005-03-16
RE: Named Pipes
The app might have been an admin on the nondedicated machine and you were not aware of it. Being an admin and named pipes v TCP should not have anything to do with each other.
2004-11-29
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers