SearchSQLServer
New & Notable
Evaluate
CDS for Analytics brings Power BI, data sources together
Integrating data into Power BI for analysis can be a challenge, but Microsoft's Common Data Service for Analytics technology is designed to simplify the process for users.
Evaluate
Report Server platform puts Power BI reports on premises
Updates to Power BI Report Server expand the on-premises platform's reporting functionality and increase the number of data sources users can connect to when building Power BI reports.
News
Azure database provisioned for multimodel action
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.
Get Started
SQL Server in containers: Not such a bad idea now
Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers.
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.
Trending Topics
-
Availability and Scalability Manage
Different ways to scale out SQL Server databases
Scaling out a database to meet the needs of a heavy processing workload can be a challenge. Here are details on the SQL Server scalability methods available to ease the process.
-
Consolidation and Virtualization Manage
Dockerfiles boost SQL Server container automation
As many in IT have learned the hard way, building software containers for systems like SQL Server can be tough. That's where Dockerfiles come in to help automate the process.
-
Migration and Planning Evaluate
What's new on the SQL Server horizon for 2018?
Here's a list of notable trends related to SQL Server that IT teams should be ready for over the next 12 months. Among them: increased use of the cloud, AI, Linux and containers.
-
Data Visualization News
R and Python bring new look to SQL Server
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.
-
Performance Tuning News
Spectre, Meltdown bugs threaten SQL Server performance
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.
-
Tools and Utilities News
MongoDB on Azure gains in interest
Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.
Topics Covered
-
Microsoft SQL Server Administration (10) +
- Microsoft SQL Server Installation
- Microsoft SQL Server Performance Monitoring and Tuning
- Microsoft SQL Server Tools and Utilities
- SQL Server Backup and Recovery
- SQL Server High Availability, Scalability and Reliability
- SQL Server Interoperability
- SQL Server Replication
- SQL Server Security
- SQL Server Stored Procedures
- SQL-Transact SQL (T-SQL)
-
Microsoft SQL Server Database Development (3) +
-
Microsoft SQL Server Management Issues (5) +
-
Microsoft SQL Server Platforms (4) +
-
SQL Server Business Intelligence (BI) and Data Warehousing (6) +
Featured Authors
Have a question for an expert?
Please add a title for your question
Get answers from your peers on your most technical SQL Server challenges.
Meet all of our SQL Server experts
View all SQL Server questions and answers
-
Jack Vaughan asks:
How will Microsoft's proposed purchase of GitHub affect your organization's use of GitHub or other software repositories?
-
Brien Posey asks:
What kind of benefits do you think Common Data Service for Analytics could provide to your organization's Power BI environment?
-
Robert Sheldon asks:
Does your organization plan to use Power BI Report Server for on-premises reporting? Why or why not?
Find Solutions For Your Project
-
Evaluate
CDS for Analytics brings Power BI, data sources together
Integrating data into Power BI for analysis can be a challenge, but Microsoft's Common Data Service for Analytics technology is designed to simplify the process for users.
-
Report Server platform puts Power BI reports on premises
-
The sky's the limit on scalability with Azure Cosmos DB
-
What's new on the SQL Server horizon for 2018?
-
-
Problem Solve
Master SQL DATEPART, GETDATE, DATENAME functions
SQL datetime functions DATEPART, GETDATE and DATENAME can retrieve the date and time or other individual parts of a value. Here's how to master these T-SQL tools.
-
Using DATEADD and DATEDIFF to calculate SQL datetime
-
How to migrate to Microsoft's Azure SQL Database PaaS
-
The difference between SQL Server and MySQL
-
-
Manage
SQL Server tools to aid in GDPR compliance efforts
The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database software to adhere to the EU's new data rules.
-
The road to improved SQL Server management starts here
-
Docker containers add flexibility to SQL Server systems
-
PASS Summit 2017 sees shifts as cloud efforts quicken
-
-
E-Handbook | March 2016
Shining a light on SQL Server storage tactics
Download -
E-Handbook | November 2014
Pricing out the new Windows Azure SQL Database
Download -
E-Handbook | April 2014
Developments in SQL Server BI point to focus on self-service, users
Download -
E-Handbook | May 2013
Understanding SQL Server virtualization
Download -
E-Handbook | May 2013
Understanding Microsoft SQL Server business intelligence options
Download
SQL Server Basics
-
Get Started
SQL Server in containers: Not such a bad idea now
Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers.
-
Get Started
Test your SQL Server technology IQ
From SQL Server Machine Learning Services to the SQL Server Operating System, there's a lot to know about SQL Server. Test your SQL Server knowledge with our quiz.
-
Get Started
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.
Multimedia
Vendor Resources
- Product Demonstration: Actifio SQL Data Protection –Product Demo
- Redefining SQL Server Data Management –White Paper
- Big Data A Big Problem? Where, When & Why To Use NoSQL –eBook
Blog: SQL Server with Mr. Denny
-
JSON documents in Azure and IF/THEN blocks
If you do any work in Azure you’ve probably done deployments using JSON scripts. Originally JSON in Azure didn’t support much, you could create objects, but if you put it in the JSON script, it would be created. Thank thankfully isn’t the case anymore. We now have conditions in...Continue Reading
-
Indexing in SQL Server is becoming more of an art form with each new version
Back in the old days of SQL Server 2012, we’d always tell people that creating indexes was half art and half science. And that’s true, but we’d create some non-clustered indexes (designed correctly of course), and the system would magically go faster. These days, in modern ...Continue Reading
-
More SQL Server with Mr. Denny Posts
Azure session taught in Germany in just a couple of weeks
How do I get High Availability in my Azure Storage Accounts?
How should I pass exams?
-
News
View All -
.NET Development for SQL Server
In GitHub play, Microsoft sets course for open source
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.
-
SQL Server Database Modeling and Design
Azure database provisioned for multimodel action
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.
-
Microsoft SQL Server Tools and Utilities
MongoDB on Azure gains in interest
Count ObjectRocket among those pursuing Azure MongoDB deployments. This open source NoSQL database continues to find traction on the web and in the cloud.