sys.database_files and sys.master_files (rather than sys.sysfiles)

Whenever there are changes, people can be slow to embrace them. One I’ve come across recently is that looking in sysfiles is no longer the best way of getting information about your database files. sys.database_files will tell you a lot more about them, and give you much nicer ways of filtering them. So for example, if you want a list of the log files for your database, try: select * from sys.database_files where type = 1 And sys.master_files will list them for the whole system. So it becomes really easy to look at the state of things from within T-SQL. … Continue reading sys.database_files and sys.master_files (rather than sys.sysfiles)

End of an era

I finish today in a job that I’ve had for over 4.5 years. It’s been an interesting time. During this time I’ve had time in hospital, seen both my kids have stints in hospital, seen my youngest start school, become an uncle four times over, reached my 30s, run a user-group, received the MVP award, had three trips to Redmond (with a fourth coming up soon), and of course, made many friends. But the new role is very exciting. It’s going to be great training for a living – I love training, and it’s going to be a lot of … Continue reading End of an era