updated Thu. April 18, 2024
-
ZDNet
February 8, 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ÃÂ ...
JAXenter
February 8, 2018
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ÃÂ ...
Database Journal
February 1, 2018
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ÃÂ ...
TechTarget
January 31, 2018
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ÃÂ ...
Redmondmag.com
January 30, 2018
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ÃÂ ...
Database Journal
January 22, 2018
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ÃÂ ...
Redmondmag.com
January 22, 2018
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ÃÂ ...
TechTarget
January 17, 2018
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.
SitePoint
January 6, 2018
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ÃÂ ...
InfoWorld
January 5, 2018
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ÃÂ ...
TechTarget
December 29, 2017
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ÃÂ ...
TechTarget
December 26, 2017
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?
Database Journal
December 21, 2017
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ÃÂ ...
TechTarget
December 21, 2017
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ÃÂ ...
TechTarget
December 19, 2017
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.
The Register
December 17, 2017
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ÃÂ ...
Business 2 Community
December 13, 2017
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ÃÂ ...
IT Jungle
December 10, 2017
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ÃÂ ...
DABCC.com
November 17, 2017
SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in ...
DABCC.com
November 17, 2017
We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for ...
XDA Developers (blog)
November 14, 2017
Microsoft SQL—one of the most ubiquitous database management systems on the planet—runs countless businesses and platforms across the ...
Android Authority (blog)
November 9, 2017
SQL stands for 'Structured Query Language'. This is basically a declarative language used for storing and retrieving data in a database.
TechTarget
November 9, 2017
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 ...
Security Boulevard
November 3, 2017
Effectively managing SQL Server databases requires administrators to adopt tried and true best practices, while also leveraging automation ...
ZDNet
November 3, 2017
A bug discovered in WordPress allows attackers to trigger an SQL injection attack leading to complete website hijacking. The vulnerability was ...
eWeek
November 3, 2017
SQL Server 2017 already ships with built-in AI (artificial intelligence) capabilities, as well as Linux and DevOps-friendly application container ...
Threatpost
November 2, 2017
A bug exploitable in WordPress 4.8.2 and earlier creates unexpected and unsafe conditions ripe for a SQL injection attack, exposing sites ...
Datanami
November 2, 2017
As the co-creator of Structured Query Language (SQL), Don Chamberlin knows a thing or two about pulling data out of relational databases.
eWeek
November 2, 2017
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 ...
The Register
November 2, 2017
On Wednesday, Microsoft showed off a series of new tools and services aimed at helping companies bridge gap between their on-premise SQLÂ ...
TechTarget
October 20, 2017
NewSQL databases put special emphasis on SQL transactions, with atomicity, consistency and other processing attributes. At the same time, ...
Windows IT Pro
October 20, 2017
Having been involved in the SQL Server Community for 20 years, she is a independent consultant, 4X Microsoft Data Platform MVP and Idera ...
JAXenter
October 20, 2017
Structured Query Language or SQL is considered the standard language for database management systems. In this article, Chirag Thumar ...
Petri.com
October 19, 2017
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 ...
TechGenix (blog)
October 13, 2017
Among the many exciting updates announced at Microsoft Ignite, the company announced the general availability of SQL Server 2017.
SQL Server Pro
October 12, 2017
This article is the third part in a series about graph matching tasks. Part 1 introduced what graph matching is and related concepts.
DABCC.com
October 11, 2017
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 ...
TechTarget
October 10, 2017
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 ...
Lifehacker Australia
October 9, 2017
Last week, during Microsoft's annual Ignite shindig, the company unveiled the latest version of their database platform SQL Server. SQL Server ...
The Register
October 3, 2017
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 ...
Redmondmag.com
September 29, 2017
Microsoft announced this week that a faster update release pace will be coming to its newly announced SQL Server 2017 product. Microsoft ...
ZDNet
September 28, 2017
Beyond portability, SQL Server 2017 introduces advances in adaptive query processing, the ability to add clustered column stores for faster ...
Business Insider
September 25, 2017
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Â ...
Ars Technica
September 25, 2017
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 ...
TechTarget
September 15, 2017
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Â ...
Microsoft
January 9, 2000
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 ...
Built In Chicago
December 31, 1999
As an operations database administrator, you'll own our production MS SQL databases. You will be responsible for configuration, uptime, capacity planning, ...
Built In Chicago
December 31, 1999
A Production Database Administrator with a deep demonstrated knowledge of MS SQL administrative tasks and the ability to consult on design, development, ...
IT Jungle
December 31, 1999
If something goes wrong with an embedded SQL statement or an SQL routine (a trigger, stored procedure or user-defined function), the system ...
IoT For All (blog)
December 31, 1999
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
|
