If you happen to be in Canada, you probably have heard about Microsoft TechDays – the premier technical conference for IT professionals and developers. This year, three cities – Vancouver, Montreal and Toronto – will be hosting this 2-day event. Two years ago, I did a presentation “on SQL Server on Hyper-V” as well as […]
I’ve you’ve missed watching the webcasts, the recordings are now available online. You do have to log in using your PASS website credentials so if you haven’t registered yet, this is a good time to do so.
Back in 2009, I wrote an article about how to generate SQL scripts using Windows PowerShell and Server Management Objects (SMO) using the Script() method. One thing that you need to consider when using the Script() method is making sure that you have taken into account all of the database objects as well as their […]
I’m a big fan of standards specially when you know that they work. It’s like knowing that when when you’re measuring some length in the US, you know the unit would likely be in inches or feet because it is a standard unit of measurement. I was installing SQL Server “Denali” on my test environment […]
I just found out recently that SQL Server 2008 R2 Service Pack 1 has been released. Microsoft KB article 2528583 lists all of the bugs that are fixed by the service pack. SQL Server MVP Aaron Bertrand blogged a few months back about the features that were added to the database engine. Hopefully, after installing […]