Tabular query modes: DirectQuery vs In-Memory

When using the Tabular model in SSAS, the deployment options screen offers four choices for “Query Mode”: DirectQuery, DirectQuery with...

Determine Index Fragmentation in a SQL Server Database

Index fragmentation can adversely affect query response time. When accessing data through an index, SQL Server must read each page...

Login failed for [SQLSTATE 28000] (Error 18456) the step failed

AdvertisementsLogin failed for [SQLSTATE 28000] (Error 18456) the step failed
 
When you query the data from another SQL server (Linked server)...

Monday Morning Mistakes: Connecting to Wrong Environments

Today’s Monday Morning Mistake issue is another painfully common one that we all run into at some point. You’ve got...

Holiday

Sort of.
I’m off for a week to Camp Alexander near Pikes Peak for Boy Scout summer camp. My 13year old...

Colorado SQL - June 2012

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments.  There is no cost to attend...

Washington DC in the Summertime

As I mentioned in my post last week I was fortunate enough to visit Washington DC a week or so...

Failover consederations on Database Mirroring

These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring....

Shrink transaction log file

Sometimes the shrink transaction log file doesn't work.

Before we troubleshoot it, we need to know how the log file works:
Transaction...

Simple batch script to generate XMLA and deploy SSAS DB

Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized...