Using SQL Server Query Store & Plan Guides to Fix Problem Queries
This webinar will cover how to use SQL Server plan guides and the query store to fix problematic queries and ways to improve query performance.
2020-07-14
SQL Server
Setting up Management Studio for remote SQL Server
Learn how to configure SQL Server and Windows to allow others to connect to an instance remotely.
2020-01-06
19,318 reads
Update only Year, Month or Day in a SQL Server Date
In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.
2019-12-17
A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
209 reads
Getting Started with SQL Server on Google Cloud Platform
Learn how you can create a SQL Server instance in the Google Cloud Platform.
2019-09-26
2,766 reads
2019-09-14
233 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
207 reads
Are your CPU-intensive queries running slowly? Check your VM type.
When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting. Brent Ozar explains when to stop and check the VM type you used when building this VM.
2019-05-24
1,077 reads
Introduction to SQL Server Security — Part 5
SQL Server contains many built-in views and functions that can be used to understand what is going on “under the hood,” and security is no exception. In this article, Robert Sheldon explains the security related catalogue views, dynamic management views, and system functions.
2019-05-20
Compressed Microsoft SQL Server Backups by Default
Learn how to create default database compression for your SQL Server databases.
2019-04-30
Blogs
Daily Coping 26 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Greatest and Least TSQL
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
T-SQL Tuesday Retrospective #005: Reporting
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....
Forums
Large Database Files
Comments posted to this topic are about the item Large Database Files
Black Friday Wishes
Comments posted to this topic are about the item Black Friday Wishes
Reporting Services Subscription: Special character in email address
Hi How can an email address containing a special character (in this case, an...
Ask SSC