This article on the JoelonSoftware site discusses project management and customer expectations. It has a great discussion of why non-technical users place so much value on what they can see (the GUI) while developers place so much value in what can't be seen (yeah, the code!). It's actually more interesting than that, take a look!
2003-06-03
1,393 reads
This procedure shows you the MAC number of your Enthernet card in a format exactly the same as when running: ipconfig /all from command shell. Updated thx to Larry A.
2003-05-31
155 reads
Customers, employees, etc. come and go. They get entered multiple times in inconsistent formats in databases.This simple script finds the duplicates across multiple formats and is easily modified as needed. It's so easy, my grandmother could do it. Oops! No offense Grandma.For very large databases, create and join two temp tables indexed on the namedatetring […]
2003-05-30
217 reads
Dependency Walker has been around for a while as part of Visual Studio. Have you tried it? Got the latest version? Andy does a very quick run through of what the product does, why you might need it, where to get the latest version, and why the new version is better than the old one (isn't it always?).
2003-05-30
7,932 reads
This script is a fix to the "Script to determine if all chars are same in field"posted by Harvard Kinkead (hneal_98) . That script doesn't handle strings with trailing spaces (e.g. set @repeat = 'bbbb ')It happens because of the nature of Len function. To bypass this limitation my script concatenates one character to tested […]
2003-05-29
90 reads
This script will send a mail whenever it detects a Blocking process. You need SQL Mail configured on this server in order to use or you can specify the pager number @company.comEx:- 1234567789@Skytel.com
2003-05-29
1,839 reads
This procedure reports on table schema changes, any new or deleted tables since the previous run of the stored procedure.It only reports on tables owned by 'dbo'
2003-05-29
446 reads
This is a great site that lists all the free trade publications in various industries. You have to meet the criteria of course, but you should definitely check out the offerings.
2003-05-29
1,031 reads
This script creates the table ProfilerEventClass and populates it with the EventClasses and EventNames.This table is useful when working with trace tables, to get the event names by joining the tables on EventClass.
2003-05-25
564 reads
Retrieve the name of the current database for use with bcp and other procedures that require database name. This will help increase the portability of code and less maintenance required when migrating code to new database/server.
2003-05-22
218 reads
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Security on your SQL Server is important. That doesn’t need any explaining. But where...
It’s that time of year again! EightKB is back on August 20th at 13:00...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers