Featured Article(s) Upload employee picture into a table (Vadivel Mohanakrishnan) This article explains one of the ways to upload an image into a table. The target audience of this article are ‘beginners to intermediate’ level of readers. SQL Server, The OS, Counters… It All Matters Keep track of the different key vital signs for your SQL Servers, from the various […]

New SelectViews Show Posted Need your help and opinion on a question in the show! We’ve just posted this week’s SelectViews show – I’m headed up to Microsoft later in the week and wanted to make sure we got the show out for you. Open source feedback, the SQL Server 2008 Slip, the 60-second SQL Server tip of the day […]

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 […]

Featured Article(s) Remove Time from a DateTime Column (Vadivel Mohanakrishnan) This article explains the way to get rid of ‘TIME’ part in a dateTime column. The target audience of this article are ‘beginners’. MySQL Acquisition, Sun and The Realities of Business On Friday, I wrote about my initial thoughts on the whole Sun/MySQL acquisition thing. I did receive some good […]

New 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 – […]

New SQL on Call Show Posted [Watch Now] Your Questions – the show today is all about answering viewer questions about SQL Server! Interview questions, what are the top 10 SQL Server tasks, working with management and more. Editor’s note: Sorry about the incorrect link to the show yesterday. Featured Article(s) Introducing Windows SharePoint Services Microsoft Windows SharePoint Services presents […]