Skip to main content

Posts

Showing posts with the label SQLServer2012

SQL Server 2012 in a virtual machine on Windows Azure

ืื ื™ ืืชื—ื™ืœ ื“ื•ื•ืงื ืžื”ืกื•ืฃ… ืื›ืŸ ื”ืชืจืฉืžืชื™ – ื›ืœ ื”ื›ื‘ื•ื“ ืœืžื™ืงืจื•ืกื•ืคื˜ ืขืœ ื”ืขื‘ื•ื“ื” ื”ื˜ื•ื‘ื”, ืขืœ ื”ืคืฉื˜ื•ืช ื•ืขืœ ืฉื™ื ื•ื™ ื”ืชืคื™ืกื”. ื—ืฉืงื” ื ืคืฉื• ืฉืœ ื›ืœ ืื—ื“ ื•ืื—ืช ื‘ SQL Server ืขืœ ื”ืขื ืŸ – ืงื™ื™ืžืช ืขืชื” ืืคืฉืจื•ืช ืฉืœื™ืฉื™ืช (ืžืœื‘ื“ SQL Azure  ื•ืžืœื‘ื“Amazon RDS). ืžื™ืงืจื•ืกื•ืคื˜ ื ื•ืชื ืช ืืคืฉืจื•ืช, ื“ืจืš ื”ืคื•ืจื˜ืœ ื”ื—ื“ืฉ, ืœื”ืจื™ื ืžื›ื•ื ื” ื•ื™ืจื˜ื•ืืœื™ืช - virtual machine  ื”ืžื›ื™ืœื” SQLServer2012. ื•ื–ื” ืขื•ื‘ื“…. ืจื‘ื•ืชื™ ื–ื” ืขื•ื‘ื“. ื‘ืœื—ื™ืฆื” ืขืœ ื›ืžื” ื›ืคืชื•ืจื™ื ืืชื” ืžืจื™ื ืžื›ื•ื ื” ืœืคื™ ื’ื•ื“ืœ ื•ื—ื•ื–ืง ืฉืืชื” ื‘ื•ื—ืจ ื•ื™ืฉ ืœืš ืžื›ื•ื ื” ืขื SQLServer2012 ืžื•ืชืงืŸ ื•ืขื•ื‘ื“ – ื›ืžืขื˜ ื‘ืชืฆื•ืจื” ืžืœืื”. ืื– ื ื›ื•ืŸ ืฉื”ื’ื™ืข ื”ื–ืžืŸ ืœืขืฉื•ืช ื˜ื‘ืœืช ื™ืชืจื•ื ื•ืช ื•ื—ืกืจื•ื ื•ืช ืฉืœ 3 ื”ืฉื™ื˜ื•ืช ื”ืœืœื• – ื•ื ื›ื•ืŸ ืฉืื ื™ ืขื“ื™ื™ืŸ ื—ื•ืฉื‘ ืฉ SQLAzure ื”ื•ื ืคืชืจื•ืŸ ืžื“ื”ื™ื, ื•ื”ื•ื ื”ื“ืจืš ื”ื ื›ื•ื ื” ืœืขื‘ื•ื“ื” ื‘ืขื ืŸ – ืขื“ื™ื™ืŸ ืœืฉืžืจื ื™ื, ืื• ื™ืฉ ืœื•ืžืจ ืœื—ื“ืฉื ื™ื™ื – ื ื™ืชื ืช ืืคืฉืจื•ืช ืœืขื‘ื•ื“ื” ืจื’ื™ืœื” ื•ืžื•ื›ืจืช ื‘ SQL Server ืจื’ื™ืœ. ื›ืœ ืฉื ื•ืชืจ ืื—ืจื™ ื”ืœื—ื™ืฆื•ืช ื•ื”ื”ืคืขืœื•ืช ื”ื•ื ืœืงื ืคื’ ืืช ื”ืžื›ื•ื ื” ืœืจืฉืช ืฉืœืš ืžืชื•ืš ื”ืžื›ื•ื ื” ืขืฆืžื” ื•ืื– ืœื”ืชื—ื‘ืจ ืืœื™ื” ืžื‘ื—ื•ืฅ… (ืื ืœื ืชื‘ืฆืข ืืช ื–ื” ื™ื”ื™ื” ืืคืฉืจ ืœืขื‘ื•ื“ ืขืœื™ื” ืžื‘ืคื ื™ื ื‘ืฆื•ืจื” ืจื’ื™ืœื”). ื•ืขื›ืฉื™ื• ืœื”ืชื—ืœื”: ื‘ืคื•ืจื˜ืœ ื”ื—ื“ืฉ – ืฉืกืงืจืชื™ ื‘ืงืฆืจื” ื‘ืคื•ืกื˜ ื”ืงื•ื“ื, ืœื•ื—ืฆื™ื ืขืœ ื™ืฆื™ืจืช ืžื›ื•ื ื” ื•ื™ืจื˜ื•ืืœื™ืช… ืœืื—ืจ ืžื›ืŸ ื™ื•ืฆืจื™ื ืืช ืกื•ื’ ื”ืžื•ื›ื ื” ื”ืจืฆื•ื™...
Post a Comment
Read more

New Azure Portal–Features, news and SQL

ื‘ืกื•ืฃ ืฉื‘ื•ืข ืฉืขื‘ืจ ื™ืฆืื” ืžื™ืงืจื•ืกื•ืคื˜ ื‘ื”ื›ืจื–ื” ื—ื’ื™ื’ื™ืช ื‘ื“ื‘ืจ ื”ื—ื™ื“ื•ืฉื™ื ื”ืื—ืจื•ื ื™ื ืฉื”ืขืœื• ืœืขื ืŸ. ืื ื• ื ืกืงื•ืจ ื‘ืคื•ืกื˜ ื–ื” ื›ืžื” ื—ื™ื“ื•ืฉื™ื – ืขื ื”ืชืžืงื“ื•ืช ื‘ืขื•ืœื ื‘ืกื™ืกื™ ื”ื ืชื•ื ื™ื. ืจืืฉื™ืช ืืชื—ื™ืœ ื‘ืคื•ืจื˜ืœ ื”ื ื™ื”ื•ืœ ืขืฆืžื• ืขื“ ื”ื™ื•ื ื”ื™ื” ื”ืคื•ืจื˜ืœ ืœื ื™ื”ื•ืœ ื”ืขื ื™ื™ื ื™ื ื‘ืขื ืŸ ื›ืชื•ื‘ ื‘ silverlight, ืžืขืชื” ื”ืคื•ืจื˜ืœ ื›ืชื•ื‘ ื‘ HTML 5 ื›ืœื•ืžืจ ื ื™ืชืŸ ื™ื”ื™ื” ืœื ื”ืœ ืขืชื” ื’ื ื‘ื˜ืื‘ืœื˜ื™ื ื•ื‘ืขื•ื“ ืžื›ืฉื™ืจื™ื. ื‘ื—ืฅ ื”ื›ืชื•ื ื›ื ื™ืกื” ืœืคื•ืจื˜ืœ ื”ืงื™ื™ื ื‘ื—ืฅ ื”ื™ืจื•ืง ื›ื ื™ืกื” ืœืคื•ืจื˜ืœ ื”ื—ื“ืฉ ืœืื—ืจ ืœื—ื™ืฆื” ืขืœ ื”ื—ืฅ ื”ื™ืจื•ืง ื ื›ื ื™ื ืœืžืกืš ืฉืžื›ื ื™ืก ืื•ืชืš ืœืคื•ืจื˜ืœ ื”ื—ื“ืฉ – ื ื™ืชืŸ ืœื”ื™ื›ื ืก ืืœื™ื• ื™ืฉื™ืจื•ืช ื“ืจืš: https://manage.windowsazure.com/ ื”ืคื•ืจื˜ืœ ื”ื—ื“ืฉ ืžื—ื•ืœืง ืœ3 ืื–ื•ืจื™ื ืžืจื›ื–ื™ื™ื, ื‘ืื™ื–ื•ืจ ื”ื™ืจื•ืง ืจืฉื™ืžื” ืฉืœ ื›ืœ ื”ืจื›ื™ื‘ื™ื ื”ืืคืฉืจื™ื™ื, ื‘ืื™ื–ื•ืจ ื”ืฆื”ื•ื‘ ืคื™ืจื•ืฉ ืฉืœ ื”ืจื›ื™ื‘ื™ื ืขืฆืžื ื•ื‘ืื™ื–ื•ืจ ื”ืื“ื•ื ืœื•ื—ืฆื™ื ืื ืจื•ืฆื™ื ืœื”ื•ืกื™ืฃ ืจื›ื™ื‘ื™ื ืœืžืขืจื›ืช ื‘ืขื ืŸ. ื›ืืฉืจ ืœื•ื—ืฆื™ื ืขืœ ืจืฉื•ืžื” ื‘ืื™ื–ื•ืจ ื”ืฆื”ื•ื‘ ืžืงื‘ืœื™ื ืคื™ืจื•ื˜ ืขืœ ื”ืจื›ื™ื‘ ืฉืœื—ืฆื ื• – ืžื‘ื—ื™ื ืช ื‘ื™ืฆื•ืขื™ื ื•ื›ื“ื•ืžื” – (ืคื™ืจื•ื˜ ืื‘ื™ื ืคืขื ืื—ืจืช) ืื™ืŸ ืžื” ืœื•ืžืจ – ื™ืคื” ื•ืคืฉื•ื˜.. ืื ืœื•ื—ืฆื™ื ืขืœ ื” + ื‘ืื™ื–ื•ืจ ื”ืื“ื•ื ืงื•ืคืฆืช ืจืฉื™ืžื” ืฉืœ ืจื›ื™ื‘ื™ื ืฉืืคืฉืจ ืœื”ื•ืกื™ืฃ ืœืคื™ ื”ื”ืจืฉืื•ืช ืฉืœืš ื‘ืขื ืŸ ืขื“ ื›ืืŸ ื”ืคื•ืจื˜ืœ ื”ื—ื“ืฉ ืžืžืฉ ื‘ืงื™ืฆื•ืจ ื ืžืจืฅ ื•ืขืชื” ืื‘ื™ื ื’ื ื›ืŸ ื‘ืงืฆืจื” ืขืœ 2 ื—ื™ื“ื•ืฉื™ื ืžืจื›ื–ื™ื™ื ืฉืฉื•ื—ืจืจื• ื‘ื’ื™ืจืกืช ...
Post a Comment
Read more

SQLAzure and SqlServer2012 a Conspiracy of silence Part 2 (and today about T-SQL)

ืฉืœื•ื ืœื›ื•ืœื ื•ื‘ื›ืŸ ืฉื ืช 2012 ื ื›ื ืกืช, ืฉื ืช ื” - SQL Server 2012, ืžืชื•ื›ื ื ื™ื ืขืจื‘ื™ ื”ืฉืงื” ื‘ื›ืœ ื”ืขื•ืœื ื•ื”ืฉื™ื•ื•ืง ืžืืกื™ื‘ื™ ื›ืชืžื™ื“. ืื ืฉื™ ื”ืขื ืŸ ืื• ืืœื• ื”ืžืฉืชืžืฉื™ื ื‘ SQL Azure, ื™ื›ื•ืœื™ื ื›ื‘ืจ ืขื›ืฉื™ื• ืœื”ื™ื ื•ืช ืžื™ืชืจื•ื ื•ืชื™ื• ืฉืœ SQL Server 2012, ื•ื‘ Production.  ื‘ืคื•ืกื˜ ื”ืจืืฉื•ืŸ ื”ื‘ืืชื™ ื“ื•ื’ืžื ืงื˜ื ื” ืฉืœ ื”ืคืงื•ื“ื” TRHOW. ื”ื™ื•ื ืื‘ื™ื ื›ืžื” ื“ื•ื’ืžืื•ืช ืœืคืงื•ื“ื•ืช ืฉื ื™ืชืŸ ืœื”ืฉืชืžืฉ ื‘ื”ืŸ: 1. IIF – ื–ื•ื”ื™ ืคืงื•ื“ื” ื—ื“ืฉื” ืฉื ื›ื ืกื” ื‘ 2012 ื•ืžื˜ืจืชื” ืœื”ื—ื–ื™ืจ ื ืชื•ืŸ ื‘ืžื™ื“ื” ื•ืžืฉืคื˜ ืžืกื•ื™ื ื™ื•ืฆื ืืžืช ืื• ืœื ื™ื•ืฆื ืืžืช – ื”ืกื™ื ื˜ืงืก ืฉืœื• ื”ื•ื IIF([boolean expression], [true value], [false value]) ื•ืœื›ืŸ ืื ื”ืžืฉืคื˜ ื”ื‘ื ื™ื•ืจืฅ ื‘ Azure ื”ื•ื ื™ื—ื–ื™ืจ ืชื•ืฆืื” ื•ืœื ืฉื’ื™ืื”. select    IIF(1=1, 'T','F') 2. ืฉื™ืžื•ืฉ ื‘ืคื•ื ืงืฆื™ื” EOMONTH – ื”ืžื—ื–ื™ืจื” ืืช ื”ื™ื•ื ื”ืื—ืจื•ืŸ ืฉืœ ื”ื—ื•ื“ืฉ 3.  ื•ืื—ืจื•ื ื” ื—ื‘ื™ื‘ื” ืœื”ื™ื•ื ืคื•ื ืงืฆื™ื” ื‘ืฉื CONCAT ื”ืžื‘ืฆืขืช ื—ื™ื‘ื•ืจ ื‘ื™ืŸ ืกื˜ื™ืจื ื’ ืœืžืกืคืจ ืœืœื ืฆื•ืจืš ื‘ื”ืžืจื” SELECT 'SQL Server ' + CAST(2012 as varchar(10)), CONCAT( 'SQL Server ' ,2012) ื–ื• ืคืงื•ื“ื” ืฉืžื‘ืฆืขืช ืืช ืื•ืชื• ื”ื“ื‘ืจ…. ืื– ื”ื ื” 3 ื“ื•ื’ืžืื•ืช ืงื˜ื ื•ืช ืขืœ ื”ืงืฉืจ ื‘ื™ืŸ SQLServer 2012 ืœื‘ื™ืŸ SQL Azure. ืฉืชื”ื™ื” ืœื›ื•ืœื ื• ืฉื ื” ืžื•ืฆืœื—ืช
Post a Comment
Read more

SQL Azure and SqlServer 2012 a Conspiracy of silence

ืฉืœื•ื ืจื‘ ื•ื‘ื›ืŸ ื’ืจืกืช sqlserver 2012 ืžืชืงืจื‘ืช ื•ืžืชืงืจื‘ืช, ื”ืฉืžื•ืขื•ืช ืžื“ื‘ืจื•ืช ืขืœ ืื—ืช ื”ื™ืฆื™ืื•ืช ืœืื•ื•ื™ืจ ื”ื’ื“ื•ืœื•ืช ื‘ื™ื•ืชืจ ืฉืœ ืžื•ืฆืจ ืžื‘ื™ืช Microsoft, ื•ืœื ื• ืื ืฉื™ ื” SQL Azure ืžื” ื ื•ืชืจ ืœืขืฉื•ืช? ืœื—ื™ื™ืš ื‘ื—ื™ื•ืš ื•ืœื•ืžืจ - ืจื‘ื•ืชื™ ืœื ื• ื›ื‘ืจ ื™ืฉ ืืช ื–ื” ื‘ Production... ื•ืขืœ ืžื” ืื ื™ ืžื“ื‘ืจ? ื•ื‘ื›ืŸ ื›ื™ื“ื•ืข ื›ืืฉืจ ื™ื•ืฆืืช ื’ื™ืจืกื” ื—ื“ืฉื” ืฉืœ ืžื•ืฆืจ ืžื‘ื™ืช ืžื™ืงืจื•ืกื•ืคื˜ ื™ืฉื ื• ืชื”ืœื™ืš ืฉืœื ืฉืœ ื™ืฆื™ืื” ืœืื•ื•ื™ืจ ื”ืขื•ืœื - ื”ื—ืœ ื‘ืงืจื™ืืช ืฉื ืœืžื•ืฆืจ, ืขื‘ื•ืจ ืœืฉืœื™ื—ืช ืžืกืคืจ ื“ื•ื’ืžืื•ืช ื•ื”ืžืฉืš ื‘ืฉื—ืจื•ืจ CTP ืฉื•ื ื™ื . ื’ืจืกืช SQLServer2012 ืขื•ืžื“ืช ืœืฆืืช ื•ืชืกืคืง ื”ืžื•ืŸ ื—ื™ื“ื•ืฉื™ื ืฉื ื™ืชืŸ ืœืงืจื•ื ืขืœื™ื”ื ืžื›ืืŸ ื•ืขื“... ื”ืขื ืŸ ืื•ืœื™... ืžื‘ื—ื™ื ืช ื” DBA's ื”ืืคืœื™ืงื˜ื™ื‘ื™ื ืžื“ื•ื‘ืจ ื‘ืขื™ืงืจ ืขืœ ืคืงื•ื“ื•ืช ื—ื“ืฉื•ืช ื•ืขืœ ื—ื™ื“ื•ืฉื™ื ื‘ืฉืคืช ื” T-SQL. ื›ื•ืœื ืžืฆืคื™ื ื‘ืงื•ืฆืจ ืจื•ื—. ืžื™ ืœื ื–ื•ื›ืจ ืื™ืš ืื™ ืฉื ื‘ืฉื ืช 2005 ื—ื™ื›ื™ื ื• ืœ TRY and Catch ืฉืขื•ืœื ื” SQL Server ื—ื•ื•ื” ืœืจืืฉื•ื ื”, ืžื™ ืœื ื–ื•ื›ืจ ืืช ืฉื ืช 2008 ื‘ื” ื—ื™ื›ื™ื ื• ื›ืœ ื›ืš ื”ืจื‘ื” ืœ Select top @a... ื•ืขื•ื“ ื•ืขื•ื“. ื›ื–ื” ื”ื•ื ื”ื˜ื‘ืข ืฉืœื ื•. ื•ืื ื• ืฉืื ื• ื›ื‘ืจ ื‘ืขื ืŸ - ื›ืœื•ืžืจ ืขื•ื‘ื“ื™ื ื›ื‘ืจ ืขื ื” SQL Azure ื™ื•ื“ืขื™ื ืฉืœื ื ืฆื˜ืจืš ื™ื•ืชืจ CTP ืœืžื™ื ื™ื”ื, ื•ืœื ื ืฆื˜ืจืš ื”ืชืงื ื•ืช ื•ืื™ืฉื•ืจื™ IT ืœื”ื•ืจื“ื•ืช ืฉืœ ืžืื•ืช MB ืฉืœ ืงื•ื“ ื•ืกืจื‘ื™ืกื™ื ืื• ืกืจื‘ืจื™ื (ื›ืŸ  - ื‘ื˜ื— ืฉื ืฆื˜ืจืš - ื ืฆื˜ืจืš ืœืฉื“ืจื’ ืืช ื” SSMS...
3 comments
Read more