SQL Monitor Custom Metric: Table size (MB)
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.
Are DacPacs ready for prime-time?
DacPacs have been around for a while but DBAs have not, in the past, taken them particularly seriously. Is it time to get involved and influence the way the technology develops?
Changing SQL Server Database Logical Names
SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.
Presenting Data
One important skill is for the DBA or developer of the future is being sure they can present data to clients in a way they can use it.
Parallelize Data Flows with SSIS Balanced Data Distributor Transformation
In this article, Daniel Farina shows how to speed up SSIS package execution by using the Balanced Data Distributor Transformation.
Would You Pay To Wear Jeans?
For this Friday, Andy Warren asks if you would pay to change your wardrobe for work.
Azure SQL Database Security Features
The Microsoft Azure platform is evolving fast. Azure SQL Database is riding high on the cloud wave with new features enabled at a fast pace. In this article, Kun Cheng shares a few Azure SQL Database security features that could help developers and DBAs develop and manage a secure SQL Database solution.
Survey: What are your plans to upgrade SQL Server?
The Microsoft SQL Server product group are evaluating how to better assist with your SQL Server upgrades. With the upcoming SQL Server 2005 extended support deadline fast approaching, they want to understand how to help you migrate to a modern, supported version of SQL Server, and how to provide support and upgrades in future.
10 SQL Snippets For Faster, More Effective Code
How many hours per week do you spend writing the same SQL again and again?
Blogs
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers