MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

March 2009 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Syndication

News

Blog Archive List

Sort by: Most Recent | Most Viewed | Most Commented

Filling random passwords - Set based approach

In this post , I showed a way to generate 8 characters random password If you have table with data and add a column for password and want to fill that column with random passwords , you can use this approach. I have seen the usage of a function that generates...

Published Mon, Mar 30 2009 9:23 by SqlServer-QA.net

Filed under: sql server, random password, T-SQL
SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation.

The error message posted on the subject above refers to install relevant client tools or services in order to continue the task you are running. You may be aware that SQL Server setup offers installation of various services such as Analysis Services,...

Published Mon, Mar 30 2009 9:16 by SqlServer-QA.net

Filed under: sql server, ssis, maintenance plan, backups, integration services, versions
Get a mixture of Technical content from MIX09 sessions

MIX & PDC, 2 popular and catchy conferences for Developers in IT world! I favour MIX conference more than PDC as you get to know in-depth knowledge & features about cloud computing, .NET services and other major exciting developing technologies...

Published Tue, Mar 24 2009 12:55 by SqlServer-QA.net

Filed under: sql server, microsoft, developer, best practices, conference, mix, pdc, sql server 2005
Sharepoint and ASP.Net MVC …

Codeplex has another interesting project where the owner tried to combine ASP.Net MVC with Sharepoint technology. Sharepoint MVC is a helper project used to host ASP.Net MVC in Sharepoint 2007. Eventhough ASP.Net MVC can be hosted from any asp.net website...

Published Tue, Mar 17 2009 9:47 by SqlServer-QA.net

Filed under: sharepoint, MVC
All set to go for Developer Day Scotland in May 2009

In continuation to Developer Day Scotland session submission & registration get ready to register to attend on May 02nd 2009, that consists with action-packed agenda for all IT professionals. Click here to register your interest for this event......

Published Tue, Mar 17 2009 5:35 by SqlServer-QA.net

Filed under: sql server, community, events, conference, scotland, registration, developerday
SQL Server Deadlock and Trace Flag 1204 and 1222- a big question every time

I have seen few users out there thinks that Deadlocks in SQL Server is a bug which has not be corrected by Microsoft since its release! Even few times they get think that deadlocks and blocking are similar reactions in SQL Server, a typical situation...

Published Tue, Mar 17 2009 2:03 by SqlServer-QA.net

Filed under: sql server, performance, indexes, i/o, best practices, locking, deadlock, monitoring, beginner
SQL Server 2008 Service Pack 1 CTP

Its over half-year that SQL Server 2008 has been RTM'd and now it is time to test the CTP (Community Technology Preview) aka beta version of Service Pack 1 for this version. Absolutely right, for those of you waiting to try SQL Server 2008 until SP1...

Published Sun, Mar 8 2009 10:33 by SqlServer-QA.net

Filed under: sql server, dba, download, ctp, best practice, testing, service pack1
Behavior Changes to Database Engine Features in SQL Server 2008

Updated Point on BOL is available at http://msdn.microsoft.com/en-us/library/ms143359.aspx...( read more ) Read More...

Published Sat, Mar 7 2009 4:24 by SqlServer-QA.net

Filed under: sql server, behaviour changes, T-SQL
Which columns uniquely identify a row?

Without seeing the table structure,If you are interested in knowing which columns uniquely identify a row in a table, you can use this system procedure EXEC sp_special_columns table_name...( read more ) Read More...

Published Fri, Mar 6 2009 3:58 by SqlServer-QA.net

Filed under: sql server, T-SQL, sp_special_columns
Beware of the Usage of SET ROWCOUNT

This is used to set the number of rows affected for DML Declare @test table ( number int ) set rowcount 1 insert into @test select 11 union all select 10 set rowcount 0 select number from @test The above inserts only one row to the table variable @test...

Published Wed, Mar 4 2009 3:28 by SqlServer-QA.net

Filed under: sql server, rowcount, T-SQL
This Techie never stops blogging!

I wonder the energy of Pinal Dave my fellow MVP never runs out like the SQL Server , I name him as Duracell Bunny . This year's MVP Global Summit 2009 in Seattle is the place where we happen to meet each other and in next few hours it is blogged SQLAuthority...

Published Mon, Mar 2 2009 8:52 by SqlServer-QA.net

Filed under: sql server, microsoft, mvp, summit, professionals
SQL Server related Events and Webcasts

MSDN Webcast: Building Applications with SQL Server 2008 (Level 100) Microsoft SQL Server 2008 adds numerous new capabilities for developers, from support for spatial data types to a mechanism to store SQL BLOB data using the NTFS file system and several...

Published Mon, Mar 2 2009 7:09 by SqlServer-QA.net

Filed under: sql server, event, learning, implementation, certification, webcasts
Find out deprecated features within SQL Server 2008 using PROFILER

When I had a task to look for the method to find out what features are Deprecated (which means that feature will not included in next release of SQL Server) in the engine. As a first point of resource I referred through BOL to find the list of deprecated...

Published Mon, Mar 2 2009 3:18 by SqlServer-QA.net

Filed under: sql server, perfmon, profiler, upgrade, features, best practice, extended events, event class, deprecated features

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

March 2009 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Filling random passwords - Set based approach

SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation.

Get a mixture of Technical content from MIX09 sessions

Sharepoint and ASP.Net MVC …

All set to go for Developer Day Scotland in May 2009

SQL Server Deadlock and Trace Flag 1204 and 1222- a big question every time

SQL Server 2008 Service Pack 1 CTP

Behavior Changes to Database Engine Features in SQL Server 2008

Which columns uniquely identify a row?

Beware of the Usage of SET ROWCOUNT

This Techie never stops blogging!

SQL Server related Events and Webcasts

Find out deprecated features within SQL Server 2008 using PROFILER