Move a SQL Server Table to a New Filegroup
Discover the steps to move a SQL Server table to a new filegroup, including handling clustered and non-clustered indexes.
Burt King is an independent SQL Server consultant from Boston, Massachusetts. He has worked with SQL Server since 1997 and supported every version since SQL 6.5. Burt's favorite projects are related to clustering, availability groups and performance tuning.
SQL Partition By Examples for Aggregating Data
Learn the advantages of SQL partition by to achieve segmented data aggregation beyond GROUP BY limitations.
SQL Server CREATE, ALTER, DROP Resource Guide
This T-SQL reference guide includes examples of how to Create, Alter and Drop SQL Server objects along with many code examples.
SQL Server Temporal Tables Quick Start Guide
Learn about SQL Server Temporal Tables, what they are, how they can be used and how to manage temporal tables.
How to Check Who Created the Table in SQL Server
In this article, learn how in SQL Server to check who created, altered or deleted a table or other database objects.
How to Remove Constraints from a SQL Server Table
In this article, learn how to remove constraints from a SQL Server Table including primary keys, foreign keys, check constraints, and more.
How to Backup a SQL Server Database using SSMS
In this tip, we walk through the steps of how to backup a SQL Server database using SQL Server Management Studio.
Encrypting passwords for use with Python and SQL Server
In this tip we look at how to secure and encrypt passwords used between Python and SQL Server.
SQL Server managed backups to Azure
Read this tip to learn how to create unencrypted and encrypted managed SQL Server backups to Azure.
Using SQL Server Managed Lock Priority for Online Index Rebuilds
Learn about SQL Server 2014 Managed Lock Priority available in the Enterprise edition to help alleviate blocking during index operations on busy 24x7 OLTP servers.
SQL Server Database Snapshots for Data Comparison
I want to be able to update my application and have the SQL Server data from before the upgrade available as a reference after the upgrade in case there is a problem. Copying the data to another server is prohibitive because of the size. Also, the backup
SQL Server Clustering Myths
Recently a group of developers were looking for high availability solutions with SQL Server and ran into some problems because they believed some common myths regarding SQL Server and clustering. In this tip we'll look at some of these myths and correct t
Verify SQL Server Stored Procedures are the same on multiple servers
I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check
Standardize SQL Server backups and maintain existing job schedules
After starting a new SQL Server DBA position I discovered that our servers, and there were hundreds, all had backups running, but they were all different. Some had backups to local storage, some across the network or to the SAN, and the list went on and o