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 MoreSQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide
If you have one or more years of experience in any web based programming language (.NET, ColdFusion, PHP) and interested in SQL Server as well willing to locate Ahmadabad, India. Please send me your resume, if selected you may get chance to work with one of the most progressing industry…
Read MoreSQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt
Very frequently I use following command prompt script to start and stop default instance of SQL Server. Our network admin loves this commands as this is very easy. Click Start >> Run >> type cmd to start command prompt. Start default instance of SQL Server net start mssqlserver Stop default…
Read MoreSQL SERVER – UDF – User Defined Function – Get Number of Days in Month
Following User Defined Function (UDF) returns the numbers of days in month. It is very simple yet very powerful and full proof UDF. CREATE FUNCTION [dbo].[udf_GetNumDaysInMonth] ( @myDateTime DATETIME ) RETURNS INT AS BEGIN DECLARE @rtDate INT SET @rtDate = CASE WHEN MONTH(@myDateTime) IN (1, 3, 5, 7, 8, 10,…
Read More