Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

The Resurrection of Reporting Services & The Maturing of Power BI

Spending the past two weeks at the annual PASS Global Summit and the Microsoft MVP Summit, I’ve consumed a literal firehouse of information about the Microsoft BI platform.  I’ve participated in the PASS Summit for twelve years and the MVP Summit for seven years thus far and in that time,…

Read more

13 comments, 138 reads

Posted in SQL Server BI Blog on 12 November 2015

SQL Server 2016 CTP 3 Setup – UI Improvements

There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making these changes as they receive feedback from multiple customers and early adopters.

My earlier post on setup UI changes for CTP 2 is available here.

The 1st change is… Read more

0 comments, 95 reads

Posted in on 11 November 2015

Webinar: Unit Testing with SQL Server and tSQLt

I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is the founder and developer of tSQLt, which I really like using. We’ve done some teaching together and I’ve delivered a number of sessions on tSQLt at various events, but… Read more

2 comments, 157 reads

Posted in The Voice of the DBA on 11 November 2015

Question: Single SQL Server VM on One Host Justifications

Earlier this week I received a great question from a friend, and read something like this.

Hi David,
I usually recommend people to install SQL Server on VM and I argument it by saying that it would make any future hardware migration easier.
However, I just think if company purchases…

Read more

2 comments, 106 reads

Posted in Technobabble by Klee from @kleegeek on 11 November 2015

Updating Extended Properties

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.

I wrote recently about adding extended properties. Updating them is very similar. There’s an analogous procedure called sp_updateextendedproperty that changes the value of properties.

The arguments are… Read more

1 comments, 117 reads

Posted in The Voice of the DBA on 11 November 2015

Veterans Day – Thank You for Your Service

If you currently serve or have served in our military, thank you for your service. Please never doubt that your efforts made a difference.

Read more

0 comments, 94 reads

Posted in SQLAndy on 11 November 2015

Did PASS Forget the DBA?

Today I had on my list to finish watching the presentation Gail Shaw did at Summit 2014, one of the free recordings on PASS TV. I don’t remember it from before, but I was prompted to fill out a short demographic form. Ok, I get it. Then I get to… Read more

3 comments, 123 reads

Posted in SQLAndy on 11 November 2015

Support for SSMS 2016 now available

Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install SIPF from Red-Gate's site - and you'll be able to use SQL Code Guard and ExpressProfiler from SSMS 2016!

Great job, Red-Gate! Awesome as always!
Thank you,…

Read more

0 comments, 115 reads

Posted in SQL Code Guard on 11 November 2015

Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage

Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage
NOVEMBER 11, 2015

In my next series of posts, I am going to look into processing files in Azure using the Azure Data Factory. Before processing the files, though, the files first have to get to…

Read more

0 comments, 727 reads

Posted in Pie in the Sky on 10 November 2015

More Thoughts on the PASS BAC

Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by me):

The PASS BA Conference answers the call to meet the unique needs of business and data analysts, who are asked to do more with data every day.…

Read more

3 comments, 95 reads

Posted in SQLAndy on 10 November 2015

Poor Data Modeling – T-SQL Tuesday #72

This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people seem to do, especially developers, and it often can go wrong. That’s the topic, and I have a short story.

T-SQL Tuesday is a monthly blog party, on the… Read more

0 comments, 478 reads

Posted in The Voice of the DBA on 10 November 2015

T-SQL Tuesday #72 Invitation – Data Modeling Gone Wrong

T-SQL Tuesday is here again. I’ve had good intentions the past few times this event has come around and even have drafts still waiting to be queued up which I will eventually turn into regular blog posts, but I decided to just make time this month and jump back into… Read more

3 comments, 1,350 reads

Posted in The SQL Professor on 10 November 2015

Renewed as MVP

I was renewed for another year as a SQL Server – now Data Platform – MVP, always pleasant news. My plan for the new MVP year is pretty much the same as last year, I’ll try to out and about serving the Florida community, doing some mentoring, and contributing to… Read more

0 comments, 101 reads

Posted in SQLAndy on 10 November 2015

New FileTable Questions Posted on SQLServerCentral

I’m late posting this, I wrote six questions after doing a refresh of what I knew (or should have known) about filetables:

Read more

0 comments, 121 reads

Posted in SQLAndy on 10 November 2015

Why are you still using datetime?

It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a blog topic for me! In this case it’s the always fun Mickey Stuewe(b/t) and her topic is Data Modeling Gone Wrong. So let’s see ..… Read more

10 comments, 3,997 reads

Posted in SQLStudies on 10 November 2015

T-SQL Tuesday No.72 - Is Your Data Model, Normal?

Well I’m not a data modeler, nor do I play one in the corporate world.  But it is TSQLTuesday No. 72, and I have my tales to tell.  Mickey Stewe, (b|t), aka @SQLMickey, database architect, whose focus is on data modeling, has invited… Read more

0 comments, 488 reads

Posted in Pearl Knows on 10 November 2015

T-SQL Tuesday #72 - Implicit Conversion Problems

This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”

(If you don’t know about T-SQL Tuesday check out the information here– each month there is a new topic and it is a…

Read more

2 comments, 1,143 reads

Posted in Nebraska SQL from @DBA_ANDY on 10 November 2015

What is the DLM Maturity Model?

I’ve written a few posts on the Redgate Software blog to try and show how I see the DLM model, and how we see things at Redgate. We have a lot of developers that work in a similar way when building application software in C#, Java, Python, or other languages,… Read more

0 comments, 138 reads

Posted in The Voice of the DBA on 9 November 2015

Monday Morning SQL Break – November 9, 2015

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This post provides a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 8 reads

Posted in StrateSQL on 9 November 2015

Newer posts

Older posts