Let us learn about Data Warehousing Interview Questions and Answers.
SQLAuthority News – Interesting Read – Programming Concepts, Structured Thinking Language (STL) and Relationary
I have always enjoyed reading articles and blogs which are different then others. There many be thousands of technology and programming blogs, only few makes difference in the tech world. One of the high quality blog, I enjoy reading is relationary by Grant Czerepak. Grant Czerepak is an IT professional…
Read MoreSQL SERVER – Data Warehousing Interview Questions and Answers – Introduction
Click here to get free chapters (PDF) in the mailbox This series is in response to many of my reader’s continuous request to start Data Warehousing Interview Questions and Answers series. This series is written in the same spirit as previous two series which has received good response. Samples Question…
Read More
SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation
Let’s learn about Server and Database Level DDL Triggers Examples and Explanation here. Let us learn more about this topic.
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 – UDF – Get the Day of the Week Function
The day of the week can be retrieved in SQL Server by using the DatePart function. The value returned by function is between 1 (Sunday) and 7 (Saturday). To convert this to a string representing the day of the week, use a CASE statement. Method 1: Create function running following…
Read More
SQLAuthority News – FQL – Facebook Query Language
I was exploring the new hype today, I found Facebook Developers Documentation very interesting. Facebook API can be queries using FQL – Facebook Query Language, which is similar to SQL.