Then I did a restore:
Restore-DbaDatabase `
-SqlInstance 'dbatoolslab\sql2017' `
-Database 'AdventureWorks2017' `
-Path 'C:\Temp\sql\AdventureWorks2017_marked.bak' `
-StopMark 'Replacing all Passwords' `
-StopBefore `
-WithReplace 4/n
Concullega's die hun servers cute names in een thema geven zoals Jupiter en Saturnus en Mercurius in plaats van beschrijvende namen zoals DC01 en EXCHSRV06 en SQL2017 wil ik zeer hard stompen op hele specifieke plekken
#أسئلة_شبكة_محبي_البرمجيات
السلام عليكم
مكتبة بالبايثون اسمها pyodbc ع اساس انزلها عشان اربطها بالداتا بيس sql server 2017 وعيت تضبط معي لما انزلها يعطيني "failed” ايش الحل؟
وايش ممكن اعمل عشان اربطها ب sql2017
Need to create 1000 tiny databases on 3 different servers for an experiment?
1..1000 | ForEach-Object { New-DbaDatabase -SqlInstance sql2017, sql2016, sql2012 }
For the first time I enabled automatic plan correction on a production server. Holy cow, this may be my favorite SQL 2017 feature! So long plan guides and time consumed in query store (hopefully) and hello to my new assistant DBA #helphasarrived#sql2017
Trying to start sql2017 and I get an error "initializing the fallback certificate failed with the error code: 1, state: 20, error number: 0." Any suggestions on how to fix the certificate? #sqlhelp
You missed some of the exciting news for developers in #SQL2016, #SQL2017 or #SQL2019? Then join me now in my #dwx2019 session and catch up with your #SQLServer knowledge.
Want to play with tSQLt?
Be good if it was all set up in a linux container?
docker pull sqldbawithabeard/tsqlt
SQL2017 Linux container with the examples as well
4 #sqlserver Availability Groups with cross-cluster migration WIN2012R2/SQL2014 —> WIN2016/SQL2017 done with no application downtime and no ping interruption .. time to drink a beer !!! 👍