SearchSQLServer
New & Notable
Evaluate
An introduction to what's new in SQL Server 2019
SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality.
News
SQL Server 2019, cloud to be big topics at PASS Summit
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.
News
SQL Server 2019 adds Hadoop and Spark for big data jobs
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.
Manage
Exit strategies for end of SQL Server 2008 R2 support
The looming end of SQL Server 2008 extended support should spur database teams into action. Consider these four options to extend security updates or migrate your aging SQL Server systems.
Free Download: Machine Learning Meets Data Quality
Read an exclusive interview with Andrew Burt, chief privacy offer and legal engineer at Immuta Inc., on data governance and machine learning integration. Plus, uncover steps IT managers are taking to improve data quality in their big data environments in order to ensure analytics accuracy.
Trending Topics
-
Availability and Scalability Manage
High availability steps for SQL Server cloud systems
The cloud isn't immune to system failures. You can increase database uptime and prevent data losses with these high availability best practices for SQL Server in the cloud.
-
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 News
Azure SQL DB updates target its technical limitations
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.
-
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 Get Started
Get the most out of SQL Operations Studio
Microsoft's newest tool, SQL Operations Studio, provides DBAs with a free, lightweight option for managing SQL Server and Azure databases. Use these tips when trying it out.
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
-
Craig Stedman asks:
What kind of applications is your organization looking to move from on-premises SQL Server systems to Azure SQL Database in the cloud?
-
Brien Posey asks:
How will SQL Server 2019 benefit your company based on the new features it offers?
-
Craig Stedman asks:
What are the biggest issues that you're dealing with in your SQL Server environment?
Find Solutions For Your Project
-
Evaluate
An introduction to what's new in SQL Server 2019
SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality.
-
Azure SQL DW Gen2 closes cloud data warehouse speed gap
-
SQL Server maintenance plan options and insights
-
CDS for Analytics brings Power BI, data sources together
-
-
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 2019, cloud to be big topics at PASS Summit
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.
-
Exit strategies for end of SQL Server 2008 R2 support
-
High availability steps for SQL Server cloud systems
-
SQL Server tools to aid in GDPR compliance efforts
-
-
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
Azure SQL DB updates target its technical limitations
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.
-
Get Started
SQL Operations Studio
SQL Operations Studio is a free Microsoft tool that can be used to manage SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems.
-
Get Started
Attaching databases to SQL Server on Linux containers
SQL Server files can be stored outside of Docker containers in host directories or volumes. Here's how to set up SQL Server on Linux databases and attach them to containers.
Multimedia
Vendor Resources
- How Your Data Type Choices Can Affect SQL Server Database Performance –White Paper
- Time to Say Yes to NoSQL –White Paper
- 5 Reasons to Deploy SQL on New Servers –White Paper
Blog: SQL Server with Mr. Denny
-
Thoughts on Microsoft Ignite and the PASS Summit being on the same week
Having the PASS Summit 2019 and Microsoft Ignite both on the same week will be a very interesting problem, to say the least. From an attendee perspective, there isn’t a lot of crossover between the two conferences. Some people are able to attend both events, but for the most part, there is going...Continue Reading
-
Is Azure SQL Database Managed Instance the Right Solution?
Maybe. Is the software that you’re trying to move to Microsoft’s Azure require the use of a SQL Server instance so that you can create jobs, logins, and do Things like cross-server queries? Are you trying to avoid adding more Virtual Machines (VMs) to be managed in your environment (and a SQL ...Continue Reading
-
More SQL Server with Mr. Denny Posts
View All Blog Posts
-
News
View All -
SQL Server Migration Strategies and Planning
Azure SQL DB updates target its technical limitations
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.
-
Microsoft SQL Server Installation
SQL Server 2019, cloud to be big topics at PASS Summit
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.
-
SQL Server Data Warehousing
SQL Server 2019 adds Hadoop and Spark for big data jobs
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.