SearchSQLServer
New & Notable
News
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.
Evaluate
CDS for Analytics brings Power BI, data sources together
Integrating data into Power BI for analysis can be a challenge, but Microsoft's Common Data Service for Analytics technology is designed to simplify the process for users.
Evaluate
Report Server platform puts Power BI reports on premises
Updates to Power BI Report Server expand the on-premises platform's reporting functionality and increase the number of data sources users can connect to when building Power BI reports.
News
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.
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 Evaluate
What's new on the SQL Server horizon for 2018?
Here's a list of notable trends related to SQL Server that IT teams should be ready for over the next 12 months. Among them: increased use of the cloud, AI, Linux and containers.
-
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 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.
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
-
Jack Vaughan asks:
How will Microsoft's proposed purchase of GitHub affect your organization's use of GitHub or other software repositories?
-
Brien Posey asks:
What kind of benefits do you think Common Data Service for Analytics could provide to your organization's Power BI environment?
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
SQL Server in containers: Not such a bad idea now
Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers.
-
Get Started
Test your SQL Server technology IQ
From SQL Server Machine Learning Services to the SQL Server Operating System, there's a lot to know about SQL Server. Test your SQL Server knowledge with our quiz.
-
Get Started
U-SQL
U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments.
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
-
Exchanging SQL Certificates with different service accounts can be tricky
Setting up Transparent Data Encryption, or Backup Encryption, or basically anything else where you need to restore a certificate to another SQL Server instance can get tricky as soon as you run the instances under different service accounts. The problem that people will usually run into is that...Continue Reading
-
Monday November 5th, 2018 Brings My PASS PreCon on Security
On Monday November 5th, 2018 I’m thrilled to say I’ll be presenting a precon at the PASS summit. This years precon will be on database security. The abstract from the PASS website: With increased focus on data breaches, security issues, and privacy laws, organizations are feeling ...Continue Reading
-
More SQL Server with Mr. Denny Posts
Welcome back, to the PASS Summit 2018 Speaker Idol competition
JSON documents in Azure and IF/THEN blocks
Indexing in SQL Server is becoming more of an art form with each new version
-
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.