Episode 191: Power BI Row-Level Security

If I were a betting man, I would wager your disk IO system is probably the biggest bottleneck in your SQL Server right now. Sure, there are lots of moving pieces, but if you can tame the IO situation...

23 Joulu 201528min

In what has to be one of the most downloaded SQL Server scripts on the planet with over 73,000 downloads, sp_whoisactive has been providing active session information to data professionals for eight y...

16 Joulu 201530min

As one of the newest Azure offerings, Azure Data Factory can at first thought be compared to SSIS.  I don't think we are quite there yet with the comparisons; however, I talk with MVP Reza Rad and dis...

9 Joulu 201531min

We all start somewhere and if you can find a mentor who will help you on your way by pointing you in a direction you had not considered, you are a lucky person indeed.  This episode I chat some fellow...

2 Joulu 201534min

A hard drive is a hard drive, right?  Storage has come a long way, but is probably still the biggest bottleneck in your system.  Solid State Drives (ssd) have changed the rules in terms of performance...

25 Marras 201534min

I learn stuff every day.  In this episode I tackle a new subject for me and one I am hearing a lot about--BIML.  BIML is a markup language you can use to build your SSIS packages.  I met up with Bill ...

18 Marras 201526min

Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered...

11 Marras 201525min

I learn things every day.  One of the great things about the SQL community is the willingness to share their learning experiences and today's episode is an example of this.  I chat with Mark Wilkinson...

4 Marras 201529min