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,134 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
507 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
11,156 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
20,415 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
10,763 reads
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
why cant i get rid of extra dataset
hi i never used shared datasets before in ssrs. i created a dataset called...
Distinct values using string_agg
Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...
Refactoring a DELETE query using NOT EXISTS — need expert feedback
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...
Question of the Day
Importing Flat Files
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers