The ABCs of Database Creation
Creating SQL Server databases is easier than the internet may lead us to believe.
2017-08-11 (first published: 2015-10-29)
8,414 reads
Brandie Tarvin
- Interests: Technology (of course), writing, and outdoor activities
Detective Stories - Tracking Down the Database's Dependents Part 2
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
2017-03-07
1,527 reads
Detective Stories - Tracking Down the Database's Dependents Part I
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.
2017-03-06
1,381 reads
Who Watches the Watchers?
Who checks on those who manage our systems? Is there auditing in place for those accidental DBAs?
2014-10-16 (first published: 2009-12-03)
323 reads
Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
2013-08-01
3,435 reads
Fun with ACID
What is ACID and why should we care? A look at the principal that drives all database and DB management software design: A.C.I.D.
2013-01-17
4,819 reads
SQL Server Resources - A list
A great list of SQL Server resources that you can use to help you improve your knowledge or ask questions.
2012-09-12
3,003 reads
Finding Unused Database Roles
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,421 reads
2011-05-13
3,287 reads
Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,097 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers