Excellent article. I wish Microsoft weren't neglecting SSMS, and ESPECIALLY the "Solutions" feature... 😓 From here: https://learn.microsoft.com/en-us/sql/ssms/solution/solution-explorer?view=sql-server-ver16 It reads: "Important. This feature will be removed in a future version of...

I do see what you mean now... One can use "Suggest Column Types" in the Flat File Connection Manager, but, trusting the results... Yes, I can now say I see...

I am sure I am missing something here, especially with the comments raving this as a great solution. So, pardon my stupidity: What is the advantage here, if you have...

Perfect. You're awesome. It surprises me that you do not include credits as comments in the SP at all! You should! Anyways, THANK YOU! Best, rferreira.dba.

• This reply was modified 3 years, 8 months ago by  rferreira.dba.

Same question here. Did you ever find out? TIA, Raphael.

I echo those citing "Jack of all trades, master of none." here. Yes, I consider myself a "full stack DBA." I've done it all. In fact, I even have a...

I was having the same issue. Solution was to right click Data Tools and "Run as administrator". That solved the problem. Raphael

In our case, our final solution was a bit involved, but for us it is robust and keeps everything we need:

1- We mirrored the database(s) into a mirror server.

2- We...

I'm coming to the conclusion that my best option is to reschedule my full backups to happen exactly after the snapshot is taken.

Now, is that retarded of Microsoft or...

I have the same exact problem. The suggestions in the thread are not viable. You see, there is a reason for us to be doing a snapshot of the DB...

No conflicts by removing the Add-PSSnapin SqlServerProviderSnapin100 one. All good. Thanks much! Waiting for Level 4. 🙂

OK. You found what the problem was. I had the $profile already set up with all the commands you presented on your articles. Somehow, because I had already loaded the...

Still the same error/warning messages. No solution.

Additionally, when running import-module SQLPS, I get the following: "Object reference not set to an instance of an object.

WARNING: Some imported command names...

That did not do it. It's a VM running under Parallels and I have complete control over it. I added myself to the administrators local group, and ran the powershell...

Hi all, I'm having a little bit of a problem with one of the command lines erroring out and I am not sure why. When I try:

"$server = Get-Item SQLSERVER:\SQL\localhost\default"

I...