SQL SERVER – 2008 – Certification Path Complete Download PDF

Microsoft Certification are very important for any developer’s career. I personally have acquired MS certification before and while practicing for MS Certification I learned a lot personally. Developers who are interesting in upgrading themselves with Microsoft Certification must download certification path PDF.

Read More

SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL

I often receive a good question on the blog, however, I do not always receive a good answer for the questions. Recently someone asked on a blog about Finding next run time for Schedule Job using T-SQL. My friend came up with a nice script. I have modified it a bit to adjust needs. This blog post is about finding the next running time of scheduled job using T-SQL. 

Read More

SQL SERVER – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications

Microsoft SQL Server 2008 has hundreds of new and improved features, many of which are specifically designed for large scale independent software vendor (ISV) applications, which need to leverage the power of the underlying database while keeping their code database agnostic. This article presents details of the top 10 features that we believe are most applicable to such applications based on our work with strategic ISV partners. Along with the description of each feature, the main pain-points the feature helps resolve and some of the important limitations that need to be considered are also presented.

Read More

SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table

Recently I have been busy with interviewing many candidates for my organization. We are looking for some smart and experienced developers for some senior positions. I have wrote this previously SQL SERVER – Interesting Interview Questions. This blog post is about finding a table row count without using T-SQL.

Read More
Menu