Schema-Root.org logo

 

  cross-referenced news and research resources about

 sql

Schema-Root.org logo
images:  google   yahoo YouTube
spacer

updated Thu. May 3, 2018

-
The convergence of SQL and NoSQL solutions is something that has been going on for a while. A typical way to deal with this requirement is multi-model databases. But Goldberg and Bernhardy decided to take a different approach. They felt multi-model was inherently flawed as a design pattern, were ...
Those who want to learn SQL can find some useful courses as well. For example, one of the latest is called “SQL Tutorial for Beginners Learn in 7 Days” and it teaches you database design as well as basic to advanced SQL. No previous experience with SQL is required to start the course. Plus, there is no ...

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can't just restore it to any instance. You can only restore the database backup to an instance that contains ...
SQL Ops Studio, as the tool is informally known, supports many of the same features as the more sophisticated SQL Server Management Studio (SSMS). However, Microsoft designed it to simplify many of the basic tasks performed by database administrators (DBAs), making routine database operations ...
Kernel memory contains protected information from the operating system like your passwords (in plain text), cached data (think the SQL Server buffer pool) and various other things that could be used to attack your systems. All that is bad enough, but the fact that Spectre/Meltdown is a CPU exploit means ...
In a previous article, we discussed Dynamic Data Masking (DDM) and how DDM helps to secure PII/PHI data from unprivileged users. The DDM feature is available in SQL Server 2016 onwards as well as Azure SQL Database. This feature is useful to implement data security for existing data sets and future ...

