Blog Posts

Basic User Functions in R

• by Steve Jones

• The Voice of the DBA

As I’ve been learning more about the data platform, I’ve been exposed to some R language code. This makes sense, as more comprehensive data analysis needs something other than...

2019-06-26

9 reads

Leadership Part 2: Talent acquisition and Employee Retention

• by jphillips-46546

• Another SQL Geek

The two most costly human capital expenses an organization will have is the onboarding and offboarding of staff. Just take a moment to think about that and if your...

2019-06-26 (first published: 2019-06-12)

231 reads

Query machine name of the sql server instance - the hard or the harder way

• by SQLPals

• Mission: SQL Homeostasis

I was at a client where they are using non-Microsoft clustering technology to achieve the high availability of SQL Server instances....

2019-06-26 (first published: 2019-06-13)

732 reads

SQL Server 2008 and 2008 R2 is end of life on 9 July 2019

• by Randolph West

• Born SQL with Randolph West

Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You...

2019-06-26

Understanding Columnstore Indexes in SQL Server Part 1

• by Monica Rathbun

• SQLEspresso

Recently I reviewed filtered indexes, this time let’s look at columnstore indexes. These indexes are very useful for data warehouse workloads and large tables. They can improve query performance...

2019-06-26

8 reads

Database File Changes

• by Jason Brimhall

• SQL RNNR

Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...

2019-06-25

6 reads

From Evangelist to Advocate

• by Grant Fritchey

• The Scary DBA

It’s time for a little bit of change to occur. I am no longer a Product Evangelist for Redgate Software. No, they haven’t fired me and I haven’t quit....

2019-06-25

10 reads

Joker’s Wild

• by Bert Wagner

• Bert Wagner

This past weekend I had a blast presenting Joker’s Wild with Erin Stellato (blog|twitter), Andy Mallon (blog|twitter), and Drew Furgiuele (blog|twitter). Watch it here! Table of contents: What is...

2019-06-25 (first published: 2019-06-11)

358 reads

Multiple Identity Inserts

• by Bert Wagner

• Bert Wagner

Watch this week’s video on YouTube. This week I want to share something that surprised me about using SQL Server’s SET IDENTITY_INSERT statement. I started with two tables with...

2019-06-25

4 reads

Setting Up Power BI Row Level Security

• by Devin-Knight

• Devin Knight

In this webinar I discussed designing a Power BI model to plan for either a simple or complex row level security scenario.

2019-06-25

15 reads