SQLSaturday #262 : Boston
Today I gave my T-SQL : Bad Habits & Best Practices session at SQLSaturday #262 at Microsoft in Cambridge. Fun event with a lot of friendly faces. A few mishaps along the way: had...
Monthly Archive: March 2014
Making the Case for INSTEAD OF Triggers – Part 1
I perform some deeper testing on triggers, showing that INSTEAD OF triggers are worth a look.
Validate the contents of large dynamic SQL strings in SQL Server
Tip : Validate the contents of large dynamic SQL strings in SQL Server
SQL Server 2012 Service Pack 1 Cumulative Update #9 is available!
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #9. KB Article: KB #2931078 Build # is 11.0.3412 Currently there are 29 public fixes listed (33 total) Relevant for builds 11.0.3000...
March 2014 Cumulative Update for SQL Server 2008 SP3
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #16 Build # 10.00.5852 KB Article: KB #2936421 2 public fixes Relevant for builds 10.00.5500 -> 10.00.5851 NOT for SQL Server 2008 R2...
Some great news for Standard Edition customers in SQL Server 2014
I talk about SQL Server 2014 Standard Edition and a couple of little carrots that might make this upgrade more compelling than SQL Server 2012.
Handle conversion between time zones in SQL Server – part 2
Tip : Handle conversion between time zones in SQL Server – part 2
Handle conversion between time zones in SQL Server – part 1
Tip : Handle conversion between time zones in SQL Server – part 1