Control OneLake with Storage Explorer – Data Engineering with Fabric
In this new article, we examine how to work with OneLake storage.
In this new article, we examine how to work with OneLake storage.
Learn how to remove TDE from a database and return it to a normal state.
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you’re using it for backups, there are two quick, easy changes that can dramatically reduce your nightly job runtimes.
Learn how to effectively rename columns in SQL Server using our comprehensive guide. Explore the use of sp_rename, limitations, and best practices
There's a survey available to give your input for what topics you'd like to learn about at the next SQL Saturday.
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, it often finds its way into SQL Server databases and needs to be managed alongside other data types.
There are lots of companies moving databases to the cloud. Steve has a few thoughts on how to evaluate this for your company.
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers