Tag Archives: syndicated

Loading All CSV Files with PowerShell

I ran across Denis Gobo’s post about working with names from Social Security cards and wanted to play with the dataset. However, rather than use xp_cmdshell, which I might have, I decided to use PowerShell. I need to repeat this … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Move a Stored Procedure to a New Schema–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I needed to do recently was move an object. I was testing the WideWorldImporters database … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Using OPENROWSET in SQL Server on Linux

I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows. Linux is a … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Speaking at the Data Platform Summit 2017

I am honored to be speaking at the Data Platform Summit 2017. The event takes place August 17-19, 2017 in Bangalore, India. This will be my first trip to India, and I’m excited to be traveling halfway around the world … Continue reading

Posted in Blog | Tagged , , | Leave a comment

DevOps – Downloading a File from the Internet with PoSh

One of the things we need to do as data professionals is move data files around. Often we’ll get a local path, but in looking for public data sets, I wanted to get a file from the Internet. In this … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Renaming MDF/LDF Files–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I would guess many people would run into this situation at some point. A developer or DBA creates a … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

T-SQL Tuesday #91–Early DevOps

This month the T-SQL Tuesday invitation is from Grant Fritchey, my colleague at Redgate Software. Surprise, surprise, the topic is DevOps. I write and talk about this a lot, but for this month I’ll look back at DevOps for me … Continue reading

Posted in Blog | Tagged , , | 1 Comment

VSTS–Changing the Default Build Queue

I wrote recently about the Release agent using the hosted queue as the default, which is sometimes a problem. The Build process has the same issue, though the way you change things is different. In a build, you see a … Continue reading

Posted in Blog | Tagged , , | Leave a comment

VSTS– Hosted Agent is the Default for Releases

In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun 1, 2017. If your screen looks different, find a different article. I was setting up a test the other day … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Restore a BACPAC–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I needed to get the WideWorldImporters sample database for a project and noticed that there was a BACPAC available. … Continue reading

Posted in Blog | Tagged , , , | 2 Comments