SQL Server 2012 Training Annoucement
I am please to announce the first of my SQL Server 2012 training classes being held March 19-22 at the Microsoft office in Los Angeles, California. This isn’t a short class, but a 4 day training class which will cover installation, manageability, security, high availability as well as the new and improved BI features. All […]
When learning database design, be careful where you learn from
Every year we have new people joining our ranks as database professionals. Many of these new people use systems at the places which they already work as the source of their learning when it comes to database design and data modeling. However this isn’t always the best idea unless the systems which they are referencing […]
Using CNAMEs with clustered file share resources
One of the questions that I see on the forums every once in a while is how to get a CNAME working with a network share. For example if you have a cluster where the server names are “SERVER1 and SERVER2” and the virtual name is “VIRT1” how can I allow users to connect to […]
Always set the SEQUENCE cache size
One of the really cool features of the new SEQUENCES which were introduced in SQL Server 2012 is that you can specify the size of the cache used for each sequence. However Microsoft is recommending that when creating sequences you should always specify the cache size of the sequence. This is because Microsoft has stated […]