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

Latest Blog Posts

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, 118 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, 96 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, 127 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, 117 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, 734 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, 98 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, 484 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,367 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, 102 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, 123 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, 4,017 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, 494 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,151 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, 140 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

PASS Summit 2015 Wrap Up

Last week’s PASS Summit conference in Seattle, WA was incredible (as always). It’s my favorite tech event of the year, and I’ll never miss it. The SQL Server community is one of the strongest (and arguably the most tight-knit) technical community in the world, and the #sqlfamily comes together every… Read more

1 comments, 78 reads

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

SQL Server 2016 CTP3 – new features and the JSON support improvements

SQL Server Community Technology Preview 3 has been released some days ago.

The SQL Server team added a lot of features related to:

  • SQL Server Engine (Query Store, Temporal Tables and In-Memory improvements)
  • Cloud-ready stuff (Transactional replication from and to Azure SQL Databases, Stretched database enhancements)
  • New releases of Management…

Read more

0 comments, 91 reads

Posted in Alessandro Alpi on 9 November 2015

How to get started with the ScriptDom

What is the ScriptDom?

The ScriptDom is an api for taking t-sql scripts, converting them into an AST or taking an AST and generating t-sql.

What is an AST?

Read this:

Think about this:

select col from tablea
select col from tablea
select col /*from not_table*/ from tablea

Read more

0 comments, 114 reads

Posted in Ed Elliott's Sql Developer Blog on 7 November 2015

SQL New Blogger Challenge: Week 1 recap

Thanks to everyone who participated in week 1 of the SQL New Blogger Challenge! Eight posts were written this week and linked on Twitter (#SQLNewBlogger), and I think I saw some that weren’t tweeted with our hashtag. That’s a great first week!

Andy Levy (b|t)… Read more

1 comments, 146 reads

Posted in The Data Files on 7 November 2015

Newer posts

Older posts