2017-06-16
1,836 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
741 reads
SQL Server Cluster Automatic Memory Management
Don't waste memory in a cluster! Learn how to allocate memory between instances.
2017-04-06
982 reads
2017-01-30 (first published: 2017-01-26)
2,465 reads
Get Table Sizes and Percent of Database Size
This script uses two undocumented stored procedures that retrieve all tables in the database in which it is run and lists the data and index sizes, the sum of these sizes, and the table's size percentage of the entire database. The results are presented in descending order of the sum of the data and index […]
2004-11-24 (first published: 2004-10-25)
1,543 reads
Find Instances of a Column Name
This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run. This is sometimes helpful during upgrades, etc. There is no error checking in this script. You can modify it to add, if needed.Run this by simply […]
2004-06-21
150 reads
Blogs
The Data platform has evolved – so too must the DBA.
By HamishWatson
This blog post is around the changing landscape of both SQL Server and the...
What does the Machine Learning process look like?
By damianwidera
This is the second article in the Machine Learning area. I have explained a...
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract,...
Forums
Container Ports
Comments posted to this topic are about the item Container Ports
Receiving timeout errors on SQL2014
Similar to the one mentioned in the below article. We are sql server build...
Continue SQL Server transactional replication with AWS DMS
Hello, I have a task for which I wasn't able to find much information...
Ask SSC