News

February 12, 2019 12 Feb'19
Talend Stitch tools load data to Azure SQL Data Warehouse

Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it recently bought, reflects the trend.
November 30, 2018 30 Nov'18
Faster R&D pace complicates SQL Server upgrades for users

Microsoft is updating SQL Server and Azure SQL Database more quickly than it did in the past -- and keeping up with the new releases can be a tough task for DBAs.
November 29, 2018 29 Nov'18
Microsoft data platform gets new cloud, on-prem features

Microsoft released a second preview of SQL Server 2019 and said users can now run applications in either on-premises SQL Server systems or its Azure SQL Database cloud service.
November 12, 2018 12 Nov'18
Enterprise Power BI platform advances with SSRS, 'dataflows'

Microsoft embeds its SSRS reporting software and more-advanced data preparation tools in Power BI, part of a plan to blend self-service and enterprise BI for users.
November 08, 2018 08 Nov'18
Microsoft Azure SQL Database nears parity with SQL Server

Microsoft is adding functionality to Azure SQL Database to enable users to migrate more SQL Server applications to the cloud platform and run bigger databases on it.
Sponsored News
- How IT leaders can prepare IT architectures for an AI future using Intel Xeon® with DL Boost
  
  Sponsored by Intel - IT leaders are preparing their organisations for increasing use of artificial intelligence (AI) to extract the insights they need from growing amounts of data. To help them, Intel is enabling businesses to future-proof their IT architecture by building AI accelerators into its second-generation Xeon® scalable processors. See More
- Delivering datacentre performance and cost savings with Intel Optane technology
  
  Sponsored by Intel - Intel® Optane™ technology is the first memory and storage breakthrough in 25 years. Based on Intel® 3D XPoint™ memory media, it offers a new generation of solid-state devices (SSDs) and memory modules built from the ground up. See More
- Improve Datacentre Performance by Closing the Gaps in Memory and Storage Hierarchy
  
  Sponsored by Intel - Remember what it felt like when you got your first solid state drive (SSD)? Back in 2008, laptops with a hard disk drive (HDD) felt unresponsive – they lagged and nearly ground to a halt when the virus scanner started accessing the HDD. Then Intel launched the X-25M SSD and laptops felt much more responsive. Gone was the lag. Nobody noticed when the virus scanner ran. See More
- Where to start with AI – the journey from business need to delivery
  
  Sponsored by Intel - Businesses are excited about artificial intelligence (AI) and the benefits it offers, but like so many new technologies, that potential can be wasted if you don’t know where to begin the journey to production-ready AI. See More
View All Sponsored News
October 31, 2018 31 Oct'18
PASS Summit 2018 spotlights new demands on SQL Server DBAs

This year's PASS Summit comes as SQL Server 2019 looms and the cloud becomes a bigger factor. PASS board member Tim Ford talks about key trends ahead of it.
September 25, 2018 25 Sep'18
SQL Server 2019 preview brings Hadoop, Spark and AI into DBMS

A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure Cosmos DB also gets an update.
August 29, 2018 29 Aug'18
Talend tool targets Azure data integration for analytics use

Talend released software that does bulk data uploads to Microsoft's Azure SQL Data Warehouse. The goal is to streamline data integration and support real-time analytics.
June 11, 2018 11 Jun'18
Proposed Microsoft-GitHub buy confirms open source role in cloud

The looming Microsoft-GitHub pairing confirms the company's rebirth as an open source friend. Data tools on the Azure cloud are part of the motivation.
May 16, 2018 16 May'18
Azure Cosmos DB features, pricing morph with new provisioning model

The ability to provision Azure Cosmos DB throughput at the database level could come with pricing sticker shock for some users of Microsoft's multimodel database.
March 21, 2018 21 Mar'18
ObjectRocket launches Azure MongoDB service

Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.
January 17, 2018 17 Jan'18
Meltdown and Spectre fixes eyed for SQL Server performance issues

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.
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.
November 09, 2017 09 Nov'17
Microsoft boosts SQL Server machine learning services

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 PASS Summit 2017.
November 06, 2017 06 Nov'17
Power BI updates drive Microsoft's latest hybrid cloud efforts

At PASS Summit 2017, Microsoft Azure's strides were measured in steps. These include Power BI updates that bring cloud reporting services down to earth.
September 26, 2017 26 Sep'17
Microsoft SQL Server 2017 for Linux hits GA, IT pros encouraged

