Let’s Talk Shop
When You Love Data as Much as I Do…
I’ve been working in data for a long time. After a while, you recognize the issues that everyone runs into sooner or later—and hopefully, can come up with some pretty creative solutions. I love being able to wax profound (or at least, long-winded) about why these issues come up and how I like to go about resolving them. Or just pose a question to my fellow data professionals so we can discuss. Check out my past blog articles here, or get in touch if there’s a topic you think I should cover.
Featured
Why Become a PowerShell DBA
If you find this article valuable and you decide that you want to get your learn on with PowerShell and SQL Server, there is a SQLSkills class that I am teaching this year, please join me to get a great start in how to get your toolset growing by adding PowerShell to your toolbelt. Early
February 20, 2019
Recent
PowerShell for the DBA at SQLIntersection with @DBAduck
If you are wondering why you would want to use PowerShell as a DBA, read this first – Why Become a PowerShell DBA. Then go to SQLIntersection Registration to register and I will see you there. And if you register, please use the code MILLERB and you will get $50 off registration. Click the links
October 21, 2019
Connecting iSCSI LUNs with PowerShell
When clustering SQL on Windows Server Core, I had the need to configure the ISCSI LUNs to the server without UI. I know that there is a UI component called iscsicpl.exe that you can run and it will pop up the simple Windows UI to allow you to click through all the configuration, but I
September 8, 2019
dbatools 1.0 is here and why you should care!
I have been using dbatools for a long time now. I have even contributed a few commands and fixed some bugs. I present on this topic and help many people with PowerShell and being a DBA. I am so excited for the launch of 1.0 for dbatools, that I cannot stop pinching myself to make
June 18, 2019
Why Become a PowerShell DBA
If you find this article valuable and you decide that you want to get your learn on with PowerShell and SQL Server, there is a SQLSkills class that I am teaching this year, please join me to get a great start in how to get your toolset growing by adding PowerShell to your toolbelt. Early
February 20, 2019
SQLintersection Workshop attendees change to URL
Hello All. I am ensuring that you have access to the downloads. In the slide deck there was a link and it pointed to the file. You need to add /wp-content/ to the URL before uploads and after dbaduck.com. That means that the uploads are at https://dbaduck.com/wp-content/uploads/nameoffile.zip I apologize for having the link in the
March 27, 2018
PowerShell month in May with DBAduck
I am excited for this month. SQLSkills Training Event 1 for this month revolving around PowerShell is May 8-10 at SQLskills.com training in Chicago. I am teaching the first class of the Immersion event on PowerShell for the DBA. You can see the details in the link on the class. I am super humbled and
May 1, 2017
#SQLIntersection with DBADuck
In May, I will be at SQLintersection at the Disney World Swan in Orlando, Florida. You can visit the site to see the full lineup of sessions and workshops. I’m going to be presenting three sessions on SQL Server topics and 1 Workshop on PowerShell in SQL: IN DEPTH TEMPORAL TABLES IN SQL 2016 Have you
January 26, 2017
PASS Board Elections, Why am I running?
Hey all you SQL PASS people in the #SQLFamily. I am a little late to the game, but wanted to ensure while the voting is active now, that you had why I am running. In this vast connected world of technology there are so many SQL People I don’t even know if I venture to
October 5, 2016
Join me at SQL Intersections in October 2016
In October, I will be at SQLintersection at the MGM Grand in Las Vegas, Nevada. You can visit the site to see the full lineup of sessions and workshops. I’m going to be presenting four, count them 4 sessions on SQL Server topics and 2 Workshops on PowerShell in SQL: Be Friendly to SQL Server with
September 28, 2016
Join me at SQL Intersections for a great lineup this year!
In April, I will be at SQLintersection at the Walt Disney World Swan in Lake Buena Vista, Florida. This year, you can save $50 on attending by using my last name (MILLER) as the promo code, AND if you register by January 31st, you may be eligible for free hardware as well – a Microsoft Band
January 28, 2016
FreeCon in Seattle, October 27th before PASS Summit 2015
SQL Solutions Group is getting ready to host a day of training. This will be a FREECON, which means that it is free and before a conference. Seattle is the place for PASS Summit 2015 and that is where the FreeCon will be held. Registration is here. More information is here. This training is not
October 5, 2015
SQL Server TDE on Mirror and Log Shipping
Today in our Virtual Chapter meeting for VCDBA, I presented on SQL Server Encryption including TDE. The question was posed as to whether or not the TDE would take affect if the mirror was established first and then you enabled TDE on the database. I was not sure at the time only because I had
June 24, 2015
sys.dm_db_index_physical_stats Easter Egg
I was reading through documentation on the DMV sys.dm_db_index_physical_stats and found that there are a couple of things you need to be aware of when using this DMV. First, we know that there are parameters for the DMV. Parameters Database Id Object ID Index Id Partition Id Level of interrogation (DEFAULT, LIMITED, DETAILED, SAMPLED, NULL
May 7, 2015
Utah Code Camp 2015 Presentations
Sorry I am so late, but Thanks to all those that attended my sessions at the Code Camp. Utah Geek Events has been good to me and I want to make sure that everyone gets the presentation materials and the demo files. Links are below. Hope you enjoy. See you again next year. Starting Out
March 22, 2015
Precon: IndyPASS 2015 – PowerShell and SQL Server
I am fortunate to be able to present a precon at IndyPASS this year. The link to register is PowerShell for the DBA from 0-60 in a day. We will go through PowerShell from a DBA point of view and there will be scripts, techniques and lots of information on how you too can be
March 19, 2015