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,315 reads
Creating SQL Server databases is easier than the internet may lead us to believe.
2017-08-11 (first published: 2015-10-29)
8,315 reads
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,387 reads
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,337 reads
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)
302 reads
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
2013-08-01
3,400 reads
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,744 reads
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
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,399 reads
2011-05-13
3,274 reads
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,076 reads
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Dears, I was told that I cannot access delta files in SQL Server Managed...
Comments posted to this topic are about the item Crazy Interviews
Comments posted to this topic are about the item The Query Traceflag