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

Richie Lee's SQL Stuff

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

Archives: September 2017

Deploy Dacpacs With PowerShell

Final Addendum – use dbatools!

Addendum – There is a repo on GitHub which I wrote and recommend using for build/deployment of DACPACs. Read up on my last post about PoshSSDTBuildDeploy. But for a quick and dirty overview, read on…

When it comes to managing Dacpacs with automation (eg… Read more

0 comments, 414 reads

Posted in Richie Lee's SQL Stuff on 26 September 2017

SSIS Package Execution in Azure is Out Now

It’s been a long time coming, but now SQL Server Integration Services is in Public Preview on Azure!

I’ve written about it elsewhere in greater depth, but here are the headlines:

Read more

1 comments, 302 reads

Posted in Richie Lee's SQL Stuff on 25 September 2017

Restore BACPAC to SQL Azure


2 posts in 1 day? When you’re hot, you’re hot!

I’m actually writing this one whilst I’m waiting for a BACPAC to restore to Azure. It’s actually incredibly easy: use SQLPackage! Setthe /SourceFile to your bacpac, and use the connection string published on Azure, and you’re done!

View the… Read more

0 comments, 255 reads

Posted in Richie Lee's SQL Stuff on 22 September 2017

How To Update Visual Studio 2017

(AKA how I lost a morning)


This morning I needed to update my version of SSDT, but before I could do that I needed to update Visual Studio 2017:

Awkward wording of an error message aside, let’s update Visual Studio 2017.

But how?

I just started VS 2017, and… Read more

0 comments, 584 reads

Posted in Richie Lee's SQL Stuff on 22 September 2017

Truncate vs Delete in SQL Server: What’s the Difference?

I’ve been using TRUNCATE TABLE to clear out some temporary tables in a database. It’s a very simple statement to run, but I never really knew why it was so much quicker than a delete statement. So let’s look at some facts:

  1. The TRUNCATE TABLE statement is a DDL operation,…

Read more

1 comments, 309 reads

Posted in Richie Lee's SQL Stuff on 4 September 2017

New Baby Musings (AKA Things I’ve Thought Upon On Sleepless Nights)


One month ago I became a dad for the 3rd time. And so my spare time, which has always been a premium, has shrunk even further. But here’s some thoughts on some stuff:

SQL Stuff

  • SSDT Supports Visual Studio 2017. And not only that, SSDT supports SQL Server Database,…

Read more

0 comments, 66 reads

Posted in Richie Lee's SQL Stuff on 2 September 2017

Sample Databases For SQL Server

As a blogger, one thing that I appreciate greatly is examples of technical features. This is mainly because

  • technical features can be complicated to explain succinctly
  • I myself learn best by doing, not reading how to do something
  • It proves that I’ve made an effort into understanding how something works

Read more

0 comments, 120 reads

Posted in Richie Lee's SQL Stuff on 1 September 2017