Take a Seat
Bill Nicolich raises questions about the chairs we sit in all day as technology professionals.
2009-07-29
114 reads
Office
The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
2009-01-05
524 reads
The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
2009-01-05
538 reads
The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
2009-01-05
798 reads
Share Database Knowledge with Office and SQL Server
Longtime SQL Server expert Bill Wunder has written a very interesting article on how to share knowledge among IT staff using the tools you already have in your organization.
2008-08-06
6,587 reads
RE: After sp3a I can't save changes to dts packages
Assuming you are using local repository, dts packages have a feature whereby saving them reverts ownership back to whomever initially created the package (its saved in the BLOB) despite changing dts package ownership with the procedure msdb..sp_reassign_dtspackageowner. Last I heard, this will not get corrected until Yukon. Hope that was useful.
2003-06-23
RE: Compare with Different Collations
You need to make sure that both the right and the left are using the some collation when comparing. Here is an example that works, because the column on the right is converted to the collation of the left column by using the collate clause. create table #a (char_set1 varchar(50) collate Latin1_General_CI_AS) create table #b(char_set2 […]
2003-06-09
RE: Compare with Different Collations
The collation error is occuring on a WHERE t1.text <> t2.text Collation .... It says it can't resolve it. KlK, MCSE
2003-06-09
RE: Why DTS Package Not Run in Win98?
Are the dbf files on the 98 machine or a remote machine? And have you made sure all active connections in the file have cleared. May be locked by another process and DTS just cannot lock it down.
2003-06-09
1 reads
RE: Error Handling / Return Values
Example from BOL. C. Use @@ERROR to check the success of several statements This example depends on the successful operation of the INSERT and DELETE statements. Local variables are set to the value of @@ERROR after both statements and are used in a shared error-handling routine for the operation. USE pubs GO DECLARE @del_error int, […]
2003-05-27
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
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