SQLAuthority News – SQL SERVER 2008 – New Logo
Microsoft SQL Server 2008 has new logo. I really liked the new design. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – T-SQL Script to Devide One Column into Two Column
Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns. It was interesting that value of the column was variable and something dynamic needed to be written. Following is…
Read MoreSQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description
I like to help every candidate who are finding job. I have previously written article here which can help all the people who are looking for job or looking for candidates. SQL Server Interview Questions and Answers Complete List Download Find Job Related to SQL SERVER SQL Server DBA- Job…
Read MoreSQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2
I have written article about SQL SERVER – UDF – Get the Day of the Week Function. I have received good modified script from reader Mihir Popat has suggested another code where Sunday does not have to be necessary the first day of the week. CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME) RETURNS…
Read MoreSQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance
I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering…
Read MoreSQL SERVER – 2008 – Choosing the Right Edition for Your Needs
Enterprise SQL Server 2008 is a comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications. Standard SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications. Workgroup Run…
Read MoreSQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks
Note :Â Download PPT by Microsoft Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks The Windows Live Security team shares best practices – from platform and network security to incident management – in providing security for web applications and infrastructure. Organizations across the globe face…
Read More