Calculating Days of the Week and Accounting Months 5-4-4
Learn how to calculate days of the week based on the current date and how to calculate accounting months.
2007-01-12
3,468 reads
Additional Articles
Write PIVOT queries in SQL Server 2005
New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.
2007-01-11
5,731 reads
SQL Server 2005 Backups
If business today is data, then the entire enterprise is in the capable hands of you, the SQL Server DBA. Before you panic, check out Grant's detailed dissection of SQL 2005 backup and recovery regimes.
2007-01-10
3,302 reads
Pop Rivett's SQL Server FAQ No.5: Pop on the Audit Trail
Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables
2007-01-09
2,668 reads
SQL Server 2005 Integration Services - Part 39 - Send Mail Task
Among the most common tasks that have not yet been discussed in this series is the Send Mail task, which will be the topic of this article.
2007-01-08
2,394 reads
A Lap Around SQL Server 2005 Compact Edition
With a new name, new capabilities, and a new focus, the product formerly called SQL Server Mobile Edition expands its reach to small-footprint desktop applicationsand it's free!
2007-01-04
2,923 reads
Using Synonyms in SQL Server 2005
It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.
2007-01-03
3,795 reads
Security Enhancements in SQL Server 2005: Schema
Security has become more and more important in today's business environment. From the database point of view, DBAs and system administrators need an improved security model. SQL Server 2005 provides an improved security feature. It is claimed that SQL Server 2005 is secure by default. In SQL Server 2005, the security model is divided into three areas namely authentication, authorization, and encryption.
2006-12-29
2,741 reads
Processing event logs using DumpEvt and SQL Server
As a DBA, you can find very useful information in the Windows event logs. About important events, the health of your SQL Server and the operating system it runs on. Unfortunately, the logs also contain a lot of useless information. Some applications have a tendency to log hundreds of events every day, filling up the logs very quickly with info that you, as a DBA, do not need. But you still need to see that important message that informs you the server is going to crash if you don’t take action.
2006-12-28
2,298 reads
Checking SQLAgent service and starting it if not.
Because many programs I wrote depends on the SQL Agent Service and to really make sure that no one has configured this service to run manually (you see many things in life) I rely on this litle piece of code
2006-12-27 (first published: 2004-09-16)
219 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Layanan BCA KCU KALIMALANG Cs 0823-7497-7784
Wa:082374977784 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit, Kota...
Alamat Telp BCA KCU AMBON Cs 0823-7497-7784
Wa:082374977784 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku 97124
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers