Search this blog
Steve’s tweets
- @PaulKennyOL Safe travels. Would love to get time to chat on one of these trips 5 hours ago
- @matt40k It's not raining elsewhere in the world? Could be British Columbia. 8 hours ago
- @nocentino Actually going past this to elsewhere in the city. Canary Wharf is the destination today. 8 hours ago
Friends of Redgate
MVP Award
Tags
- administration
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- bloopers
- business
- Business Intelligence
- career
- career
- cell phone
- Cloud Computing
- computers
- continuous delivery
- continuous integration
- data
- data analysis
- database design
- databases
- Database Weekly
- dbatools
- deployment
- Dev Connections
- DevOps
- disaster recovery
- DLM
- encryption
- ETL
- Friday Poll
- GDPR
- hardware
- high availability
- Humor
- life
- Linux
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- sabbatical
- security
- software development
- software development
- speaking
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- SQLServer
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- training
- travel
- tsqlt
- vacation
- version control
- virtualization
- windows
- work
Tag Archives: powershell
Quick PoSh SQL Provision Databases for New Developers
As part of some presentation work, I wanted to demonstrate some onboarding of new developers. To that end, as part of a demo, I wanted to build a script that would take a few parameters and generate some SQL Provision … Continue reading
Hands off dbatools updates
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading
Jobs in PoSh to Create a Load
I saw this from Argenis Fernandez, and thought it was wonderful. 1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U sa -P ‘iLovePoSh’ -i /home/username/test.sql } } Create 128 threads, each running a background … Continue reading
Posted in Blog
Tagged powershell, syndicated
A Great Case for Powershell
I think PowerShell is a great addition to the Microsoft stack. Given the previous versions of VBScript, Perl and Python ports, and more on Windows, PowerShell is a great improvement. Even for someone that spent a lot of time in … Continue reading
Posted in Editorial
Tagged powershell
Checking Tempdb with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading
Posted in Blog
Tagged administration, dbatools, powershell, syndicated
Remove-DbaBackup with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading
Posted in Blog
Tagged administration, dbatools, powershell, syndicated
dbatools is Growing Up
The dbatools.io project is growing up rapidly. I went to check something the other day and I was amazed at the command list. This used to fit on one page. Now it’s not close. Here’s the first page: In fact, it … Continue reading
Posted in Editorial
Tagged administration, dbatools, powershell
Scripting Tables with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading
Posted in Blog
Tagged dbatools, powershell, syndicated
dbatools and Orphaned Users
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading
Better Security with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading
