![[Valid RSS]](images/valid-rss-rogers.png "Valid RSS")
This is a valid RSS feed.
This feed is valid, but interoperability with the widest range of feed readers could be improved by implementing the following recommendations.
line 19, column 6820: (10 occurrences) [help]
... vs 147.87 for the WHERE clause).</p>]]></content:encoded>
^
</channel>
^
<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" > <channel> <title>RSS Database Processing</title> <link>http://www.consuminglinkeddata.org/</link> <description>Database Processing</description> <lastBuildDate>Sun, 10 Jan 2021 05:42:22 -0600</lastBuildDate> <language>en</language> <sy:updatePeriod>daily</sy:updatePeriod> <sy:updateFrequency>1</sy:updateFrequency> <item> <title>database queries tutorial</title> <description>Starting here? This lesson is part of a full-length tutorial in using SQL for Data Analysis. Check out the beginning. The lesson on subqueries introduced the idea that you can sometimes create the same desired result set with a ...</description> <content:encoded><![CDATA[<img src="/img/simple_select_queries_essential_sql.jpg" alt="Simple SELECT Queries - Essential SQL" align="left" /><p>Starting here? This lesson is part of a full-length tutorial in using SQL for Data Analysis. Check out the beginning. The lesson on subqueries introduced the idea that you can sometimes create the same desired result set with a faster-running query. In this lesson, you’ll learn to identify when your queries can be improved, and how to improve them. The theory behind query run time A database is a piece of software that runs on a computer, and is subject to the same limitations as all software—it can only process as much information as its hardware is capable of handling. The way to make a query run faster is to reduce the number of calculations that the software (and therefore hardware) must perform. To do this, you’ll need some understanding of how SQL actually makes calculations. First, let’s address some of the high-level things that will affect the number of calculations you need to make, and therefore your querys runtime: Table size: If your query hits one or more tables with millions of rows or more, it could affect performance. Joins: If your query joins two tables in a way that substantially increases the row count of the result set, your query is likely to be slow. There’s an example of this in the subqueries lesson. Aggregations: Combining multiple rows to produce a result requires more computation than simply retrieving those rows. Query runtime is also dependent on some things that you can’t really control related to the database itself: Other users running queries: The more queries running concurrently on a database, the more the database must process at a given time and the slower everything will run. It can be especially bad if others are running particularly resource-intensive queries that fulfill some of the above criteria. Database software and optimization: This is something you probably can’t control, but if you know the system you’re using, you can work within its bounds to make your queries more efficient. For now, let’s ignore the things you can’t control and work on the things you can. Reducing table size Filtering the data to include only the observations you need can dramatically improve query speed. How you do this will depend entirely on the problem you’re trying to solve. For example, if you’ve got time series data, limiting to a small time window can make your queries run much more quickly: Keep in mind that you can always perform exploratory analysis on a subset of data, refine your work into a final query, then remove the limitation and run your work across the entire dataset. The final query might take a long time to run, but at least you can run the intermediate steps quickly. This is why Mode enforces a LIMIT clause by default—100 rows is often more than you need to determine the next step in your analysis, and it’s a small enough dataset that it will return quickly. It’s worth noting that LIMIT doesn’t quite work the same way with aggregations—the aggregation is performed, then the results are limited to the specified number of rows. So if you’re aggregating into one row as below, LIMIT 100 will do nothing to speed up your query: SELECT COUNT(*) FROM benn.sample_event_table LIMIT 100 If you want to limit the dataset before performing the count (to speed things up), try doing it in a subquery: SELECT COUNT(*) FROM ( SELECT * FROM benn.sample_event_table LIMIT 100 ) sub Note: Using LIMIT this will dramatically alter your results, so you should use it to test query logic, but not to get actual results. In general, when working with subqueries, you should make sure to limit the amount of data you’re working with in the place where it will be executed first. This means putting the LIMIT in the subquery, not the outer query. Again, this is for making the query run fast so that you can test— NOT for producing good results. Making joins less complicated In a way, this is an extension of the previous tip. In the same way that it’s better to reduce data at a point in the query that is executed early, it’s better to reduce table sizes before joining them. Take this example, which joins information about college sports teams onto a list of players at various colleges: SELECT teams.conference AS conference, players.school_name, COUNT(1) AS players FROM benn.college_football_players players JOIN benn.college_football_teams teams ON teams.school_name = players.school_name GROUP BY 1, 2 There are 26, 298 rows in benn.college_football_players. That means that 26, 298 rows need to be evaluated for matches in the other table. But if the benn.college_football_players table was pre-aggregated, you could reduce the number of rows that need to be evaluated in the join. First, let’s look at the aggregation: SELECT players.school_name, COUNT(*) AS players FROM benn.college_football_players players GROUP BY 1 The above query returns 252 results. So dropping that in a subquery and then joining to it in the outer query will reduce the cost of the join substantially: SELECT teams.conference, sub.* FROM ( SELECT players.school_name, COUNT(*) AS players FROM benn.college_football_players players GROUP BY 1 ) sub JOIN benn.college_football_teams teams ON teams.school_name = sub.school_name In this particular case, you won’t notice a huge difference because 30, 000 rows isn’t too hard for the database to process. But if you were talking about hundreds of thousands of rows or more, you’d see a noticeable improvement by aggregating before joining. When you do this, make sure that what you’re doing is logically consistent—you should worry about the accuracy of your work before worrying about run speed. EXPLAIN You can add EXPLAIN at the beginning of any (working) query to get a sense of how long it will take. It’s not perfectly accurate, but it’s a useful tool. Try running this: EXPLAIN SELECT * FROM benn.sample_event_table WHERE event_date >= '2014-03-01' AND event_date < '2014-04-01' LIMIT 100 You’ll get this output. It’s called the Query Plan, and it shows the order in which your query will be executed: The entry at the bottom of the list is executed first. So this shows that the WHERE clause, which limits the date range, will be executed first. Then, the database will scan 600 rows (this is an approximate number). You can see the cost listed next to the number of rows—higher numbers mean longer run time. You should use this more as a reference than as an absolute measure. To clarify, this is most useful if you run EXPLAIN on a query, modify the steps that are expensive, then run EXPLAIN again to see if the cost is reduced. Finally, the LIMIT clause is executed last and is really cheap to run (24.65 vs 147.87 for the WHERE clause).</p>]]></content:encoded> <category><![CDATA[Optimization]]></category> <link>http://www.consuminglinkeddata.org/database-queries-tutorial</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/database-queries-tutorial</guid> <pubDate>Sun, 10 Jan 2021 17:42:00 +0000</pubDate> </item> <item> <title>Sybase tools</title> <description>Comprehensive database monitoring tools for SAP ASE, IQ, Replication Server and SAP HANA ensures reliable data performance and availability A global strategic alliance Sybase partner, Bradmark's Surveillance DB is Sybase's ...</description> <content:encoded><![CDATA[<img src="/img/sybase_ase_database_administration_tools_aquafold.jpg" alt="Sybase ASE Database Administration Tools | AquaFold" align="left" /><p>Comprehensive database monitoring tools for SAP ASE, IQ, Replication Server and SAP HANA ensures reliable data performance and availability A global strategic alliance Sybase partner, Bradmark's Surveillance DB is Sybase's recommended choice for top-tier monitoring and performance management of SAP ASE, IQ, Replication Server, and SAP HANA investments that run on UNIX, Linux and Windows operating systems. Surveillance DB provides IT professionals essential system visibility to capture comprehensive views of overall system health, and perform comprehensive drill-downs to determine the root cause of performance bottlenecks. Whether you are running a data warehouse application, high availability online transaction systems or a regular database, Surveillance provides you peace-of-mind, knowing that your SAP database systems are up and running and performing to agreed service levels. Global partnership provides "unprecedented solution", ensuring SAP customers' databases run efficiently, consistently and with maximum uptime On July 2005, Bradmark and Sybase an SAP company®, announced that it has joined in a global reseller agreement. Under this global agreement, Sybase offers Bradmark's Surveillance monitoring and management tools directly to its customers through both its direct sales force and worldwide partnerships. Bradmark provides Sybase clients with a comprehensive product suite to monitor and manage Sybase Adaptive Server® Enterprise (ASE), Sybase Replication Server®, Sybase IQ and their operating systems. "Our goal is to provide our customers with industry-leading database management solutions and our relationship with Bradmark is evidence of that commitment, " stated Kathleen Schaub, vice president, Information Technology Solutions Group, Sybase. "By teaming with Bradmark, we can offer an unprecedented solution, ensuring our customers' databases run efficiently, consistently and with maximum uptime."</p>]]></content:encoded> <category><![CDATA[Tool]]></category> <link>http://www.consuminglinkeddata.org/sybase-tools</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/sybase-tools</guid> <pubDate>Mon, 21 Dec 2020 17:40:00 +0000</pubDate> </item> <item> <title>mac database design tool</title> <description>Simplify the task of creating complex entity relationship models and generate the script SQL with a simple click. Navicat Data Modeler supports various database systems, including MySQL, MariaDB, Oracle, SQL Server, PostgreSQL ...</description> <content:encoded><![CDATA[<img src="/img/pgmodeler_postgresql_database_modeler.jpg" alt="PgModeler - PostgreSQL Database Modeler" align="left" /><p>Simplify the task of creating complex entity relationship models and generate the script SQL with a simple click. Navicat Data Modeler supports various database systems, including MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite. Database Objects Create, modify, and design your models using professional object designers, available for Tables and Views. Without the need to write complex SQL to create and edit objects, you’ll know exactly what you are working on. Also, Navicat Data Modeler supports three standard notations: Crow’s Foot, IDEF1x and UML. Using our feature-rich, simple, and user-friendly drawing tools, you can develop a complete data model with just a few clicks. Model Types Navicat Data Modeler enables you to build high-quality conceptual, logical and physical data models for a wide variety of audiences. Using the Model Conversion feature, you can convert a conceptual business-level model into a logical relational database model and then into a physical database implementation. From sketching a big picture of your system design to viewing relationships and working with attributes and columns from linked entities, tables and views. You can easily deploy accurate changes to database structures and build organized and more effective database systems. Reverse Engineering Reverse Engineering is one of the key features of Navicat Data Modeler. Load existing database structures and create new ER diagrams. Visualize database models so you can see how elements such as attributes, relationships, indexes, uniques, comments, and other objects relate to each other without showing actual data. Navicat Data Modeler supports different databases: Direct connection, ODBC (*Only for Windows and macOS Edition), MySQL, MariaDB, Oracle, SQL Server, PostgreSQL, and SQLite. Comparison and Synchronization The Synchronize to Database function will give you a full picture of all database differences. Once your databases are compared, you can view the differences and generate a synchronization script to update the destination database to make it identical to your model. Flexible settings enable you to set up a custom key for comparison and synchronization.</p>]]></content:encoded> <category><![CDATA[Optimization]]></category> <link>http://www.consuminglinkeddata.org/mac-database-design-tool</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/mac-database-design-tool</guid> <pubDate>Tue, 01 Dec 2020 17:26:00 +0000</pubDate> </item> <item> <title>tools of database</title> <description>If you’re following our recent news, you already know that last week we released the new massive IntelliJ IDEA update, 2017.2. However, we didn’t mention its database tools much in the release announcement, so now it’s time ...</description> <content:encoded><![CDATA[<img src="/img/top_10_free_database_tools_for_1.jpg" alt="Top 10 free database tools for sys admins" align="left" /><p>If you’re following our recent news, you already know that last week we released the new massive IntelliJ IDEA update, 2017.2. However, we didn’t mention its database tools much in the release announcement, so now it’s time to catch up on that, because there’s plenty of new features in that area. Amazon Redshift and Microsoft Azure These cloud database providers are now supported out of the box with dedicated drivers and their specific SQL syntaxes. If you’re already using any of them via the standard SQL Server or PostgreSQL drivers, make sure that you migrate to the new dedicated drivers after upgrading to 2017.2. Connecting to multiple PostgreSQL databases You don’t need to create separate Data Sources for each of PostgreSQL databases you’re using anymore. Just select as many databases as needed when configuring a single PostgreSQL Data Source. Evaluate expression This feature, with which you could already be familiar if you’ve worked with Java code, is now available for SQL expressions, too and allows you get a preview of a table, a column, or a query. It can be invoked either via Alt+clicking an expression or selecting it and pressing Ctrl+Alt+F8 (Cmd+Alt+F8 for macOS). In case the expression you need to evaluate isn’t in the code, press Alt+F8, and you will get a dialog where you can enter it and see what it produces. Transaction control Auto-commit option in the Console has been replaced with its more advanced version, called Transaction Control, which is made available not only in the Console toolbar, but as the Data Source configuration option as well, and in addition to controlling the transaction mode (automatic or manual), also defines the transaction isolation level. When this option is set to Manual, the toolbar will display the Commit and Rollback buttons. Table DDL The DDL tab is removed from the Table Editor, and now if you want to see DDL, call Edit Source by clicking the its icon in the Database tool window toolbar, or via the Ctrl+B (Cmd+B for macOS). By the way, DataGrip 2017.2 release that will include all these features is just around the corner, so stay tuned for updates!</p>]]></content:encoded> <category><![CDATA[Tool]]></category> <link>http://www.consuminglinkeddata.org/tools-of-database</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/tools-of-database</guid> <pubDate>Wed, 11 Nov 2020 17:25:00 +0000</pubDate> </item> <item> <title>Select database query in MySQL</title> <description>It is very simple to select a database from the mysql&gt; prompt. You can use the SQL command use to select a database. Example Here is an example to select a database called TUTORIALS − [root@host]# mysql -u root -p Enter ...</description> <content:encoded><![CDATA[<img src="/img/how_to_join_three_tables_in.jpg" alt="How to join three tables in SQL query – MySQL Example" align="left" /><p>It is very simple to select a database from the mysql> prompt. You can use the SQL command use to select a database. Example Here is an example to select a database called TUTORIALS − [root@host]# mysql -u root -p Enter password:****** mysql> use TUTORIALS; Database changed mysql> Now, you have selected the TUTORIALS database and all the subsequent operations will be performed on the TUTORIALS database. NOTE − All the database names, table names, table fields name are case sensitive. So you would have to use the proper names while giving any SQL command. Selecting a MySQL Database Using PHP Script PHP provides function mysql_select_db to select a database. It returns TRUE on success or FALSE on failure. Syntax bool mysql_select_db( db_name, connection ); S. No. Parameter & Description db_name Required − MySQL Database name to be selected connection Optional − if not specified, then the last opened connection by mysql_connect will be used.</p>]]></content:encoded> <category><![CDATA[Optimization]]></category> <link>http://www.consuminglinkeddata.org/select-database-query-in-mysql</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/select-database-query-in-mysql</guid> <pubDate>Thu, 22 Oct 2020 16:25:00 +0000</pubDate> </item> <item> <title>database developer tools</title> <description>As you design a database, you create database objects such as tables, columns, keys, indexes, relationships, constraints, and views. To help you create these objects, the Visual Database Tools provides three mechanisms: the ...</description> <content:encoded><![CDATA[<img src="/img/database_workbench_database_development_tool_for.jpg" alt="Database Workbench: database development tool for MySQL, MariaDB" align="left" /><p>As you design a database, you create database objects such as tables, columns, keys, indexes, relationships, constraints, and views. To help you create these objects, the Visual Database Tools provides three mechanisms: the Database Designer, the Table Designer, and the Query and View Designer. It is important to understand the interactions among the various tools and your database. In This Section Describes how this tool allows you to create tables, columns, keys, indexes, relationships, and constraints. Within the Database Designer, you interact with database objects through database diagrams, which graphically show the structure of the database. With the Database Designer you can create and modify objects that are visible on diagrams (tables, columns, relationships, and keys) and some objects that are not visible on diagrams (indexes and constraints). Describes how this tool helps you to create an individual table. Although you can create tables with the Database Designer, the Table Designer is sometimes more convenient for this task, because it devotes a larger portion of the screen to the table and shows more detail about the table as you design it. Provides details on many useful SQL text editing features. Provides links to topics describing the uses and advantages of various database objects you can use with the Visual Database Tools to design a database. Explains how your database diagram and table design changes are saved in memory until you explicitly choose to save them to the database. Explains how database diagrams and table design windows get saved to the database. Provides links to topics covering special challenges common to large database projects: multiple people designing a single database, making changes to a deployed database, and managing multiple versions of a single database. Related Sections Explains the panes of these tools that help you create queries and views. Provides links to topics describing what's new in Visual Database Tools and how the tools interact with your database. Explains concepts behind creating queries and views of your data in Visual Database Tools. Gives detailed steps for designing and maintaining database structure through tables, columns, keys, indexes, stored procedures, and more. Provides links to topics with details on how to design queries and views as well as how to modify data.</p>]]></content:encoded> <category><![CDATA[Tool]]></category> <link>http://www.consuminglinkeddata.org/database-developer-tools</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/database-developer-tools</guid> <pubDate>Fri, 02 Oct 2020 16:07:00 +0000</pubDate> </item> <item> <title>Database diagram symbols</title> <description>TEN RELATED HOW TO's: ERD Symbols and Meanings A database is a data collection, structured into some conceptual model. Two most common approaches of developing data models are UML diagrams and ER-model diagrams. There are several ...</description> <content:encoded><![CDATA[<img src="/img/entity_relationship_diagram_everything_you.jpg" alt="Entity Relationship Diagram - Everything You Need to Know About ER" align="left" /><p>TEN RELATED HOW TO's: ERD Symbols and Meanings A database is a data collection, structured into some conceptual model. Two most common approaches of developing data models are UML diagrams and ER-model diagrams. There are several notations of entity-relationship diagram symbols and their meaning is slightly different. Crow’s Foot notation is quite descriptive and easy to understand, meanwhile, the Chen notation is great for conceptual modeling. An entity relationship diagrams look very simple to a flowcharts. The main difference is the symbols provided by specific ERD notations. There are several models applied in entity-relationship diagrams: conceptual, logical and physical. Creating an entity relationship diagram requires using a specific notation. There are five main components of common ERD notations: Entities, Actions, Attributes, Cardinality and Connections. The two of notations most widely used for creating ERD are Chen notation and Crow foot notation. By the way, the Crow foot notation originates from the Chen notation - it is an adapted version of the Chen notation. Read more... → Picture: ERD Symbols and Meanings Related Solution: Entity-Relationship Diagram (ERD) Data structure diagram with ConceptDraw PRO Data structure diagram (DSD) is intended for description of conceptual models of data (concepts and connections between them) in the graphic format for more obviousness. Data structure diagram includes entities description, connections between them and obligatory conditions and requirements which connect them. Create Data structure diagram with ConceptDraw PRO. Read more... → Picture: Data structure diagram with ConceptDraw PRO Entity Relationship Diagram Examples An abstract representation is usually the first thing you will need while developing a database. To understand the ways that databases are structured, you should look through entity-relationship diagram examples and see the notations features and attributes. With an entity-relationship model you can describe a database of any complexity. This Entity-relationship diagram is a tool for software developers. It enables every element of database to be managed, communicated and tested before release. This ERD was created using symbols advocated by Chen's notation. Because of a linguistic origin of the Chen’s notation, the boxes representing entities could be interpreted as nouns, and the relationships between them are in verb form, shown on a diagram as a diamond. Read more... → Picture: Entity Relationship Diagram Examples Related Solution: Entity-Relationship Diagram (ERD) ConceptDraw PRO Database Modeling Software ConceptDraw PRO is a very easy-to-use and intuitive database design tool which can save you hundreds of work hours. See database diagram samples created with ConceptDraw PRO database modeling database diagram software. Read more... → Picture: ConceptDraw PRO Database Modeling Software Process Flowchart When trying to figure out the nature of the problems occurring within a project, there are many ways to develop such understanding. One of the most common ways to document processes for further improvement is to draw a process flowchart, which depicts the activities of the process arranged in sequential order — this is business process management. ConceptDraw PRO is business process mapping software with impressive range of productivity features for business process management and classic project management...</p>]]></content:encoded> <category><![CDATA[Optimization]]></category> <link>http://www.consuminglinkeddata.org/database-diagram-symbols</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/database-diagram-symbols</guid> <pubDate>Sat, 12 Sep 2020 16:05:00 +0000</pubDate> </item> <item> <title>Multi database query</title> <description>Elastic database query (preview) for Azure SQL Database allows you to run T-SQL queries that span multiple databases using a single connection point. This topic applies to vertically partitioned databases. When completed, you ...</description> <content:encoded><![CDATA[<img src="/img/kjell_orsborn_uu_dis.jpg" alt="Kjell Orsborn UU - DIS - UDBL DATABASE SYSTEMS - 10p Course No" align="left" /><p>Elastic database query (preview) for Azure SQL Database allows you to run T-SQL queries that span multiple databases using a single connection point. This topic applies to vertically partitioned databases. When completed, you will: learn how to configure and use an Azure SQL Database to perform queries that span multiple related databases. Prerequisites You must possess ALTER ANY EXTERNAL DATA SOURCE permission. This permission is included with the ALTER DATABASE permission. ALTER ANY EXTERNAL DATA SOURCE permissions are needed to refer to the underlying data source. Create the sample databases To start with, we need to create two databases, Customers and Orders, either in the same or different logical servers. Execute the following queries on the Orders database to create the OrderInformation table and input the sample data. CREATE TABLE [dbo].[OrderInformation]( [OrderID] [int] NOT NULL, [CustomerID] [int] NOT NULL ) INSERT INTO [dbo].[OrderInformation] ([OrderID], [CustomerID]) VALUES (123, 1) INSERT INTO [dbo].[OrderInformation] ([OrderID], [CustomerID]) VALUES (149, 2) INSERT INTO [dbo].[OrderInformation] ([OrderID], [CustomerID]) VALUES (857, 2) INSERT INTO [dbo].[OrderInformation] ([OrderID], [CustomerID]) VALUES (321, 1) INSERT INTO [dbo].[OrderInformation] ([OrderID], [CustomerID]) VALUES (564, 8) Now, execute following query on the Customers database to create the CustomerInformation table and input the sample data. CREATE TABLE [dbo].[CustomerInformation]( [CustomerID] [int] NOT NULL, [CustomerName] [varchar](50) NULL, [Company] [varchar](50) NULL CONSTRAINT [CustID] PRIMARY KEY CLUSTERED ([CustomerID] ASC) ) INSERT INTO [dbo].[CustomerInformation] ([CustomerID], [CustomerName], [Company]) VALUES (1, 'Jack', 'ABC') INSERT INTO [dbo].[CustomerInformation] ([CustomerID], [CustomerName], [Company]) VALUES (2, 'Steve', 'XYZ') INSERT INTO [dbo].[CustomerInformation] ([CustomerID], [CustomerName], [Company]) VALUES (3, 'Lylla', 'MNO') Database scoped master key and credentials Open SQL Server Management Studio or SQL Server Data Tools in Visual Studio. Connect to the Orders database and execute the following T-SQL commands: CREATE MASTER KEY ENCRYPTION BY PASSWORD = ' '; CREATE DATABASE SCOPED CREDENTIAL ElasticDBQueryCred WITH IDENTITY = '', SECRET = ' '; The "username" and "password" should be the username and password used to login into the Customers database. Authentication using Azure Active Directory with elastic queries is not currently supported. External data sources To create an external data source, execute the following command on the Orders database: CREATE EXTERNAL DATA SOURCE MyElasticDBQueryDataSrc WITH (TYPE = RDBMS, LOCATION = '.database.windows.net', DATABASE_NAME = 'Customers', CREDENTIAL = ElasticDBQueryCred, ) ; External tables Create an external table on the Orders database, which matches the definition of the CustomerInformation table: CREATE EXTERNAL TABLE [dbo].[CustomerInformation] ( [CustomerID] [int] NOT NULL, [CustomerName] [varchar](50) NOT NULL, [Company] [varchar](50) NOT NULL) WITH ( DATA_SOURCE = MyElasticDBQueryDataSrc) Execute a sample elastic database T-SQL query Once you have defined your external data source and your external tables you can now use T-SQL to query your external tables. Execute this query on the Orders database: SELECT OrderInformation.CustomerID, OrderInformation.OrderId, CustomerInformation.CustomerName, CustomerInformation.Company FROM OrderInformation INNER JOIN CustomerInformation ON CustomerInformation.CustomerID = OrderInformation.CustomerID</p>]]></content:encoded> <category><![CDATA[Optimization]]></category> <link>http://www.consuminglinkeddata.org/multi-database-query</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/multi-database-query</guid> <pubDate>Sun, 23 Aug 2020 15:53:00 +0000</pubDate> </item> <item> <title>Query different database SQL server</title> <description>Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle. Many types OLE DB data ...</description> <content:encoded><![CDATA[<img src="/img/how_can_i_clone_an_sql.jpg" alt="How can I clone an SQL Server database on the same server in SQL" align="left" /><p>Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle. Many types OLE DB data sources can be configured as linked servers, including Microsoft Access and Excel. Linked servers offer the following advantages: 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. Read more about Linked Servers . Server Objects -> Linked Servers -> New Linked Server Provide Remote Server Name. Select Remote Server Type (SQL Server or Other). Select Security -> Be made using this security context and provide login and password of remote server. Click OK and you are done !! Here is a simple tutorial for creating a linked server. OR You can add linked server using query. Syntax: sp_addlinkedserver [ @server= ] 'server' [, [ @srvproduct= ] 'product_name' ] [, [ @provider= ] 'provider_name' ] [, [ @datasrc= ] 'data_source' ] [, [ @location= ] 'location' ] [, [ @provstr= ] 'provider_string' ] [, [ @catalog= ] 'catalog' ] Read more about sp_addlinkedserver.</p>]]></content:encoded> <category><![CDATA[Optimization]]></category> <link>http://www.consuminglinkeddata.org/query-different-database-sql-server</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/query-different-database-sql-server</guid> <pubDate>Mon, 03 Aug 2020 15:51:00 +0000</pubDate> </item> <item> <title>Direct and Indirect SEO</title> <description>At the query “what is SEO” in the search engines a lot of information will be released (mainly advertising). Some resources, answering this question, quote each other, some give their own definitions of SEO, but this does not ...</description> <content:encoded><![CDATA[<img src="/img/5-digital-marketing-1725340_590.jpg" alt="Weekend Scripter: Use PowerShell to Work with SQL Server 2012" align="left" /><p>At the query “what is SEO” in the search engines a lot of information will be released (mainly advertising). Some resources, answering this question, quote each other, some give their own definitions of SEO, but this does not add clarity to the question. SEO is any action aimed at bringing your website or any other of your resources to the top positions of search engines to attract visitors. Many users buy basklinks for this purpose. This is not only the direct promotion of your site, but also the indirect attraction of visitors to your site by posting their materials on other Internet resources. Th...</p>]]></content:encoded> <category><![CDATA[Optimization]]></category> <link>http://www.consuminglinkeddata.org/Optimization/direct-and-indirect-seo</link> <guid isPermaLink="true">http://www.consuminglinkeddata.org/Optimization/direct-and-indirect-seo</guid> <pubDate>Tue, 14 Jul 2020 16:06:00 +0000</pubDate> </item> </channel></rss>If you would like to create a banner that links to this page (i.e. this validation result), do the following:
Download the "valid RSS" banner.
Upload the image to your own server. (This step is important. Please do not link directly to the image on this server.)
Add this HTML to your page (change the image src attribute if necessary):
If you would like to create a text link instead, here is the URL you can use:
http://www.feedvalidator.org/check.cgi?url=http%3A//www.consuminglinkeddata.org/feed/rss/
