SQL Server has two different ways to comment code.
SQL SERVER – 2008 – July CTP Released
SQL Server 2008 July Community Technology Preview has been released. With SQL Server 2008 July CTP release, customers can immediately utilize new capabilities that support their mission-critical platform and enable pervasive insight across the enterprise. SQL Server 2008 lays the groundwork for innovative policy-based management that enables administrators to reduce their time spent on maintenance tasks. SQL Server 2008 provides enhancements in the SQL Server BI platform by enabling customers to provide up-to-date information with Change Data Capture and MERGE features, and develop highly scalable analysis services cubes with new development environments.
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
Let us learn about Data Warehousing Interview Questions and Answers.
SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation
I was asked following questions when discussing security issues in meeting with off-shore team of large database consultancy company few days ago. I will only discuss one of the security issue was discussed accidental data modification by developers and DBAs themselves. Let’s learn about Server and Database Level DDL Triggers Examples and Explanation here.
SQL SERVER – UDF – Function to Get Previous And Next Work Day – Exclude Saturday and Sunday
While reading ColdFusion blog of Ben Nadel Getting the Previous Day In ColdFusion, Excluding Saturday And Sunday, I realize that I use similar function on my SQL Server Database. This function excludes the Weekends (Saturday and Sunday), and it gets previous as well as next work day.
SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup
This is very interesting error as I could not found any documentation on-line. It took me nearly 1 hour to figure out what was creating error.
SQL SERVER – Validate Field For DATE datatype using function ISDATE()
This article is based on the a question from Jr. Developer at my company. He works with the system, where we import CSV file in our database. One of the fields in the database is DATETIME field. Due to architecture requirement, we insert all the CSV fields in the temp table which has all the fields VARCHAR. We validate all the data first in temp table (check for inconsistency, malicious code, incorrect data type) and if passed validation we insert them in the final table in the database. Let us learn about ISDate function in this blog post.