SearchSQLServer
New & Notable
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.
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.
Get Started
Attaching SQL Server databases to custom containers
Deploying SQL Server in Docker containers for production applications typically requires custom containers. Here are guidelines on how to attach databases to them.
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 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
-
Michael Otey asks:
Is your organization using Docker containers to deploy SQL Server on Linux? Why or why not?
Find Solutions For Your Project
-
Evaluate
SQL Server maintenance plan options and insights
SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start.
-
CDS for Analytics brings Power BI, data sources together
-
Report Server platform puts Power BI reports on premises
-
The sky's the limit on scalability with Azure Cosmos DB
-
-
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
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
- 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
-
Database Maintenance and ColumnStore Indexes
Recently on Twitter I saw a question about what index maintenance you should be doing on your ColumnStore Indexes when it comes to maintenance. As I looked through DCAC’s blog posts I realized that none of us had blogged about this topic before. The reason for this is pretty basic, there’...Continue Reading
-
Why Profiler For Life?
I admit it, I still use SQL Profiler. I always have, and I will for the foreseeable future. My reasons are pretty simple. When it comes to troubleshooting I can spin up a Profiler session must faster than an Extended Events session. Usually, I’m troubleshooting something as a one-off. So ...Continue Reading
-
More SQL Server with Mr. Denny Posts
Get some behind the scenes information on PASS Summit Speaker Idol
PASS Summit Speaker Idol is here, and the window to submit is closing
Why has my Azure Load Balancer stopped working?
-
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.