SQL Server Archives - Page 375 of 393 - SQL Authority with Pinal Dave

SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar

June 8, 2007

In analytics section of our product I frequently have to display the current week dates with days. Week starts from Sunday. We display the data considering days as column and date and other values in column. If today is Friday June 8, 2007. We need script which can provides days…

SQL SERVER – 2005 Download New Updated Book On Line (BOL)

June 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Book On Line the primary source for help for many developers has been updated. It now includes the updates till SP2 release. I use book on line for accuracy for my definition and information on this blog. Download Book On Line (Update June 4th, 2007) Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2008 (Katmai) June CTP Released – Improvement Pillars – Diagram

June 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download

I received quite a few emails in last three days for not mentioning on my blog about SQL Server 2008 (Katmai) CPT June is released. The reason I did not mentioned because I was busy with my mini series SQL SERVER – Database Coding Standards and Guidelines Complete List Download.…

SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.

June 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, , SQL Scripts

Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again. This is quite a famous error and I was asked to write about it by couple of readers. The reason I was not writing about this as the solution of this error…

SQL SERVER – 2005 Explanation and Example – SELF JOIN

June 3, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

A self-join is simply a normal SQL join that joins one table to itself. This is accomplished by using table name aliases to give each instance of the table a separate name. Joining a table to itself can be useful when you want to compare values in a column to…

SQL SERVER – 2005 – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005 – Download SQL Server MOM 2005

June 2, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local and remote connectivity checks help ensure database availability. Features…

SQLAuthority News – Subscribe to Feed in Email

June 2, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

You can subscribe to SQLAuthority.com Feed using Email. Email will be delivered to your preferred email address when new post appears on SQLAuthority.com Subscribe to SQLAuthority Feed Through Email Reference : Pinal Dave (https://blog.sqlauthority.com)