SearchSQLServer
New & Notable
Problem Solve
Tips for DBAs on how to prevent SQL Server deadlocks
Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring.
Manage
Tips to help you ace your next SQL Server database audit
Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the top questions that auditors ask.
News
Talend's Stitch buy leads to Azure loader for masses
Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it recently bought, reflects the trend.
Evaluate
What 2019 holds in store for SQL Server users
SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users.
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 Evaluate
What 2019 holds in store for SQL Server users
SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users.
-
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 Problem Solve
Tips for DBAs on how to prevent SQL Server deadlocks
Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring.
-
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
-
Lindsay Moore asks:
How has using audit triggers in SQL Server benefitted your organization? Have there been any drawbacks?
Find Solutions For Your Project
-
Evaluate
The ins and outs of using audit triggers in SQL Server
Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases.
-
What 2019 holds in store for SQL Server users
-
Learn what SQL Server 2019 has to offer
-
An introduction to what's new in SQL Server 2019
-
-
Problem Solve
Tips for DBAs on how to prevent SQL Server deadlocks
Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring.
-
Master SQL DATEPART, GETDATE, DATENAME functions
-
Using DATEADD and DATEDIFF to calculate SQL datetime
-
How to migrate to Microsoft's Azure SQL Database PaaS
-
-
Manage
database management system (DBMS)
If the database is a file of information, then the DBMS is the file folders, the file labels and the file cabinet.
-
Tips to help you ace your next SQL Server database audit
-
Answers to five FAQs on using SQL Server in containers
-
Four ways to secure your SQL Server database
-
-
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
database management system (DBMS)
If the database is a file of information, then the DBMS is the file folders, the file labels and the file cabinet.
-
Get Started
data mining
Data mining is the process of sorting through large data sets to identify patterns and establish relationships to solve problems through data analysis.
-
Get Started
database (DB)
A database is a collection of information that is organized so that it can be easily accessed, managed and updated.
Multimedia
Vendor Resources
Blog: SQL Server with Mr. Denny
-
Servers running too slow, just add all the cores!
Recently Intel announced some major upgrades to their Xeon CPU line. The long and short of the CPU announcement was that Intel was releasing their 56 Core CPUs for public release. That’s just a massive amount of CPU power that’s available in a very small package. A dual socket server...Continue Reading
-
If It Requires A Change Control Ticket To Change It, It Should Be In The Change Control System
I’ve seen a couple of conversations recently about companies that want to be able to script out their database schema on a daily basis so that they have a current copy of the database; or systems that have to change permissions with the database frequently, and they need to export a copy ...Continue Reading
-
More SQL Server with Mr. Denny Posts
Azure NVMe Storage and Redundancy
Another Year Gone, Another Year as a VMware vExpert
I thought my days of Linux were over
-
News
View All -
SQL Server Data Warehousing
Talend's Stitch buy leads to Azure loader for masses
Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it recently bought, reflects the trend.
-
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.