Featured Article(s) Initialize to the day beginning (Vadivel Mohanakrishnan) This article explains the various ways of initializing a variable to the beginning of a day. Target audience for this is ‘Beginners to Intermediate’ level of readers. Tomorrow: New SelectViews show Today: [Watch] the current SelectViews here. Open source gotcha, discussion list watch, events and a LOT more… SQL Server Fortune […]

Featured Article(s) What To Do When you need to compare databases. Databases commonly, have their own tools with pre-made queries that make a comparison by making table crossing. However, sometimes the interfaces are not as comfortable as a spreadsheet software like MSExcel TM. With a couple of formulas and graphic help you could do a better job and your life […]

Featured Article(s) Understanding Authentication, Authorization and Impersonation in ASP.NET (Part I) Authentication, Authorization and Impersonation are three of the most important concepts that are related to ASP.NET Security. This series of two articles present these concepts in detail with code examples to illustrate the concepts covered. SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, […]

Featured Article(s) Tips for using SQL Server 2005 constraints (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 constraints. SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more. Also on the show, the 60-second SQL […]

SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more. Also on the show, the 60-second SQL Server tip of the day, upcoming events, the newsletter and discussion list watches and other goodies. Also Available [Watch Now] SQL on Call – answering […]