Microsoft SQL Server 2017 becomes available in October. In addition to a version that runs on Linux, new features include support for Python-based analytics.
July 27, 2017 27 Jul'17
SQL Server for Linux gets closer -- Windows database adds HA traits

SQL Server for Linux has gained added features on its way to general availability as part of the almost-ready SQL Server 2017. Meanwhile, its Windows-based brother is upping its high availability quotient.
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.
March 22, 2017 22 Mar'17
Redgate tools help bring database DevOps to Visual Studio 2017

So far, data has been left out of the DevOps discussion. But DevOps for databases could grow if tools like Redgate's bundle embedded in Visual Studio 2017 carry through on their promises.
November 18, 2016 18 Nov'16
Microsoft previews SQL Server on Linux, opens features across editions

Microsoft looks to broaden the horizons of SQL Server, as it moves some Enterprise features to Standard Edition and issues the first public preview of a release supporting SQL Server on Linux.
November 14, 2016 14 Nov'16
Cask framework aims to speed Azure HDInsight data pipeline builds

A link between Cask Data's CDAP application and integration environment and Azure HDInsight, Microsoft's Hadoop cloud service, is meant to cut development time on big data applications.
September 30, 2016 30 Sep'16
Azure Data Lake Analytics gets boost from U-SQL, a new SQL variant

The big data movement has frozen out many data professionals who are versed in SQL. Microsoft's U-SQL programming language tries to get such folks back in the data querying game.
July 21, 2016 21 Jul'16
Azure SQL Data Warehouse brings MPP to Microsoft cloud

As Azure SQL Data Warehouse reaches general availability, it brings massively parallel processing to a wider audience, and augers more competition in the cloud data space.
May 25, 2016 25 May'16
The story behind free SQL Server licensing for Oracle users

Microsoft wants to make Oracle customers an offer they can't refuse: free SQL Server licensing if they switch over. The question is whether or not the deal is as good as it looks.
May 13, 2016 13 May'16
SQL Server 2016 features to make DBAs' lives easier

SQL Server 2016 is on the launch pad for a June 1 release with a number of notable built-in features along with improvements to some long-neglected capabilities.
April 28, 2016 28 Apr'16
Database trends to watch after SQL Server 2005 end of life

Two database industry experts discuss infrastructure and analytics trends to consider for database upgrades following the end of SQL Server 2005 extended support.
April 28, 2016 28 Apr'16
Why SQL Server 2005 end of life is good news for DBAs

Two database experts explain how to take advantage of the opportunity created by SQL Server 2005 end of life and how to build a better database.
March 16, 2016 16 Mar'16
Microsoft opens up to open source with SQL Server on Linux

Microsoft put aside its rocky relationship with open source and will release SQL Server on Linux in mid-2017. This won't be a simple process, but it could net Microsoft new customers.
March 04, 2016 04 Mar'16
Best practices for upgrading after SQL Server 2005 end of life

SQL Server 2005 end of life is coming next month. Experts explain which version of SQL Server to upgrade to, and where in the migration process organizations need to be.
February 02, 2016 02 Feb'16
An easier way to set up SQL Server on an Azure virtual machine

Microsoft offers a simpler way to configure SQL Server on an Azure virtual machine. Added automation should help speed up the connecting and provisioning process.
October 21, 2015 21 Oct'15
The Azure SQL Data Warehouse gains an auditing feature

Microsoft announced that it had enabled an auditing feature for the Azure SQL Data Warehouse. The new feature has many benefits, but storing audit logs won't be free.
July 09, 2015 09 Jul'15
Limited public preview opens for Azure SQL Data Warehouse

Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
May 12, 2015 12 May'15
SQL Server 2016 preview announced for summer 2015

Microsoft CEO Satya Nadella announced the SQL Server 2016 preview for this summer. Its new features model the ethos of "mobile first, cloud first."
May 07, 2015 07 May'15
Will the R language benefit from Microsoft acquisition?

Microsoft's recent acquisition of Revolution Analytics could go a long way in solidifying the R language's hold on analytical solutions.
March 24, 2015 24 Mar'15
Vendors introduce three new SQL Server appliances

If SQL Server appliances are on your radar, you have options, but the price tag is high. Do your homework before buying. Here are the current offerings.
November 25, 2014 25 Nov'14
SQL Server monitoring tools help DBAs take back nights and weekends

