Book Review: Guru's Guide to T-SQL
This week, Brian Knight reviews the book Gurus Guide to Transact SQL.
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
Automatically Gathering Server Information Part 7
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Computer Problem Report Form
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
Keeping Your Developers Under Control
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Stuff Computer Support People Love
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
Using InterDev's Toolbox
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
Blogs
5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
Dynamically Unpivot columns in SQL
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Friday Basics: RPO and RTO
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
Forums
Azure SQL how to grant ALTER DATABASE permission
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
SQL Server Encrypt data into a file, send it and then decrypt
First off, my apologies for what could potentially be a bad title! I am...
Table partitioning best practice
I've inherited a couple of rather large databases from my ex-colleague when I join...
Question of the Day
Finding Marks
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers