SearchSQLServer
New & Notable
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.
Evaluate
Azure SQL DW Gen2 closes cloud data warehouse speed gap
The Gen2 version of Azure SQL Data Warehouse gives Microsoft's cloud data warehouse a shot in the arm on performance, making it more competitive with rival technologies.
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.
News
Talend uploader moves data to Azure SQL Data Warehouse
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.
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
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 Get Started
How to avoid an expensive SQL cloud bill
Running SQL Server in the cloud can be expensive, but it doesn't have to be. These tips show you where wasteful spending happens and how to keep your database cloud bill low.
-
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
-
Jack Vaughan asks:
How will the additions of Hadoop and Spark to SQL Server be useful in your organization?
-
Robert Sheldon asks:
How do you think the Gen2 version of Azure SQL Data Warehouse stacks up against other cloud data warehouse services?
Find Solutions For Your Project
-
Evaluate
Azure SQL DW Gen2 closes cloud data warehouse speed gap
The Gen2 version of Azure SQL Data Warehouse gives Microsoft's cloud data warehouse a shot in the arm on performance, making it more competitive with rival technologies.
-
SQL Server maintenance plan options and insights
-
CDS for Analytics brings Power BI, data sources together
-
Report Server platform puts Power BI reports on premises
-
-
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
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.
-
High availability steps for SQL Server cloud systems
-
SQL Server tools to aid in GDPR compliance efforts
-
The road to improved SQL Server management starts here
-
-
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
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.
-
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.
-
Get Started
Get started with Microsoft's new SQL query tool
The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL queries across Linux, macOS and Windows.
Multimedia
Vendor Resources
- Time to Say Yes to NoSQL –White Paper
- 5 Reasons to Deploy SQL on New Servers –White Paper
- Beginning Performance Tuning –White Paper
Blog: SQL Server with Mr. Denny
-
What you should be doing to move into consulting
Making the jump from being an employee somewhere to being an independent consultant is a massive change for someone to make. And most of us that have made this jump have had to do it blindly trying to figure it out along the way. My goal of this post is to go through the business...
The ...Continue Reading
-
PASS Summit 2018 Speaker Idol Judges
It’s with great fanfare that I’m able to announce our PASS Summit 2018 Speaker Idol Judges. Our judges this year are folks we’ve had as judges before, and I’m thrilled that they’ve all agreed to be judges of all four speaker idol events. Our Judges this year are: Allan Hirt Joey D’Antoni Kendra ...Continue Reading
-
More SQL Server with Mr. Denny Posts
How do you setup Disaster Recovery for people?
PASS Summit 2018 PreCon Session is Selling Fast
Lots of announcements about #Azure and #SQLServer were made at Ignite today
-
News
View All -
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.
-
SQL Server Data Warehousing
Talend uploader moves data to Azure SQL Data Warehouse
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.
-
.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.