SqlServer-QA.net

With regard to the subject the delegate registration is now open:  To register please visit: http://developerdayscotland.com/main/DelegateRegistration/tabid/69/Default.aspx   To see the finalised agenda please visit:http://developerdayscotland.com/main/Agenda/tabid/68/Default.aspx   February 11 ...

Wow, its almost one year for me to talk about SQL Server Open World! Last year I have given 2 presentations on Effective usage of Database Mirroring & Business Continuity mesaures & practices, blog posts here for a ...

I have been following Dan Jones's blog on '' Launch_T-1, Launch_T-3 & Launch_T-5'' series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as per the schedule. Also you may be aware about 'postponement' of SQL Server  2008 version release ...

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual platform for BI & Relational Databases that are built in latest operating system with new ...

How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology (i.e. a single CPU socket that has more than 1 core appearing as multiple logical CPUs) is a ...

I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall IT costs which is the priority for any Enterprise, but at the same time one ...

Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings. There are pre-defined list of SQL Server 2005 recommendations and best practices to determine ...

As January 2008 almost getting finished that means 1 month in 2008 is reduced that brings the date to get RTM for SQL Server 2008. Before that the users (DBAs, Developers & Analysts) must get knowledge in making best use of SQL Server 2008 features within their platform. As we blogged earlier about VirtualTraining series for SQL Server 2008, ...

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual practice of checking of whether its a security issue to allow the logins, if so then goto ...

ITS Party time!!! Well I'm joking, its not a real-party time in the sense of food & drinks, its party time for Database world. Year 2008 entered already that kicks Microsoft gearing up for worldwide events, important ones. Release of Visual Studio 2008, Windows Server 2008 and SQL Server 2008!!! This brings most of the users in IT to ...