SearchSQLServer
New & Notable
Evaluate
Microsoft's 3 options for SQL Server in the Azure cloud
SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure.
Manage
How LEFT and RIGHT OUTER JOINS differ in SQL statements
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs.
Evaluate
DevOps teams mix SQL Server DBAs, developers, others
DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos with cross-functional teams.
Manage
SQL Server auditing features for tracking database use
SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database activities easier for database administrators.
Free Guide: DBMS Features Overview for 3 New Popular Options
IT expert Michael Otey, explores 5 trends for SQL Server environments, what to expect in SQL Server 2019 and why it might be time to update SQL Server skills. Also, compare the key features of Google Cloud Spanner and Oracle Database 19c.
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 Manage
How LEFT and RIGHT OUTER JOINS differ in SQL statements
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs.
-
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
-
Margaret Rouse asks:
How do you think data normalization is best applied today, as per-bit disk drive prices decline and new storage technologies come online?
Find Solutions For Your Project
-
Evaluate
Microsoft's 3 options for SQL Server in the Azure cloud
SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure.
-
DevOps teams mix SQL Server DBAs, developers, others
-
Weighing SQL Server vs. MySQL relational databases
-
The ins and outs of using audit triggers in SQL Server
-
-
Problem Solve
How LEFT and RIGHT OUTER JOINS differ in SQL statements
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs.
-
Tips for DBAs on how to prevent SQL Server deadlocks
-
Master SQL DATEPART, GETDATE, DATENAME functions
-
Using DATEADD and DATEDIFF to calculate SQL datetime
-
-
Manage
SQL Server auditing features for tracking database use
SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database activities easier for database administrators.
-
database management system (DBMS)
-
Tips on performance tuning in SQL Server systems
-
Tips to help you ace your next SQL Server database audit
-
-
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 administrator (DBA)
A database administrator (DBA) is the information technician responsible for directing or performing all activities related to maintaining a successful database environment.
-
Get Started
FileMaker (FMP)
FileMaker is a relational database application in which an individual may design -- and easily share on the Internet -- a database file by starting with a blank document or implementing ready-made and customizable templates.
-
Get Started
database normalization
Database normalization is intrinsic to most relational database schemes. It is a process that organizes data into tables so that results are always unambiguous.
Multimedia
Vendor Resources
- Altoros Technical NoSQL Comparison Report –White Paper
- The Forrester Wave™: Big Data NoSQL, Q1 2019 –Research Content
- Altoros Database Query Comparative Analysis –White Paper
Blog: SQL Server with Mr. Denny
-
Our EGPAF Click to Donate Campaign has wrapped up for 2019
Over the month of December (from the 1st through the 24th) we had a donation program set up with the Elizabeth Glaser Pediatric AIDS Foundation. To help us, all you had to do, was to click through to the page that we set up for the donation program. This simple act would cause a $1...
-
Dynamically Assigning an Availability Set to a VM in an ARM Template
Recently I was creating an ARM template for a client. The idea for the ARM template was that we were going to create two VMs, and it would also create an Availability Set and assign the VMs to the Availability Set. So that’s no problem. We then got a request to also create an ARM...
...Continue Reading -
More SQL Server with Mr. Denny Posts
Another Day, Another Ransomware Attack
Microsoft wants bugs found in SQL Server and reported to Microsoft
DCAC Supporting Elizabeth Glaser Pediatric AIDS Foundation (@egpaf) #WorldAIDSDay – Redux
-
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.