henrik staun poulsen (11/29/2016)

---

Steve,

I'm perfectly happy about the enhancement that we got with

DROP TABLE IF EXISTS myTable

CREATE TABLE myTable(...)

This ensures that the table is dropped, so that my Create table...

hakim.ali (11/29/2016)

---

IMHO, even "CREATE or ALTER objectname" can/should be reduced to just "CREATE objectname". Visual Studio database projects / SSDT has had this for years. Just issue the create statement,...

Indeed

robert.sterbal 56890 (11/28/2016)

---

It would be helpful to have a forum item to discuss the terms. Does one...

Try these:

http://www.sqlservercentral.com/articles/Drive+space/134523/

http://www.sqlservercentral.com/scripts/67064/

http://www.sqlservercentral.com/articles/61819/

david.gugg (11/28/2016)

---

That's pretty crappy documentation on Microsoft's part. I also found the answer on https://msdn.microsoft.com/en-us/library/hh231286.aspx, where it shows the example as

#Import the SQL Server Module. ...

My daughter grinds beans each morning for her french press and froths milk. She usually makes enough to give me a cup 😉

djackson 22568 (11/28/2016)

---

The trick is knowing when your staff can pick up something new, and when you need to hire consultants. Our organization excels at that. Of course...

SQLPS has been deprecated. The article update date is based on a change to the article, which could just be a typo correction or anything else. That does not indicate...

http://www.sqlservercentral.com/About/Terms

The content is copyrighted by authors, and its use is subject to copyright law.

1 - Use PowerShell and Start-Service and Get-Service to check the status of your service. You can run a job to do this in Windows Scheduler.

2 - There are scripts...

There's a fun starting tutorial here: https://www.microsoft.com/en-us/sql-server/developer-get-started/

Hope people had a good Thanksgiving in the US, or a quiet day elsewhere.

Another day off for me, so I'm enjoying it after a quick check.

For Redgate, we have great...

This is a hard to write set of code for a database. For a table, it's easier. You will want to look at EXCEPT to handle here, but really you...

Thanks, Hugo, I'll take a look.

We are cutting out all gluten for my daughter. I'm trying, though not doing as well.