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)
7,913 reads
Brandie Tarvin
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,024 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,285 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)
298 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,331 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,548 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,354 reads
2011-05-13
3,269 reads
Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,031 reads
Blogs
SQL Server Sample Databases
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Using WAITFOR to Test Slow Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Power BI Monthly Digest – May 2020
By Devin-Knight
This month we will likely have two releases of the Power BI Desktop. In...
Forums
The Challenges of Working Under Quarantine
Comments posted to this topic are about the item The Challenges of Working Under...
Upgrade SQL 2008R2 Cluster to SQL 2017
Hi, I've been asked to develop an implementation plan for upgrading a SQL 2008R2...
The Basics of Using a Sequence as a Table Default
Comments posted to this topic are about the item The Basics of Using a...
Ask SSC