Review of Review of SQL Server 2000 Administrators' Companion
Nice write up on the Admin Companion. Should you add it to your bookshelf? Frank offers his frank opinion.
2004-03-26
4,123 reads
Frank Kalis
Script to display permissions in a db
The script creates a stored procedure which lists all permissions on a given db on execution. Unlike other scripts it does not use a cursor. I have chosen the sp_* prefix as I have created it in master. Have fun!
2004-02-27
500 reads
An Introduction to Database Models
Frank returns this week with a good non academic overview of the different types of database models and some of the features/problems that are native to each.
2004-02-12
9,918 reads
Codd's Rules
Frank gives us his take on Codd's Rules. If you're new to databases, this is the core theory that resulted in the development of RDBMS. If you're more experienced with databases, maybe now is a good time to return to the rules to see how you're doing!
2003-12-10
19,914 reads
A Brief History of SQL
Frank has been part of our community for a while now, posting more than 1000 times (wow!) in our discussion area. He's decided to contribute more of his time by putting together an article that discusses how SQL has evolved.
2003-09-10
9,277 reads
Blogs
Daily Coping 5 June 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing
I’m working on a project where it’s useful to automate environment setup and teardown...
SQL Server Authentication
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Forums
Reading XML Field from a Table
I have an xml field [Risultato] in a Table , the first record is...
SSIS and Source Control
Hello experts, I was hoping to get an idea of some common practices for...
Physical db changes stored in transaction log file?
Hello, I'm trying to understand what is needed to support a development team when...
Ask SSC