Manage SQL Server Agent History More Effectively
In this tip we look at how to build a custom approach to managing SQL Server Agent history data.
Computer Disruptions
I travel a fair amount for work to speak at various events around the world. Traveling can be quite a disruption to my life, and I do work to limit the amount of time that I'm gone. As my kids have gotten older, I'm have less commitments at home and an extra night during a […]
SQL Server System Audit Report
Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.
Deploying and Reverting Clones for Database Development and Testing
It can be quite a shock for developers to realize they can make radical changes to the data or schema, while testing, safe in the knowledge that it will take them only a few seconds to revert the database to its original state. Phil Factor demonstrates how it's done, using SQL Clone and PowerShell.
What happens when you cancel or kill a resumable index creation?
SQL Server 2019 adds resumable online index creation, and it’s pretty spiffy according to Brent.
Understanding Your Database
Steve notes that many of us might not completely understand every part of our database, but it's information that can be helpful in cleaning out unnecessary entities.
How to create and refresh development and test databases automatically, using SQL Clone and SQL Toolbelt
Phil Factor shows how a set of Redgate tools can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers. Before tearing down and rebuilding a database to a new version, we take care to save any DDL changes made to the existing copy.
SQL and NoSQL Database Features and Differences
In this tip we will talk about the features and main differences between SQL and NoSQL databases.
Configuring Azure SQL Databases Using Azure Resource Manager Templates
Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you explore an example of this approach.
You're not really that good at SQL Server
Steve reminds some people that there are reasons to continue to improve your skills.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Kepa Duri Tlpn/wa:085373737551
Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers