Power BI Q&A Preview Now Live On Your Data

With the recent updates to the Power BI preview and Q&A features added I thought I would do a quick...

Speaking in 2014

I love that I get to travel around and learn from my #sqlfamily. We’re still filling in the majority of...

Parameterization – A quick note on a CSS SQL article

I just finished reading an excellent CSS article, How Simple Parameterization works, which is well written and well worth a...

SQL Server 2012 ???? ??????? ????? ??

??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2012....

SQL Server monitoring and optimization

To optimize the performance of your database, you need to monitor and tune. You determine the performance baseline, how SQL...

Popular DBCC's And Our Third Winner Of The Month!: Day 8

Winner Announcement!

The third winner of this month is Annapu Reddy Gayathri! I've seen a nice increase of participants so far. I...

Powershell in a Month– Day 4 and 5 – Providers

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...

SQL Server 2008 R2 Service Pack 2 Cumulative Update 10

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 10, which is build 10.50.4297. This Cumulative Update...

SQL Server Diagnostic Information Queries for December 2013

I have made quite a few updates and improvements to this set of queries for December 2013. I have added...

Exploring Excel 2013 for BI Tip #13: Connecting Slicers in Pivot Tables Sourced from a Power Pivot Model

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...