SQL Server Data Warehousing
New & Notable
Download: 60-Page Expert RDBMS Guide
Trends come and go, but your DB strategy shouldn’t be a flavor of the month. Learn why you shouldn’t get distracted by new DB technology, how Facebook is using a RDBMS to do the data slicing and dicing they can’t in Hadoop, and more.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
SQL Server Data Warehousing News
-
November 21, 2017
21
Nov'17
Microsoft Azure cloud database activity takes off at Connect();
Microsoft Connect(); 2017 saw the addition of MariaDB and Cassandra to the Azure cloud database lineup. Also discussed: A set of Spark-based analytics services called Azure Databricks.
-
July 12, 2017
12
Jul'17
Azure SQL Data Warehouse turns up the heat, expands processing power
Spirited competition is under way among cloud providers as they enhance large-scale relational data warehouses in the cloud. An Azure SQL Data Warehouse update by Microsoft is the latest example.
-
May 18, 2017
18
May'17
Azure Cosmos multimodel database delivers features familiar and new
There are bits of DocumentDB at the foundation of Microsoft's Azure Cosmos DB, a multimodel database that supports multiple modes of data processing.
-
April 21, 2017
21
Apr'17
SQL Server 2017 makes Python a first-class citizen for analytics
Python is no longer a database outsider at Microsoft. The programming language is riding alongside R for analytics uses as SQL Server 2017 moves to its second preview release.
SQL Server Data Warehousing Get Started
Bring yourself up to speed with our introductory content
-
U-SQL
U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments. Continue Reading
-
How to use a SQL Server create database script to set up databases
You can create SQL Server databases manually, but knowing how to do a scripted database setup is valuable. Here are the steps involved in executing a create database script. Continue Reading
-
How to use Python in SQL Server 2017 to run analytics applications
From installation to implementation, here are the basic details on how to take advantage of the Python programming language in SQL Server 2017. Continue Reading
Evaluate SQL Server Data Warehousing Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
Microsoft Cosmos DB takes Azure databases to a higher level
Azure Cosmos DB brings a new element to the database lineup of Microsoft's cloud platform, offering multiple data models and a scalable environment for distributed applications. Continue Reading
-
Expect big data doings at upcoming Microsoft Ignite conference
Ignite 2017 and the Microsoft data portfolio are the topics of this edition of the Talking Data podcast. On tap is a closer look at Azure Cosmos DB. Continue Reading
-
A closer look at Python-SQL Server 2017 integration
Looking to take advantage of SQL Server 2017's support for Python? Here's what you need to know to get started on using the analytics programming language with Microsoft's database. Continue Reading
Manage SQL Server Data Warehousing
Learn to apply best practices and optimize your operations.
-
New SQL Server 2017 features give good reasons for fast upgrades
The new SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database platform, even coming so soon after the 2016 release. Continue Reading
-
Conquer real-time operational analytics in SQL Server 2016
Analytics helps improve business operations, and SQL Server 2016 users can master it -- in real time, using operational data in a transactional database. Continue Reading
-
Shining a light on SQL Server storage tactics
A good storage plan is key to proper database management no matter what system database administrators are working in. Without a sufficient SQL Server storage plan, the system may run out of space or process tasks too slowly. This handbook examines ... Continue Reading
Problem Solve SQL Server Data Warehousing Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
Five SQL Server 2012 business intelligence features
The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release. Continue Reading
-
Examining SQL Server 2012 data warehouse appliances
Take a look at some HP and Dell SQL Server 2012 data warehouse appliances to see if any might fit your business needs. Continue Reading
-
Set database constraints using SQL Server Management Studio Table Designer
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Continue Reading