Many DBAs have to work more and more nights and weekends to fulfill zero-downtime demands. But tools for monitoring and managing SQL Server might free up some of that time.
November 07, 2014 07 Nov'14
PASS 2014 keynoter previews coming SQL Server advances

Microsoft previewed a cloud database update and highlighted three new analytics applications at PASS 2014, reflecting its idea of using data to 'understand the past, analyze the present and predict the future.
June 05, 2014 05 Jun'14
SQL Server 2014 etches itself in-memory

Microsoft's flagship database is advancing into the largely undiscovered country of in-memory OLTP platforms -- and it's hoping to conquer.
March 24, 2014 24 Mar'14
Finding the right problem for SQL Server 2014's in-memory OLTP

Consultant Denny Cherry talks changes, misconceptions and what people really want from SQL Server 2014, which is generally available on April 1.
March 07, 2014 07 Mar'14
SQL Server 2012 SP2 due out later this year, and other SQL Server news

Following a request from some SQL Server MVPs, Microsoft has announced that SQL Server 2012 SP2 will come out sometime later this year.
February 19, 2014 19 Feb'14
Interactive reports highlight Microsoft SQL Server Reporting Services

Author and Reporting Services expert Brian Larson discusses features of SQL Server Reporting Services in this interview.
January 31, 2014 31 Jan'14
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.
January 09, 2014 09 Jan'14
SQL business intelligence takes forefront at PASS events

The Professional Association for SQL Server (PASS) will hold two SQL business intelligence events in the coming months. BI is big for SQL Server pros.
October 17, 2013 17 Oct'13
Microsoft releases SQL Server 2014 CTP 2

This is the last Community Technology Preview (CTP) for SQL Server until it becomes generally available in the first half of next year.
October 04, 2013 04 Oct'13
Coping with the fast pace of new SQL Server versions

Microsoft has upped the ante, releasing new SQL Server versions at a quicker pace. How will you adapt?
June 21, 2013 21 Jun'13
SQL Server 2014 all about big data, in-memory analytics and cloud

In this issue of SQL in Five, Mark Kromer lists usual features of the upcoming SQL Server 2014, but also highlights a different one: Data Explorer.
June 12, 2013 12 Jun'13
SQL Server 2014 'keeps up with the Joneses,' says analyst

Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
June 03, 2013 03 Jun'13
SQL Server 2014 due out in late 2013, in-memory OLTP a big feature

Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.
April 15, 2013 15 Apr'13
Microsoft unveils GeoFlow 3-D SQL Server mapping tool

Microsoft GeoFlow gives premium Excel users the ability to do 3-D mapping with SQL Server on the back end.
March 25, 2013 25 Mar'13
SQL Server big data technologies should be a major DBA focus

Microsoft platform architect Mark Kromer says in this Q&A that DBAs need to start focusing on SQL Server big data technologies to stay up-to-date.
January 08, 2013 08 Jan'13
Brian Larson talks SQL Server business intelligence

Author Brian Larson shares his wisdom and insight regarding SQL Server business intelligence and makes some suggestions for companies new to BI.
November 14, 2012 14 Nov'12
SQL Server DBAs must get ready to take on 'big data' and more roles

Leaders of the Professional Association for SQL Server say today's DBAs have to handle 'big data' and more types of tasks than ever before.
November 07, 2012 07 Nov'12
Microsoft previews new SQL Server in-memory database features

Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server.
June 27, 2012 27 Jun'12
Jam session at Microsoft TechEd proves geeks can have fun too

Our associate editor, Lena J. Weiner, went to a jam session at Microsoft TechEd on a specific quest: to prove that geeks are the biggest party animals. Read this article to see what she discovered.
June 26, 2012 26 Jun'12
Three SQL Server tips Denny Cherry wants you to know

Which SQL Server technologies are hot right now? What does a SQL expert wish you knew about SQL Server? Hint: BI and data growth have a lot to do with it.
June 12, 2012 12 Jun'12
Back up SQL Server to SQL Azure? Some have their fingers crossed

With Microsoft broadcasting the importance of its cloud computing platform, some SQL Server pros want to use the cloud database service as a backup to their on-premises SQL Server databases.
June 11, 2012 11 Jun'12
TechEd 101: Scoring some ice cream

Knowing your way around the monstrous Microsoft show isn’t always easy, but three show veterans give their take on what works.
June 06, 2012 06 Jun'12
Ahead of TechEd, Microsoft speaks on SQL Server 2012, Amazon RDS

