A Script A Day - Day 16 - Database Restore
Today’s script is one I have used more times that I care to remember. As a DBA database backups and...
2012-02-22
672 reads
SQL Server 365
A Script A Day - Day 15 - Untrusted Check Constraints
Today’s script comes about because of a recent discussion about check constraints. The discussion was about the use of WITH...
2012-02-22
1,019 reads
A Script A Day - Day 14 - Upgrading to SQL 2012
Today’s script is one I have used to test one possible upgrade method from SQL Server 2008 to SQL Server...
2012-02-21
969 reads
A Script A Day - Day 13 - Chris' Top Tip - Batches
Today’s post is pretty cool. So you have been reading up about something on the World Wide Web or you...
2012-02-21
462 reads
A Script A Day - Day 12 - Granting Role Membership to All Principals
Today's script will grant membership in the db_owner fixed database role in all online read/writable user databases to all principals not...
2012-02-20
894 reads
A Script A Day - Day 11 - User Permissions By Database
Today's script will return you permissions granted to a user for every online database. The script uses EXECUTE AS so...
2012-02-20
1,090 reads
Sorry...
I've been offline for a week to take some annual leave and recharge my batteries. To make up for the...
2012-02-20
462 reads
A Script A Day - Day 10 - Hosts on vCentre
If you use VMWare for your virtualisation environment all virtual machines are managed by one or more vCentre management servers. ...
2012-02-10
702 reads
A Script A Day - Day 9 - Index Compression Estimations
Today's script provides amongst other information Index compression estimates based on existing index information. All you need to do is...
2012-02-09
1,307 reads
A Script A Day - Day 8 - Non Clustered Index Information
Today's script comes to you from London where I am at my head office for my appraisal! Lets hope it...
2012-02-08
443 reads
Blogs
Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide
C++ is a highly versatile language for developing console applications, batch processing, and performance-critical...
Easily query your GitHub Contribution activity
By Will Assaf
For a variety of reasons, including your Microsoft MVP activity reports, you might want...
Comparing Microsoft Fabric Alternatives in AWS, GCP, and OCI in 2025
By Daniel Janik
Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering...
Forums
SQL Automate - A DBA's Time-Saving Toolkit
Comments posted to this topic are about the item SQL Automate - A DBA's...
Reflecting on the Mythical Man Month
Comments posted to this topic are about the item Reflecting on the Mythical Man...
Updating a Data API Builder Connection String
Comments posted to this topic are about the item Updating a Data API Builder...
Question of the Day
Updating a Data API Builder Connection String
Can I use dab update to update a connection string in my Data API Builder configuration file?
See possible answers