BIxPress 3.5–Now With More Awesome!

Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a...

What happens when a SSAS Tabular model exceeds memory?

If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...

SQL Server 2012 Certifications Revamped

Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...

SQLServerCentral.com Track Offered at 2012 SQL Server Connections in Las Vegas this Fall

As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...

How to restore the tail end of a transaction log

Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...

SQLSaturday #119 Chicago – In the Books

As I write this, I’m enjoying a margherita pizza and a Miller High Life in my room.  The SQLSaturday #119...

Is Dynamic T-SQL a Good Design Pattern?

In a recent discussion it was suggested to me that not only is dynamic T-SQL useful for things like catch-all...

Denali – Day 21: Security

Denali – Day 21: Security

 
Security wise Microsoft sql server is going great and on compare with other RDBMS in the market...

SSRS: FORMAT option for milliseconds

Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a...

MS SQL Server : Nested Transaction and Partial Rollback of Transaction

Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...