Welcome!

Where Learning is Pleasure

Jayaram Krishnaswamy

Subscribe to Jayaram Krishnaswamy: eMailAlertsEmail Alerts
Get Jayaram Krishnaswamy via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Jayaram Krishnaswamy

Well there is a heavy-weight tool, SQL Server Management Studio that is installed as a separate application from SQL Server installation (used to be a part of the SQL Server installation). SQL Operations Studio is a lighter tool. It is free and you can carry out database development operations using it. It is available for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data warehouse on Windows, Mac or Linux. Read more here:http://hodentekhelp.blogspot.com/2017/12/what-is-sql-operations-studio.html The preview version became available in November of 2017. If you would like to use it you need to download the version you want from here: I downloaded the Windows version. You need to extract the files into a folder.  The executable is sqlops.exe and it is indeed a small file. SQLOPS user interface in Windows 10 ... (more)

Learn SQL Server 2008 Reporting Services

Report Builder 2.0 user interface description Read Part 2 of this article here: http://jayaramkrishnaswamy.sys-con.com/node/1227111 Report Builder is a report authoring tool and the basic procedure for authoring a report consists of the following steps: Report planning Connecting to a source of data Extracting a dataset from source Designing the report and data binding Previewing the report Although deploying the report is not included in the above, Report Builder can deploy the report as well. It is not always necessary to deploy a completed report, as any part of a report defi... (more)

SQL Azure and MS SQL Server Integration Services

Enterprise data can be of very different kinds ranging from flat files to data stored in relational databases and XML datasources. The extraordinary number of database related products, and their historic evolution, makes this task exacting. The entry of cloud computing has brought area into the forefront as SSIS has been one of the methods indicated for bringing ground based data to cloud storage in SQL Azure, the next milestone in Microsoft Data Management. Presently the following methods are indicated: Run Insert statements SQL Manager to populate tables schema created using SQL... (more)

Use Sybase(SAP)'s SQL Anywhere OLE DB Provider 16 to create a linked server in SQL Server 2012

Linked servers offer the following advantages as noted in MSDN documentation: •The ability to access data from outside of SQL Server. •The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise. •The ability to address diverse data sources similarly. There are two ways to create Linked Servers in SQL Server 2012. Using SQL Server Management StudioUsing the sp_addlinkedserver stored procedure Microsoft SQL Server 2012 has two providers to connect to SQL Anywhere 16 from SAP (Sybase). They are, MSDASQL - Microsoft OLE D... (more)

NoSQL Azure Service DocumentDB as a service announced

Azure platform is going all out and it is burgeoning. "Microsoft Azure DocumentDB is a document-oriented, NoSQL database service designed for modern mobile and web applications" The above from Microsoft site. Microsoft beefs its Azure Services portfolio with yet another service. Azure DocementDB service is which also serves as a search tool. Searching stuff that goes into NoSQL should be very useful. It is presently available as a technology preview product and developers will be able to run SQLesque queries on  JSON data and supports transactional consistency. Under the hoods it uses th... (more)