-->
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

When it comes to managing Dacpacs with automation (eg either by deploying or extracting Dacpacs from a database, amongst others), you have a couple of options available to you.

SQLPackage

SQLPackage is a command line utility that is shipped with SSDT, and it’s main focus is to manage Dacpacs. It’s… Read more

0 comments, 145 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, 196 reads

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

Restore BACPAC to SQL Azure

Hello!

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, 161 reads

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

How To Update Visual Studio 2017

(AKA how I lost a morning)

Hello!

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, 276 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, 38 reads

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

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

Hello!

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, 17 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, 24 reads

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