Pro T-SQL 2005 Programmer’s Guide (Paperback) Book Review
SQLAuthority News – Random Article from SQLAuthority Blog
It has been wonderful writing on this blog. Many times I visit my older articles and read them. One of my favorite feature on WordPress.com (where I host my blog) is Random Article Feature. I use it quite often to land on random page on my blog. It is really…
Read MoreSQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always
What is the difference between EXEC and EXECUTE? They are the same. Both of them executes stored procedure when called as EXEC sp_help GO EXECUTE sp_help GO I have seen enough times developer getting confused between EXEC and EXEC(). EXEC command executes stored procedure where as EXEC() function takes dynamic…
Read MoreSQLAuthority News – Scrum: Agile Software Development for Project Management
This is something I have learned while working for so many years as Project Manager. It is not as important to know how things are done but it is important to know how to get things done. Scrum is an Agile Software Development system which helps developers to get project…
Read MoreSQL SERVER – Frequency of SQL Server Reboot and Restart
This is very interesting question. I will keep the answer of this question very simple. First of all there is no scientific research or white paper I can backup my results with. Answer contains part simple observation and part experience. There is no need to reboot SQL Server. Once it…
Read MoreSQLAuthority News – Book Review – SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills
SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills (Paperback) by Joseph L. Jorden Link to Amazon Short Review: Microsoft’s new generation of certifications is design not only to emphasize your proficiency with a specific technology but also to prove you have the…
Read MoreSQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005
This article focuses on integration techniques specific to Microsoft Office Visio 2007 and Microsoft SQL Server 2005. Using Visio 2007, you can connect Visio shapes to data that was generated outside Visio. A large amount of data can be captured in a SQL Analysis Services database. Being able to analyze…
Read More