Mark Kromer gives tips on what he thinks will be the best sessions at Microsoft TechEd 2012, and also comments on SQL Server in the cloud and a recent Amazon announcement.
April 18, 2012 18 Apr'12
Microsoft’s SQL Server 2012 has muscle, but database battle is fierce

One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.
April 11, 2012 11 Apr'12
Big data a big deal for SQL Server 2012, users say

SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.
March 14, 2012 14 Mar'12
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing

With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.
March 12, 2012 12 Mar'12
Don’t sweat migration from Oracle, Sybase to SQL Azure

Are you considering moving your database to Azure? Concerned about complexity? Read this tip from expert Denny Cherry. Migrating to SQL Azure might be the easiest move ever.
March 02, 2012 02 Mar'12
Microsoft bulks up SQL Server scalability to rival buff competition

Better SQL Server scalability and lower costs have furthered Microsoft’s reach in recent years, industry observers say, and that’s good, because the competition is big and knows the turf well.
March 01, 2012 01 Mar'12
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases

Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together?
February 14, 2012 14 Feb'12
Microsoft SQL Server 2012 goes big -- data, that is

Microsoft database platform specialist Mark Kromer talks in this Q&A about Microsoft SQL Server 2012 “big data” capabilities, as well as what SQL Server has in store for open source and cloud computing this year.
February 13, 2012 13 Feb'12
SQL Server 2012, cloud, ‘big data’ driving momentum in 2012

With SQL Server 2012 coming out and the growing influence of the SQL Azure cloud and “big data,” the SQL Server landscape could see some major changes in the coming months.
January 19, 2012 19 Jan'12
Cost, proliferation power rise of SQL Server data warehousing

SQL Server data warehousing may have seemed a misnomer a few years ago. But many Microsoft shops with growing data needs are seeing the benefits of native products.
January 18, 2012 18 Jan'12
For SQL Server shops testing Azure cloud, it’s all about integrating data

With tool sets still evolving, developers face stiff challenges in integrating data in hybrid SQL Server-SQL Azure environments.
December 05, 2011 05 Dec'11
Securing SQL Server: Quick, easy, routinely ignored

A recent wave of high-profile attacks has highlighted the importance of securing SQL Server. But protecting the database application is something most companies have historically overlooked.
November 15, 2011 15 Nov'11
Microsoft’s ‘big data’ push targets familiar products, new capabilities

In this interview, Microsoft executive Mark Kromer discusses newly unveiled Microsoft ‘big data’ features and products announced at last month’s PASS Summit 2011.
October 20, 2011 20 Oct'11
Microsoft StreamInsight charts course in unfamiliar waters

Microsoft StreamInsight, a complex event processing product, is a stab at a whole new space for the company, and not a bad one at that, experts say.
October 19, 2011 19 Oct'11
Microsoft retooling SQL Server Master Data Services after 'vexing' debut

Microsoft’s master data management product in SQL Server, Master Data Services, drew tepid reviews from users, but the company has high hopes for a revamped release.
October 13, 2011 13 Oct'11
Microsoft folds Hadoop into SQL Server 2012, Windows Azure

Microsoft said it will release SQL Server 2012, formerly Denali, next year and detailed its Hadoop-based strategy for handling the explosion of big data at the PASS 2011 conference.
September 13, 2011 13 Sep'11
Microsoft SQL Server, PDW reach out to Hadoop for big data processing

In this Q&A, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.
July 05, 2011 05 Jul'11
SQL Server virtualization risks: among all the pros, some cons

Virtualization promises big savings for businesses, and few are decrying its influence. But is it always the answer? Are there SQL Server virtualization risks to learn about first?
June 09, 2011 09 Jun'11
Upgrade SQL Server; your BI system will thank you

Better performing BI systems are invaluable to businesses itching to get ahead. Upgrade SQL Server to a newer version, Don Jones says, and you’ll be a step closer.
June 07, 2011 07 Jun'11
Q&A: With SQL Azure, Microsoft eyes giant leap to the cloud

It was cloud, cloud, cloud at Microsoft TechEd 2011. Microsoft’s Mark Kromer discusses the SQL Azure, what’s new with the cloud database offering and what’s to come.
May 20, 2011 20 May'11
SQL Server Denali overshadows the Azure cloud for attendees at Microsoft TechEd

Cloud was the word at Microsoft TechEd, but attendees’ interest was rooted in SQL Server Denali, the upcoming version of the database that will be released in a CTP this summer.
May 19, 2011 19 May'11
SQL Server BI performance for the uninitiated

Maintaining a SQL Server business intelligence (BI) system may be challenging for many database administrators, but there’s a lot you can do to ensure top SQL Server BI performance.
April 07, 2011 07 Apr'11
Q&A: New Microsoft products focus on configuration, virtualization

There’s been a slew of new Microsoft products lately, including an upgrade for Project Atlanta. A company expert discusses this development, third-party tools and more.
February 24, 2011 24 Feb'11
SQL Server virtualization more than a passing trend?

Virtualization may be taking data centers by storm, but what’s behind the trend? In this month’s “SQL in Five,” SearchSQLServer.com asks Microsoft’s Mark Kromer about the benefits and difficulties of virtualizing SQL Server.
January 25, 2011 25 Jan'11
Q&A: Exploring what’s hot: SQL Server virtualization, PowerPivot, PDW

Want the inside scoop on SQL Server virtualization, PowerPivot, parallel data warehouse and the upcoming Denali? Microsoft database expert Mark Kromer discuss these year-driving trends and more.
January 13, 2011 13 Jan'11
In 2011, SQL Server market trending toward cloud, virtualization

Higher SQL Server cloud adoption with more competition and SQL Server virtualization will get top billing in the SQL Server market in 2011, experts predict. Plus, self-service BI is on the up and up, along with solid-state devices.
December 21, 2010 21 Dec'10
Q&A: Microsoft surveys horizon as cloud computing providers mount

Salesforce.com’s upcoming cloud offering Database.com will widen the pantheon of cloud computing providers, but Microsoft's Mark Kromer says SQL Azure can handle the competition. Read on for Kromer’s thoughts on the expanding market, what makes ...
November 16, 2010 16 Nov'10
Q&A: Staying aloft in SQL Azure development

It’s been an eventful year for SQL Azure. In the wake of big announcements at the recent Professional Developers Conference (PDC) and the Professional Association for SQL Server (PASS) Summit, Microsoft data platform specialist Mark Kromer discusses...
November 11, 2010 11 Nov'10
Microsoft gives tour of new release of SQL Server

Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features.
November 09, 2010 09 Nov'10
Microsoft releases new parallel data warehouse, previews Denali

Microsoft detailed its new parallel data warehouse capabilities and a cloud-based support offering, and also provided a glimpse of what's to come in the next SQL Server release.
August 31, 2010 31 Aug'10
Q&A: Scaling out with Parallel Data Warehouse for SQL Server 2008 R2

With the official release of R2’s Parallel Data Warehouse edition coming soon, Microsoft’s Mark Kromer breaks down the management and architecture considerations to be aware of.
August 04, 2010 04 Aug'10
Q&A: SQL Server business intelligence meets the cloud

Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.
August 01, 2010 01 Aug'10
What's the real value of SQL Server certification?

Not all certs are created equal, but changes to Microsoft’s certification track over the past few years have left some database professionals curious about what to pursue.
May 05, 2010 05 May'10
Microsoft changes virtualization licensing for SQL Server 2008 R2

The company has put the kibosh on unlimited virtualization rights with SQL Server 2008 R2 Enterprise Edition.
April 21, 2010 21 Apr'10
Microsoft, beta testers tout SQL Server 2008 R2 PowerPivot

The company’s new database release aims to free up information for non-DBAs while also enforcing compliance.
January 04, 2010 04 Jan'10
SQL Azure officially becomes paid service

Customers can now upgrade their CTP accounts to new paid subscriptions of Microsoft's cloud-based database service.
December 02, 2009 02 Dec'09
SQL Server 2008 R2 could drop in May

Microsoft has shed more light on when customers can expect the latest version of SQL Server, due out in the first half of 2010.
November 23, 2009 23 Nov'09
Is interest in SQL Server virtualization on the rise?

While the challenges of SQL Server virtualization have scared off some organizations, new technologies could make them take a second look.
November 03, 2009 03 Nov'09
New SQL Server 2008 R2 CTP set for November

Microsoft's next-generation DBMS will be released to manufacturing in early 2010, along with two new editions for the enterprise.
November 02, 2009 02 Nov'09
DBA career paths could lead to business intelligence

Business intelligence could prove to be an ideal specialty for SQL Server DBAs who feel like they've hit a wall with their current jobs.
October 23, 2009 23 Oct'09
Are data warehouses made for the cloud?

Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow deployments.

News

Sponsored News