SearchSQLServer
New & Notable
News
SQL Server, Azure users try to keep up with updates
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.
News
Microsoft DBMS updates in spotlight at PASS Summit 2018
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.
Get Started
Answers to five FAQs on using SQL Server in containers
Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them.
Get Started
The ins and outs of PowerShell for Power BI
DBAs can manage Power BI data sets, workspaces and reports with PowerShell. Using the two tools together makes for a more efficient and effective workflow.
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
SQL Server, Azure users try to keep up with updates
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.
-
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:
Does your organization plan to move on-premises SQL Server applications to the Azure cloud? Why or why not?
Find Solutions For Your Project
-
Evaluate
Learn what SQL Server 2019 has to offer
The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved Linux and container support.
-
An introduction to what's new in SQL Server 2019
-
Azure SQL DW Gen2 closes cloud data warehouse speed gap
-
SQL Server maintenance plan options and insights
-
-
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
Answers to five FAQs on using SQL Server in containers
Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them.
-
Four ways to secure your SQL Server database
-
SQL Server 2019, cloud to be big topics at PASS Summit
-
Exit strategies for end of SQL Server 2008 R2 support
-
-
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
Answers to five FAQs on using SQL Server in containers
Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them.
-
Get Started
The ins and outs of PowerShell for Power BI
DBAs can manage Power BI data sets, workspaces and reports with PowerShell. Using the two tools together makes for a more efficient and effective workflow.
-
Get Started
Azure Data Studio (formerly SQL Operations Studio)
Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems.
Multimedia
Vendor Resources
Blog: SQL Server with Mr. Denny
-
View a website, make a donation
Tis the season and Denny Cherry & Associates Consulting has a quick way for you to make a difference. All you have to do, is click through to our donation webpage, and that’s it. For clicking through, DCAC will donate $1 to Elizabeth Glaser Pediatric AIDS Foundation. Every dollar ...Continue Reading
-
IO Performance in Windows 2016
If you’re using Windows 2016 in, its default config you may not get getting the IO performance that you were expecting. If you try a Windows 2012 server, the problem magically goes away. The question is why. The answer is shockingly straightforward, Windows 2016 ships with Windows Defender...Continue Reading
-
More SQL Server with Mr. Denny Posts
Moving VMs in Azure with Managed Disks Between Resource Groups
Who should own your SQL Agent jobs?
Think a Kubernetes Cluster is to Expensive to Build?
-
News
View All -
SQL Server Migration Strategies and Planning
SQL Server, Azure users try to keep up with updates
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.
-
SQL Server Business Intelligence Strategies
Microsoft takes new steps on Power BI enterprise plan
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.
-
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.