The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
Tuning the Performance of Backup Compression in SQL Server 2008
ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not
Boycott
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
Boycott
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
Boycott
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
From DBA to DBAA
Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.
Worst Practices - Not Using Primary Keys and Clustered Indexes
Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!
Scalability and Goal Testing for Developers
Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.
Blogs
5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
Dynamically Unpivot columns in SQL
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Friday Basics: RPO and RTO
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
Forums
Azure SQL how to grant ALTER DATABASE permission
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
SQL Server Encrypt data into a file, send it and then decrypt
First off, my apologies for what could potentially be a bad title! I am...
Question of the Day
Finding Marks
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers