网站综合信息 sqlyoga.com
- 标题:
- Home - SQL Yoga
- 关键字:
- 描述:
- A blog about Microsoft SQL Server and Asp. Net, T-SQL, SSIS, SSRS, Backup, Restore etc..
- 域名信息
- 域名年龄:15年10个月5天 注册日期:2009年04月05日 到期时间:2016年04月05日
邮箱:abuse-contact 电话:1-2013775952
注册商:PDR LTD. D/B/A PUBLICDOMAINREGISTRY.COM
- 服务器空间
- IP:103.127.146.241 同IP网站1个 详情
地址:亚太地区
- 备案信息
- 备案号:
域名流量Alexa排名
域名注册Whois信息
sqlyoga.com
域名年龄: 15年10个月5天注册时间: 2009-04-05
到期时间: 2016-04-05
注 册 商: PDR LTD. D/B/A PUBLICDOMAINREGISTRY.COM
注册邮箱: abuse-contact
联系电话: 1-2013775952
获取时间: 2014年09月07日 17:13:24
Domain Name: SQLYOGA.COM
Registrar: PDR LTD. D/B/A PUBLICDOMAINREGISTRY.COM
Whois Server: whois.PublicDomainRegistry.com
Referral URL: http://www.PublicDomainRegistry.com
Name Server: NS1.DOMAINSEARCHINDIA.COM
Name Server: NS2.DOMAINSEARCHINDIA.COM
Name Server: NS3.DOMAINSEARCHINDIA.COM
Name Server: NS4.DOMAINSEARCHINDIA.COM
Status: clientTransferProhibited
Updated Date: 2014-04-07
Creation Date: 2009-04-05
Expiration Date: 2016-04-05
>>> Last update of whois database: Sun, 2014-Sep-07 09:15:23 UTC <<<
Domain Name: SQLYOGA.COM
Registry Domain ID: 1551306712_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.publicdomainregistry.com
Registrar URL: www.publicdomainregistry.com
Updated Date: 2014-Apr-07
Creation Date: 2009-Apr-05
Registrar Registration Expiration Date: 2016-Apr-05
Registrar: PDR Ltd. d/b/a PublicDomainRegistry.com
Registrar IANA ID: 303
Registrar Abuse Contact Email: abuse-contact
Registrar Abuse Contact Phone: +1-2013775952
Domain Status: clientTransferProhibited
Registry Registrant ID: DI_9640366
Registrant Name: Tejas Shah
Registrant Organization: N/A
Registrant Street: Ahmedabad
Registrant City: Ahmedabad
Registrant State/Province: Gujarat
Registrant Postal Code: 380007
Registrant Country: IN
Registrant Phone: +91.9979890856
Registrant Phone Ext:
Registrant Fax: +91.9979890856
Registrant Fax Ext:
Registrant Email: tejasnshah.it
Registry Admin ID: DI_9640366
Admin Name: Tejas Shah
Admin Organization: N/A
Admin Street: Ahmedabad
Admin City: Ahmedabad
Admin State/Province: Gujarat
Admin Postal Code: 380007
Admin Country: IN
Admin Phone: +91.9979890856
Admin Phone Ext:
Admin Fax: +91.9979890856
Admin Fax Ext:
Admin Email: tejasnshah.it
Registry Tech ID: DI_9640366
Tech Name: Tejas Shah
Tech Organization: N/A
Tech Street: Ahmedabad
Tech City: Ahmedabad
Tech State/Province: Gujarat
Tech Postal Code: 380007
Tech Country: IN
Tech Phone: +91.9979890856
Tech Phone Ext:
Tech Fax: +91.9979890856
Tech Fax Ext:
Tech Email: tejasnshah.it
Name Server: ns1.domainsearchindia.com
Name Server: ns2.domainsearchindia.com
Name Server: ns3.domainsearchindia.com
Name Server: ns4.domainsearchindia.com
DNSSEC:Unsigned
URL of the ICANN WHOIS Data Problem Reporting System:
http://wdprs.internic.net/
>>>Last update of WHOIS database: 2014-09-07T09:15:32+0000Z<<<
Registration Service Provided By: AZONIC INFOTECH PVT. LTD.
The data in this whois database is provided to you for information purposes
only, that is, to assist you in obtaining information about or related to a
domain name registration record. We make this information available "as is",
and do not guarantee its accuracy. By submitting a whois query, you agree
that you will use this data only for lawful purposes and that, under no
circumstances will you use this data to:
(1) enable high volume, automated, electronic processes that stress or load
this whois database system providing you this information; or
(2) allow, enable, or otherwise support the transmission of mass unsolicited,
commercial advertising or solicitations via direct mail, electronic mail, or
by telephone.
The compilation, repackaging, dissemination or other use of this data is
expressly prohibited without prior written consent from us. The Registrar of
record is PDR Ltd. d/b/a PublicDomainRegistry.com.
We reserve the right to modify these terms at any time.
By submitting this query, you agree to abide by these terms.
网站头文件(HTTP Header)
HTTP/1.1 200 OK 缓存控制:private 类型:text/html; charset=utf-8 Content-Encoding: gzip 动作:Accept-Encoding 服务器:Microsoft-IIS/10.0 X-AspNetMvc-Version: 5.2 ASP.NET版本:4.0.30319 语言环境:ASP.NET X-Powered-By-Plesk: PleskWin 访问时间:2019年09月07日 05:16:26 文件大小:8385 网站编码:utf-8
同IP网站(同服务器)
其他后缀域名
网站首页快照(纯文字版)
抓取时间:2019年09月07日 05:16:26
网址:http://sqlyoga.com/
标题:Home - SQL Yoga
关键字:
描述:A blog about Microsoft SQL Server and Asp. Net, T-SQL, SSIS, SSRS, Backup, Restore etc..
主体:
网址:http://sqlyoga.com/
标题:Home - SQL Yoga
关键字:
描述:A blog about Microsoft SQL Server and Asp. Net, T-SQL, SSIS, SSRS, Backup, Restore etc..
主体:
HomeAbout UsBlogContactSearch your content here...GoSQLYogaThis blog is for SQL SERVER developers. Here I am trying to share my experience with allpeople.Thisblog contains my thoughts that might help the peopleContactLATEST POSTSTejas ShahAzureLinked ServerReport ServerSQLYoga11-Nov-2017SQL Server, T-SQL create Linked Server with Azure SQL DatabaseToday, we got a requirement to connect our Azure VM SQL (Report server) instance to access the Azure Database. Let me show you how create linked server for SQL Database on Azure from Azure VM SQL instance.Read MoreTejas ShahSSRS ReportsReport PathReport NameData SourcesTejas Shah22-Nov-2017SQL Server Reporting Services, List out all the data sources with Report Name and PathIn Enterprise application, we can have many reports hosted. Sometimes there are few customized reports too. Over period of time, there may be many Data Sources used by the different reports. To find out Report and its data source, we can use the following query: (Execute on ReportServer Database)Read MoreTejas ShahAzureLinked ServerReport ServerSQLYogaTejas Shah12-Aug-2015SQL Server: Use of Recursive Query with exampleOne of the most benefit of CTE (Common Table Expressions) is that we can create recursive queries with them.Read MoreTejas ShahSQLYogaTejas ShahComma Separated ListEncodingFor XMLFor XML PATH TYPEString Concate26-Jun-2015SQL Server, avoid encoding special character when using FOR XML PATHFrom SQL 2005, we are using FOR XML PATH('') for the string concatenation. I have also mentioned the same in very old blog: Generate Comma Separated List with SELECT statement. Read MoreTejas ShahSQL Log file sizeSQL ServerSQL TipsCurrent location of log files20-Apr-2015SQL SERVER: Find Current Location of Log File(s) with File Size of All the Database
As we are mostly engaged in SQL Assignments, we come to the place where we found that there are lots of ldf files which occupies lots of the space on the DISK. To continue my work, I have to make a room on the same DISK. I found that there are lots of log files (LDF) on the disk which occupies more than 1 TB (1024 GB). This is the development server and I found and confirmed that we can have “Recovery Option” as “SIMPLE” too. The tricky part over here is, these databases are already created and Log file names are not same as database name. So, first of all I need to find out the database name to which I can make Recovery Option as Simple. Finally, I got following query which helps me to continue my assignment as follows:
Read More
Tejas Shah
SQLYoga
Tejas Shah
File System Task
for each loop
Move Files
Process all files with SSIS
Rename Files
10-Sep-2014
SQL SERVER: SSIS - Rename and move files from source folder to destination folder
With SSIS, most of the time we need to process all the files from the folder. Once file has been processed, we need to move the file to archive folder, so we should know that file has been processed and we have the file in arch
最近查询网站