Author Archives: way0utwest

About way0utwest

Editor, SQLServerCentral

Are you GDPR Ready?

The GDPR is being enforced as of yesterday. It’s been a law for two years, but fines are now going to be assessed for violations. If you’re like me, you’ve been getting a lot of different types of privacy policy … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Republish: The Opportunistic Hacker

Still in Ireland: The Opportunistic Hacker.

Posted in Editorial | Tagged | Leave a comment

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

Posted in Blog | Tagged , , | Leave a comment

The Oddest Thing

My desk is a mess, at least, it’s a mess compared to many people’s workspaces. Not as bad as some, but certainly worse than others. I sometimes care and will clean clear things away, maybe even get rid of some items, but for the most part I … Continue reading

Posted in Editorial | Tagged , | Leave a comment

One Week to Music City Tech

Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in Nashville on May 31-June 2. There are a lot of great sessions on the schedule, covering a lot of software … Continue reading

Posted in Blog | Tagged , | Leave a comment

Lessons for all of us

I write a fair amount about career issues. It’s one of the largest tags in my word cloud, and I’m proud of that. I’ve seen too many people in bad jobs for too long, had a few myself, watched my wife … Continue reading

Posted in Editorial | Tagged | 2 Comments

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 , | Leave a comment

Pause and Backtrack

One of the main functions for anyone that manages a database is ensuring that they can recover the system in the event of any issues. My view is that restores are the most important skill and task that need to … Continue reading

Posted in Editorial | Tagged , , , | Leave a comment

Checking CHECKDB

One of the recommendations for SQLServer is that you run a DBCC CHECKDB regularly on your system. Those individuals that have worked with SQL Server for some time and worked on learning more about the system know to schedule this … Continue reading

Posted in Editorial | Tagged | Leave a comment

Update Oddness for SQL Server

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2. This went as … Continue reading

Posted in Blog | Tagged , , | 2 Comments