This funciont return a date without end-of-week , it is useful to calculate a new date for any payment!YOU CALL with 'dias_uteis(getdate(), 5)' and will get five useful days after today
2006-01-17 (first published: 2005-12-22)
93 reads
Despite a growing range of options for integrating mixed database environments, some companies are sidestepping the problem by moving to a single database platform.
2005-12-16
2,322 reads
This script will create a single-line ALTER TABLE statement for each column in any table to change the collation to match the 'database default'. This is best accomplished in the Query Analyzer -- simply run the script, select all the records, and paste them into a new window to run them.
2005-12-29 (first published: 2005-12-12)
2,243 reads
2005-12-30 (first published: 2005-12-09)
145 reads
The final installment of Steve Jones' series on employee retention. This one examines the employee point of view in looking for and finding the ideal job, which you will then want to look at the other techniques to ensure you are employed for a long time.
2005-12-08
6,917 reads
This VB script allows you to search DTS packages for keywords, etc. It is also useful for quickly locating what server a given package is on. This is very useful for debugging. Example - you want to know the name of every DTS package the touches a certain table. The text files generated contain the […]
2006-01-18 (first published: 2005-12-07)
6,014 reads
Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.
2005-12-05
3,803 reads
Data, information, and knowledge. They're all different concepts and we sometimes lose sight of the fact that there are differences. This is a good look at the difference.
2005-11-14
2,393 reads
Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a lot of information on the little guy. To that end, new author Tim Mitchell brings us a great overview on what you should consider when setting up a SQL Server environment for a small scale setting.
2005-11-14
8,235 reads
This script has been on the SQL Server Central site for a while and has been revised a number of times. I enclose yet another revision that works with SQL Server 2005 (June CTP anyway) with much thanks to all those who have contributed to it in the past.Terry Grignon
2006-02-08 (first published: 2005-11-11)
1,091 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers