sqlserverrider.wordpress.com
Ayyappan | SQL Server Rider
https://sqlserverrider.wordpress.com/author/sqldwh
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. SQL Server 2016 – Arrived. June 3, 2016. This is a good news for the SQL Server community for this year. Microsoft has released SQL Server 2016 on June 1st 2016. You need to sign-up to download the evaluation edition from this web page. Https:/ www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016. There are many exciting features in this version. Now, SQL Server has moved to the top of the database management servers ladder. February 17, 2016. This blog...
sqlserverrider.wordpress.com
SQL SERVER – Declare Mulitple Variables in Single Line | SQL Server Rider
https://sqlserverrider.wordpress.com/2014/10/16/sql-server-declare-mulitple-variables-in-single-line
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. SQL SERVER – Declare Mulitple Variables in Single Line. SQL SERVER – Declare Mulitple Variables in Single Line. October 16, 2014. This may be a simple thing, but sometime new developers are difficult to find this information readily. So, thought of adding it in this website. How to declare and initialize variables in single or multiple lines? 8211; Multiple lines. DECLARE @int i AS INT;. DECLARE @chr Name AS VARCHAR(50);. Declare and Initialize variables.
sqlserverrider.wordpress.com
SQL SERVER – Fix the Report Builder bug in SQL Server 2008 R2 SP 3 | SQL Server Rider
https://sqlserverrider.wordpress.com/2014/10/17/sql-server-fix-the-report-builder-bug-in-sql-server-2008-r2-sp-3
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. SQL SERVER – Fix the Report Builder bug in SQL Server 2008 R2 SP 3. SQL SERVER – Fix the Report Builder bug in SQL Server 2008 R2 SP 3. October 17, 2014. Microsoft recently send this workaround to fix the issue in SQL Server 2008 R2 SP 3 for Report Builder launch. If you installed SQL Server 2008 R2, have upgraded it to Service Pack 2 and then applied Service Pack 3, then Report Builder will fail to launch. Full detail is in Here. Leave a Reply Cancel reply.
sqlserverrider.wordpress.com
Power BI Desktop | SQL Server Rider
https://sqlserverrider.wordpress.com/2015/07/28/power-bi-desktop
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. July 28, 2015. This is the final dialog box before entering into a new world. Download a free copy of desktop. I have created a quick map report using Power BI desktop. I am planning to write more about this tool in coming days. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. Notify me of new comments via email.
sqlserverrider.wordpress.com
PSSUG | SQL Server Rider
https://sqlserverrider.wordpress.com/pssug
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. Puducherry SQL Server User Group (PSSUG). Welcome to the Puducherry SQL Server User Group (PSSUG) Community. We are a group of SQL Server users, database administrators, business intelligence experts and application developers from the Puducherry (UT) India. Our community is started in the month of March 2011. We all speak one common technology in the community when it comes to sharing and discussing about Microsoft SQL Server. Leave a Reply Cancel reply.
sqlserverrider.wordpress.com
SQL2012 | SQL Server Rider
https://sqlserverrider.wordpress.com/?attachment_id=1372
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. July 11, 2013 at 4:06 am. Import Image into SQL Server via T-SQL and take it to SSRS crievo. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. Notify me of new comments via email.
sqlserverrider.wordpress.com
Documents | SQL Server Rider
https://sqlserverrider.wordpress.com/downloads
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. These documents as created to help the SQL Server developers. It can be downloaded at free of cost from this site and you can also share it with others without any restrictions. Mapping SSIS – SQL Server Data Types. SQL Server Data Types and its range. SQL Server to Oracle Data Type Mapping. MS Access to MS SQL Server Data Type Mapping. August 28, 2014 at 8:00 pm. July 2, 2015 at 10:40 am. Leave a Reply Cancel reply. Enter your comment here.
sqlserverrider.wordpress.com
Tools | SQL Server Rider
https://sqlserverrider.wordpress.com/tools
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. 8211; View Images stored in a SQL table. 8211; Graphical User Interface for BCP. 8211; Finding all SQL Server in the local network and build connection string. 8211; DBF file Viewer and Converter Utility Software. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. Notify me of new comments via email.
sqlserverrider.wordpress.com
Get the File Last Modified datetime from FTP Server – SSIS | SQL Server Rider
https://sqlserverrider.wordpress.com/2015/06/17/get-the-file-last-modified-datetime-from-ftp-server-ssis
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. Get the File Last Modified datetime from FTP Server – SSIS. Get the File Last Modified datetime from FTP Server – SSIS. June 17, 2015. There are many ways to get the file modified date from the FTP server. But, I like to write a VB.net code to do that task simpler. Script Task is used in SSIS. Code: To fetch the file last modified datetime. ReqFTP.Method = WebRequestMethods.Ftp.GetDateTimestamp. Response = DirectCast(reqFTP.GetResponse(), FtpWebResponse).
sqlserverrider.wordpress.com
Get the File Last Modified datetime from HTTP Header – SSIS | SQL Server Rider
https://sqlserverrider.wordpress.com/2015/06/30/get-the-file-last-modified-datetime-from-http-header-ssis
Database, SSIS, SSAS, SSRS, PowerPivot, GIS. Get the File Last Modified datetime from HTTP Header SSIS. Get the File Last Modified datetime from HTTP Header SSIS. June 30, 2015. This VB.Net code can be used to get the Last modified date of a file from HTTP header. It can be used to check the file date before the actual file is downloaded to out computer. It save some time and network resources. You can pass different header key to get its value. Dim request As HttpWebRequest = HttpWebRequest.Create.