The latest improvements to Microsoft's SQL Operations Studio (MSOS) are now available, marking the data management tool's second update since its public preview debut at November's PASS Summit. MSOS is a lightweight, cross-platform offering that combines functionality found in tools like the Visual ...
Microsoft has responded to the Spectre and Meltdown chip vulnerabilities with patches and other fixes. But IT teams need to sort out SQL Server performance issues they may create.
I am struggling a bit on a SQL statement that deals with range of numbers in fields in the database. It goes to $10,000,000. Sales price and LoanAmont will be in a form and posted to the handler page. If you look at my graphic, let's take this example: $65,000 - $70,000 has the same Escrow fee. So what if a ...
SQL databases such as MySQL guarantee strong consistency, but don't scale well horizontally. (Manual sharding for scalability is no one's idea of fun.) NoSQL databases such as MongoDB scale beautifully, but offer only eventual consistency. (“Wait long enough, and you can read the right answer”—which ...
But there's no time to relax: SQL Server database administrators need to be ready for a host of additional changes and new technologies in 2018. Let's take a look at five major SQL Server database trends that database administrators (DBAs), developers and IT managers should be on top of as we head ...
There's a lot of versions of SQL Server available today. I've seen clients deploying new services on SQL Server 2015, SQL Server 2016, SQL Server 2017 (yes we have a client on SQL Server 2017 already) and SQL DB. But if you're deploying a new SQL Server what's the right version to deploy?
In a previous article we discussed Data Migration Assistant (DMA) and how DMA can help in migrating an older version of SQL Server to SQL Server 2017. In this article, we will walk through a step by step approach to assess your SQL Server migration using DMA. This activity will help you to understand ...
Before trying to implement a SQL Server container, make sure you understand the components that go into supporting one. That includes not only the Docker platform, but also the host operating system (OS), the available Docker base images and the SQL Server edition you plan to run. Let's look at each ...
Out of the box, SQL Server will encrypt some things by default to protect you and your data. Out of the box, SQL Server will encrypt the passwords which are sent up from the client to the SQL Server. This will keep the password from being sniffed on the network when logging in to the SQL Server instance.
Governments should not release anonymised data that refers to individuals, because re-identification is inevitable. That's the conclusion from Melbourne University's Dr Chris Culnane, Dr Benjamin Rubinstein and Dr Vanessa Teague, who have shown that the Medicare data the Australian government ...
SQL stands for structured query language, a popular method to query databases of all sizes. While professional database administrators and SQL programmers are in high demand, you don't need a computer science degree to understand basic SQL. If you are a financial analyst, business owner, or online ...

Guru: Quirky SQL Creations ... The destination of an unqualified object depends first on whether you are using system (*SYS) or SQL (*SQL) naming convention. ... When using SQL convention, the system creates unqualified objects in a library with the same name as the user who is running the CREATE ...
SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in ...
We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for ...
Microsoft SQL—one of the most ubiquitous database management systems on the planet—runs countless businesses and platforms across the ...
SQL stands for 'Structured Query Language'. This is basically a declarative language used for storing and retrieving data in a database.
Python and R are among the tools in the SQL Server machine learning toolkit. Native T-SQL scoring is also on the agenda, as uncovered at ...
Effectively managing SQL Server databases requires administrators to adopt tried and true best practices, while also leveraging automation ...
A bug discovered in WordPress allows attackers to trigger an SQL injection attack leading to complete website hijacking. The vulnerability was ...
SQL Server 2017 already ships with built-in AI (artificial intelligence) capabilities, as well as Linux and DevOps-friendly application container ...
A bug exploitable in WordPress 4.8.2 and earlier creates unexpected and unsafe conditions ripe for a SQL injection attack, exposing sites ...
As the co-creator of Structured Query Language (SQL), Don Chamberlin knows a thing or two about pulling data out of relational databases.
Barely a month out of the gate, and not only is Microsoft's SQL Server 2017 off to a strong start, but it's opening up new opportunities for ...
On Wednesday, Microsoft showed off a series of new tools and services aimed at helping companies bridge gap between their on-premise SQL ...
NewSQL databases put special emphasis on SQL transactions, with atomicity, consistency and other processing attributes. At the same time, ...
Having been involved in the SQL Server Community for 20 years, she is a independent consultant, 4X Microsoft Data Platform MVP and Idera ...
Structured Query Language or SQL is considered the standard language for database management systems. In this article, Chirag Thumar ...
Microsoft SQL Server 2017 is now available for the first time on Windows, Linux, and Docker. In this Ask the Admin, I'll look at what this means ...
Among the many exciting updates announced at Microsoft Ignite, the company announced the general availability of SQL Server 2017.
This article is the third part in a series about graph matching tasks. Part 1 introduced what graph matching is and related concepts.
SQL Server 2017 sets the standard when it comes to speed and performance. Based on the incredible work of SQL Server 2016 (See the blog ...
I'll be honest, when I first learned about SQL Server on Linux, I didn't get it. It took like an hour for it to make sense to me. After a week of talking ...
Last week, during Microsoft's annual Ignite shindig, the company unveiled the latest version of their database platform SQL Server. SQL Server ...
Tens of thousands of tourists flocked to Florida's theme park town of Orlando last week, but they weren't there to see Mickey; they were there to ...
Microsoft announced this week that a faster update release pace will be coming to its newly announced SQL Server 2017 product. Microsoft ...
Beyond portability, SQL Server 2017 introduces advances in adaptive query processing, the ability to add clustered column stores for faster ...
SQL Server is one of Microsoft's traditional cash cows — Microsoft ... lines, Microsoft is also releasing on Monday a tool to take an existing SQL ...
SQL Server 2017 went into general availability today. Today's release is a remarkable step in SQL Server's history, because it's not just a ...
There are two options for deploying SQL Server on the Azure cloud. Here's a look at how they differ to help you choose between Azure SQL ...
This month on SQL Unplugged, Rohan and Scott discuss Azure SQL DW, Elastic Pools, SQL Server 2016 since GA, take a brief look into the ...
As an operations database administrator, you'll own our production MS SQL databases. You will be responsible for configuration, uptime, capacity planning, ...
A Production Database Administrator with a deep demonstrated knowledge of MS SQL administrative tasks and the ability to consult on design, development, ...
If something goes wrong with an embedded SQL statement or an SQL routine (a trigger, stored procedure or user-defined function), the system ...
SQL has been around for almost 40 years. SQL has been around in commercial form since 1979. That's when Relational Software, Inc. (which ...
The convergence of SQL and NoSQL solutions is something that has been going on for a while. A typical way to deal with this requirement is multi-model databases. But Goldberg and Bernhardy decided to take a different approach. They felt multi-model was inherently flawed as a design pattern, were ...
Those who want to learn SQL can find some useful courses as well. For example, one of the latest is called “SQL Tutorial for Beginners Learn in 7 Days” and it teaches you database design as well as basic to advanced SQL. No previous experience with SQL is required to start the course. Plus, there is no ...

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can't just restore it to any instance. You can only restore the database backup to an instance that contains ...
SQL Ops Studio, as the tool is informally known, supports many of the same features as the more sophisticated SQL Server Management Studio (SSMS). However, Microsoft designed it to simplify many of the basic tasks performed by database administrators (DBAs), making routine database operations ...
Kernel memory contains protected information from the operating system like your passwords (in plain text), cached data (think the SQL Server buffer pool) and various other things that could be used to attack your systems. All that is bad enough, but the fact that Spectre/Meltdown is a CPU exploit means ...
In a previous article, we discussed Dynamic Data Masking (DDM) and how DDM helps to secure PII/PHI data from unprivileged users. The DDM feature is available in SQL Server 2016 onwards as well as Azure SQL Database. This feature is useful to implement data security for existing data sets and future ...

The latest improvements to Microsoft's SQL Operations Studio (MSOS) are now available, marking the data management tool's second update since its public preview debut at November's PASS Summit. MSOS is a lightweight, cross-platform offering that combines functionality found in tools like the Visual ...
Microsoft has responded to the Spectre and Meltdown chip vulnerabilities with patches and other fixes. But IT teams need to sort out SQL Server performance issues they may create.
I am struggling a bit on a SQL statement that deals with range of numbers in fields in the database. It goes to $10,000,000. Sales price and LoanAmont will be in a form and posted to the handler page. If you look at my graphic, let's take this example: $65,000 - $70,000 has the same Escrow fee. So what if a ...
SQL databases such as MySQL guarantee strong consistency, but don't scale well horizontally. (Manual sharding for scalability is no one's idea of fun.) NoSQL databases such as MongoDB scale beautifully, but offer only eventual consistency. (“Wait long enough, and you can read the right answer”—which ...
But there's no time to relax: SQL Server database administrators need to be ready for a host of additional changes and new technologies in 2018. Let's take a look at five major SQL Server database trends that database administrators (DBAs), developers and IT managers should be on top of as we head ...
There's a lot of versions of SQL Server available today. I've seen clients deploying new services on SQL Server 2015, SQL Server 2016, SQL Server 2017 (yes we have a client on SQL Server 2017 already) and SQL DB. But if you're deploying a new SQL Server what's the right version to deploy?
In a previous article we discussed Data Migration Assistant (DMA) and how DMA can help in migrating an older version of SQL Server to SQL Server 2017. In this article, we will walk through a step by step approach to assess your SQL Server migration using DMA. This activity will help you to understand ...
Before trying to implement a SQL Server container, make sure you understand the components that go into supporting one. That includes not only the Docker platform, but also the host operating system (OS), the available Docker base images and the SQL Server edition you plan to run. Let's look at each ...
Out of the box, SQL Server will encrypt some things by default to protect you and your data. Out of the box, SQL Server will encrypt the passwords which are sent up from the client to the SQL Server. This will keep the password from being sniffed on the network when logging in to the SQL Server instance.
Governments should not release anonymised data that refers to individuals, because re-identification is inevitable. That's the conclusion from Melbourne University's Dr Chris Culnane, Dr Benjamin Rubinstein and Dr Vanessa Teague, who have shown that the Medicare data the Australian government ...
SQL stands for structured query language, a popular method to query databases of all sizes. While professional database administrators and SQL programmers are in high demand, you don't need a computer science degree to understand basic SQL. If you are a financial analyst, business owner, or online ...

Guru: Quirky SQL Creations ... The destination of an unqualified object depends first on whether you are using system (*SYS) or SQL (*SQL) naming convention. ... When using SQL convention, the system creates unqualified objects in a library with the same name as the user who is running the CREATE ...
SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in ...
We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for ...
Microsoft SQL—one of the most ubiquitous database management systems on the planet—runs countless businesses and platforms across the ...
SQL stands for 'Structured Query Language'. This is basically a declarative language used for storing and retrieving data in a database.
Python and R are among the tools in the SQL Server machine learning toolkit. Native T-SQL scoring is also on the agenda, as uncovered at ...
Effectively managing SQL Server databases requires administrators to adopt tried and true best practices, while also leveraging automation ...
A bug discovered in WordPress allows attackers to trigger an SQL injection attack leading to complete website hijacking. The vulnerability was ...
SQL Server 2017 already ships with built-in AI (artificial intelligence) capabilities, as well as Linux and DevOps-friendly application container ...
A bug exploitable in WordPress 4.8.2 and earlier creates unexpected and unsafe conditions ripe for a SQL injection attack, exposing sites ...
As the co-creator of Structured Query Language (SQL), Don Chamberlin knows a thing or two about pulling data out of relational databases.
Barely a month out of the gate, and not only is Microsoft's SQL Server 2017 off to a strong start, but it's opening up new opportunities for ...
On Wednesday, Microsoft showed off a series of new tools and services aimed at helping companies bridge gap between their on-premise SQL ...
NewSQL databases put special emphasis on SQL transactions, with atomicity, consistency and other processing attributes. At the same time, ...
Having been involved in the SQL Server Community for 20 years, she is a independent consultant, 4X Microsoft Data Platform MVP and Idera ...
Structured Query Language or SQL is considered the standard language for database management systems. In this article, Chirag Thumar ...
Microsoft SQL Server 2017 is now available for the first time on Windows, Linux, and Docker. In this Ask the Admin, I'll look at what this means ...
Among the many exciting updates announced at Microsoft Ignite, the company announced the general availability of SQL Server 2017.
This article is the third part in a series about graph matching tasks. Part 1 introduced what graph matching is and related concepts.
SQL Server 2017 sets the standard when it comes to speed and performance. Based on the incredible work of SQL Server 2016 (See the blog ...
I'll be honest, when I first learned about SQL Server on Linux, I didn't get it. It took like an hour for it to make sense to me. After a week of talking ...
Last week, during Microsoft's annual Ignite shindig, the company unveiled the latest version of their database platform SQL Server. SQL Server ...
Tens of thousands of tourists flocked to Florida's theme park town of Orlando last week, but they weren't there to see Mickey; they were there to ...
Microsoft announced this week that a faster update release pace will be coming to its newly announced SQL Server 2017 product. Microsoft ...
Beyond portability, SQL Server 2017 introduces advances in adaptive query processing, the ability to add clustered column stores for faster ...
SQL Server is one of Microsoft's traditional cash cows — Microsoft ... lines, Microsoft is also releasing on Monday a tool to take an existing SQL ...
SQL Server 2017 went into general availability today. Today's release is a remarkable step in SQL Server's history, because it's not just a ...
There are two options for deploying SQL Server on the Azure cloud. Here's a look at how they differ to help you choose between Azure SQL ...
This month on SQL Unplugged, Rohan and Scott discuss Azure SQL DW, Elastic Pools, SQL Server 2016 since GA, take a brief look into the ...
As an operations database administrator, you'll own our production MS SQL databases. You will be responsible for configuration, uptime, capacity planning, ...
A Production Database Administrator with a deep demonstrated knowledge of MS SQL administrative tasks and the ability to consult on design, development, ...
If something goes wrong with an embedded SQL statement or an SQL routine (a trigger, stored procedure or user-defined function), the system ...
SQL has been around for almost 40 years. SQL has been around in commercial form since 1979. That's when Relational Software, Inc. (which ...


resources


  Introduction to Structured Query Language
  SQL Fundamentals
  SQL for Web Nerds

 

news and opinion


 


 


 


 


schema-root.org

   software
    database
      sql