SearchSQLServer
New & Notable
Problem Solve
Using DATEADD and DATEDIFF to calculate SQL datetime
DATEADD and DATEDIFF SQL functions allow you to easily perform calculations, like adding a time interval from a datetime value. Here's how to use those functions for that and more.
Evaluate
What SQL Server on Linux means for Microsoft
Expert Joey D'Antoni explains what SQL Server on Linux and the addition of some Enterprise Edition features to the database's Standard Edition say about the changing face of Microsoft.
Manage
Tips on optimizing virtualized SQL Server setups in Hyper-V
SQL Server is a CPU-intensive technology, which can make it tricky to run in a virtualized environment. Keep your SQL Server virtual machines running smoothly with these tips on using Hyper-V.
News
Some SQL Server Enterprise features show up as standard
Microsoft looks to broaden the horizons of SQL Server, as it moves some Enterprise features to Standard Edition and issues the first public preview of a release supporting SQL Server on Linux.
Download Our Exclusive Big Data Analytics Guide
An unbiased look at real-life analytics success stories, including a Time Warner Cable case study, and tips on how to evaluate big data tools. This guide will benefit BI and analytics pros, data scientists, business execs and project managers.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
Trending Topics
-
Availability and Scalability Evaluate
Solid-state technology on the rise for SQL Server storage
With recent improvements in solid-state drive technology, it's time to consider SSD devices for SQL Server storage uses. SSDs can address I/O performance problems, but wear is a worry.
-
Consolidation and Virtualization Manage
Tips on optimizing virtualized SQL Server setups in Hyper-V
SQL Server is a CPU-intensive technology, which can make it tricky to run in a virtualized environment. Keep your SQL Server virtual machines running smoothly with these tips on using Hyper-V.
-
Migration and Planning Problem Solve
How to migrate to Microsoft's Azure SQL Database PaaS
Microsoft Azure SQL Database compatibility problems disappeared in V12, clearing the path for a SQL database migration to the cloud. Here's how to make the move.
-
Data Visualization Manage
Maximizing the benefits of Excel add-ins: PowerPivot and Power View
This guide explores the capabilities of the Excel plug-ins PowerPivot and Power View, offering tips for accessing valuable business intelligence data.
-
Performance Tuning Manage
Extending SQL Server's buffer pool boosts I/O throughput
SQL Server 2014 includes the buffer pool extension feature, which can speed up query performance. Ashish Mehta explains the benefits of the feature and how to enable and disable it.
-
Tools and Utilities Evaluate
Top SQL Server deployment trends for 2017
Flash storage adoption, cloud computing's growth, Linux's increased importance and broader big data integration are a few trends that stand to affect SQL Server users this year.
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:
Which 2017 SQL Server development and deployment trend will impact your organization most?
-
Jessica Sirkin asks:
What do you think of Microsoft's embrace of open source technology in SQL Server on Linux?
Find Solutions For Your Project
-
Evaluate
Top SQL Server deployment trends for 2017
Flash storage adoption, cloud computing's growth, Linux's increased importance and broader big data integration are a few trends that stand to affect SQL Server users this year.
-
What SQL Server on Linux means for Microsoft
-
The difference between SQL Server and MySQL
-
Four free SQL Server tools every DBA can use
-
-
Problem Solve
Using DATEADD and DATEDIFF to calculate SQL datetime
DATEADD and DATEDIFF SQL functions allow you to easily perform calculations, like adding a time interval from a datetime value. Here's how to use those functions for that and more.
-
How to migrate to Microsoft's Azure SQL Database PaaS
-
Containerization is key to DH2i's new product, DxEnterprise
-
Four things to keep in mind for SQL Server 2014 migration
-
-
Manage
Tips on optimizing virtualized SQL Server setups in Hyper-V
SQL Server is a CPU-intensive technology, which can make it tricky to run in a virtualized environment. Keep your SQL Server virtual machines running smoothly with these tips on using Hyper-V.
-
Upgrade to SQL Server 2016 with installation wizard
-
Keep up with SQL Server licensing rules for 2016 release
-
Scoping feature adds new ways of configuring SQL Server
-
-
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 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.
-
Get Started
SQL (Structured Query Language)
SQL, short for Structured Query Language, is a programming language for relational databases. It lets users modify database structures and insert, update and query data.
-
Get Started
In-Memory OLTP
In-Memory OLTP is a Microsoft in-memory technology built into SQL Server and optimized for transaction processing applications.
Multimedia
Vendor Resources
Blog: SQL Server with Mr. Denny
-
Database Administration for the Non Database Administrator at SQL Bits
At SQL Bits this year I’ll be presenting my all day session Database Administration for the Non-DBA. This all day training day is a great session for those who work in shops where they have to function as the DBA, but their job isn’t to be the DBA (or someone who is brand new to...Continue Reading
-
Should I back up system databases on an Azure VM?
Well that really depends. When your database VM fails for some reason (either someone does something bad like delete the VM by accident, or a Windows patch doesn’t install correctly and the VM won’t start correctly, etc.) do you care about having your logins on the server, your jobs,...Continue Reading
-
More SQL Server with Mr. Denny Posts
SQL Server for the New or Non-dba – Nashville Edition Reminder
2016 By The Numbers
SQL Server for the New or Non-dba – Nashville Edition
-
News
View All -
SQL Server Database Modeling and Design
Some SQL Server Enterprise features show up as standard
Microsoft looks to broaden the horizons of SQL Server, as it moves some Enterprise features to Standard Edition and issues the first public preview of a release supporting SQL Server on Linux.
-
SQL Server Database Modeling and Design
Tools address Azure data pipeline needs
A link between Cask Data's CDAP application and integration environment and Azure HDInsight, Microsoft's Hadoop cloud service, is meant to cut development time on big data applications.
-
SQL Server Data Warehousing
U-SQL dives into Azure Data Lake Analytics
The big data movement has frozen out many data professionals who are versed in SQL. Microsoft's U-SQL programming language tries to get such folks back in the data querying game.
SearchSQLServer Definitions
- database normalization
- SQL (Structured Query Language)
- In-Memory OLTP
- Community Technology Preview (CTP)
- Microsoft SQL Server 2016
- data warehouse
- database management system (DBMS)
- Microsoft SSIS (SQL Server Integration Services)