James Phillips is a Sr. Consultant with Pragmatic Works and has been working with SQL Server since version 6.5. James lives in Northwest New Jersey with his wife Amy and has 4 children: Hannah, Lillian, John and James Jr. He has spoken at several SQL Saturday events over the past few years and is the Leader of the PASS New Jersey SQL Server User group. His focus is mainly on SQL Server Performance as well as SSIS and SSAS technologies.

Back with a new focus

by jphillips-46546

Another SQL Geek

First let me say wow can’t believe that it has been almost 3 years since I have blogged. The last few years my career have been focused on transitioning...

2019-05-19

13 reads

SQL 2016 SSIS new feature AutoAdjustBufferSize

by jphillips-46546

Another SQL Geek

If you have not already seen in the What’s New in Integration Services list there is a new property for...

2016-07-21

1,662 reads

Use PowerShell to automate your Azure DB creation

by jphillips-46546

Another SQL Geek

Why create your databases manually if you don’t have to? If there is one thing that I hate to do...

2016-07-20

785 reads

Update to Date and Time Dimensions

by jphillips-46546

Another SQL Geek

Wanted to just post my latest versions of my Date and Time Dimension scripts. It has been a couple years...

2016-05-09

380 reads

Power BI Embedded is here

by jphillips-46546

Another SQL Geek

The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...

2016-04-05

561 reads

SQL Developer Edition is now free!!!

by jphillips-46546

Another SQL Geek

Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed...

2016-04-01

801 reads

Power BI Export Data

by jphillips-46546

Another SQL Geek

If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...

2016-01-22 (first published: 2016-01-13)

2,220 reads

Power BI and Google Analytics

by jphillips-46546

Another SQL Geek

One of the more underused features of Power BI is the Google Analytics data source. Working closely with marketers and...

2016-01-20

1,288 reads

Be an Expert not an Ehhpert!!!

by jphillips-46546

Another SQL Geek

As we embark on a new year I decided to take a look back at my career within I.T. trying...

2016-01-12 (first published: 2016-01-06)

2,234 reads

Viewpoints from CES 2016

by jphillips-46546

Another SQL Geek

While I never really enjoy a cross country flight back home my feet are very happy that I am finally...

2016-01-11

320 reads

Blogs

SQL Prompt Quick Access to Helper Code

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

As I have mentioned in prior blog posts, I have been writing a data...

Speaking at SQL Saturday Boston 2023

I’m happy to announce that I will be speaking at SQL Saturday Boston on...

Read the latest Blogs

Forums

Convert common Separated number to # table

@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...

Things to be considered before implementing database auditing

Hi All, As part of security compliance, we are told to audit DML &...

The Need for DevSecOps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Need for DevSecOps

Visit the forum

Question of the Day

A Reuseable Window

See possible answers