-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Another SQL Geek

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.

SQL 2016 SSIS new feature AutoAdjustBufferSize

If you have not already seen in the What’s New in Integration Services list there is a new property for Data Flows that is called AutoAdjustBufferSize.  Why is this important and what does it actually do?

First, let’s remember that in SQL 2014 we had a max DefaultBuffersize of… Read more

0 comments, 835 reads

Posted in Another SQL Geek on 21 July 2016

Use PowerShell to automate your Azure DB creation

Why create your databases manually if you don’t have to?  If there is one thing that I hate to do it is extra work when it’s not needed.  With the magic of PowerShell and Azure PowerShell modules you can easily automate the creation of your Azure Database.  You can download… Read more

0 comments, 496 reads

Posted in Another SQL Geek on 20 July 2016

Update to Date and Time Dimensions

Wanted to just post my latest versions of my Date and Time Dimension scripts.  It has been a couple years since I last posted my scripts and they are updated for some additional industries that I have come across.  Feel free to use and share and always appreciate feedback.

Download… Read more

0 comments, 282 reads

Posted in Another SQL Geek on 9 May 2016

Power BI Embedded is here

The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone building an application to embed the power of Power BI into their application.  I have been hearing about this feature for almost a year now since starting at HIMMS 2016… Read more

0 comments, 429 reads

Posted in Another SQL Geek on 5 April 2016

SQL Developer Edition is now free!!!

Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed up for Visual Studio Dev Essentials.  Even if you just call yourself a database guy/gal I highly recommend signing up here.  In the past the only way to get… Read more

0 comments, 658 reads

Posted in Another SQL Geek on 1 April 2016

Power BI and Google Analytics

One of the more underused features of Power BI is the Google Analytics data source.  Working closely with marketers and agencies I continue to see them struggle with getting and reporting on their data from Google Analytics and it should not be that difficult.   With Power BI or even with… Read more

0 comments, 1,063 reads

Posted in Another SQL Geek on 20 January 2016

Power BI Export Data

If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is now here.  You can now export the data that is behind a visual and this will close a huge gap for Power BI when compared to many of it’s… Read more

2 comments, 1,923 reads

Posted in Another SQL Geek on 13 January 2016

Viewpoints from CES 2016

While I never really enjoy a cross country flight back home my feet are very happy that I am finally sitting down for a few hours.  CES 2016 was once again another great year and has proven to me again why it’s a must attend conference that spans across many… Read more

0 comments, 251 reads

Posted in Another SQL Geek on 11 January 2016

Be an Expert not an Ehhpert!!!

As we embark on a new year I decided to take a look back at my career within I.T. trying to figure out what was the turning point.  When did it go from a job to a career?  What advice could I give to others?  After thinking about this for… Read more

7 comments, 2,094 reads

Posted in Another SQL Geek on 6 January 2016

Is Data Visualization still just a buzzword?

If asked this question two years ago, my answer would have been a resounding “Yes.” At that time, the focus was on displaying data using visualizations that were pleasing to the eye to help make a sale, impress the “C” levels, and to put a check mark in the box… Read more

0 comments, 401 reads

Posted in Another SQL Geek on 5 January 2016

SQL Saturday NYC Update #4

SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th.  Before I announce what they are I wanted to first say thank you to everyone who submitted it certainly made making a choice very difficult.

 

Precon #1:  Bradley Ball will… Read more

0 comments, 652 reads

Posted in Another SQL Geek on 21 February 2015

SQL Saturday NYC Update #4

SQL Saturday NYC is going full steam ahead and we have finalized our 2 Precons for Friday May 29th.  Before I announce what they are I wanted to first say thank you to everyone who submitted it certainly made making a choice very difficult.

 

Precon #1:  Bradley Ball will… Read more

0 comments, 179 reads

Posted in Another SQL Geek on 21 February 2015

SQL Saturday NYC Update #3

SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2 of them are on Friday May 29th and we have had many submissions so far.  We are taking submissions until 1/15/2015 so just under a week left to email them… Read more

0 comments, 177 reads

Posted in Another SQL Geek on 20 February 2015

SQL Saturday NYC Update #3

SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2 of them are on Friday May 29th and we have had many submissions so far.  We are taking submissions until 1/15/2015 so just under a week left to email them… Read more

0 comments, 383 reads

Posted in Another SQL Geek on 9 January 2015

Table Variables, CTE and Temp Tables. Which one should I use?

There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE) and Temp Tables and here are a few.

However once you know the differences… Read more

1 comments, 974 reads

Posted in Another SQL Geek on 5 January 2015

Table Variables, CTE and Temp Tables. Which one should I use?

There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE) and Temp Tables and here are a few.

However once you know the differences… Read more

1 comments, 217 reads

Posted in Another SQL Geek on 5 January 2015

SQL Saturday NYC Update #2

Just over 2 weeks now since SQL Saturday NYC went live and planning is in full force.  An update on numbers is now 65 people are registered to attend and if you haven’t already make sure you get your spot.  We just got our newest sponsor and first Silver… Read more

0 comments, 246 reads

Posted in Another SQL Geek on 10 December 2014

How Functions function

If you are going to use functions first you should understand how functions work as they are often over used in database applications.  Personally I will start out by saying that I only use functions when I absolutely have no other choice.  This is something that I have seen many… Read more

0 comments, 430 reads

Posted in Another SQL Geek on 5 December 2014

SQL Saturday NYC Update 1

It has been one week now since SQL Saturday NYC was announced and the planning committee and myself are very pleased.  We have 50 people registered to attend as of noon today and we have our first Gold Sponsor, Rehfeld and our first Bronze level sponsor with Ntirety.  The… Read more

1 comments, 273 reads

Posted in Another SQL Geek on 3 December 2014

SQL Saturday NYC

I excited to say that PASS SQL Saturday NYC is back on the schedule and will be May 30, 2015 at the Microsoft Times Square office.  It is something that we have been talking about for some time now at the NJSSUG.  It took some time to get the… Read more

0 comments, 749 reads

Posted in Another SQL Geek on 25 November 2014

Older posts