Delayed Durability in SQL Server 2014
I describe the new SQL Server 2014 feature, Delayed Durability, and put it through its paces.
Monthly Archive: April 2014
Yes, you can install SQL Server 2014 Books Online locally
Update 2014-08-01: Below I mention that the T-SQL and XQuery references were not available locally with the initial release; they have now been provided (see this post for more details). I've seen people complain that...
SQL Server 2014 Cumulative Update #1 is Available
Microsoft has released Cumulative Update #1 for SQL Server 2014. KB Article: KB #2931693 114 fixes listed at time of publication (121 total) Build number is 12.0.2342 Relevant for @@VERSION 12.0.2000 through 12.0.2341 UPDATE...
April 2014 Cumulative Update for SQL Server 2008 R2 SP2
Microsoft has released Cumulative Update #12 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2938478 13 fixes listed at time of publication Build number is 10.50.4305 Relevant for @@VERSION 10.50.4000 through...
Use Extended Events to Get More Information About failed SQL Server Login Attempts
Tip : Use Extended Events to Get More Information About failed SQL Server Login Attempts
SQLintersection slides and samples
I share slides and samples from SQLintersection in Orlando
Enforce SQL Server Database Naming Conventions Using DDL Triggers
Tip : Enforce SQL Server Database Naming Conventions Using DDL Triggers
Handle conversion between time zones in SQL Server – part 3
Tip : Handle conversion between time zones in SQL Server – part 3