Browse the archive
Question I need to get the values from a Excel Sheet (in a shared folder) to export it and then create a SQL Table in my instance. After of this I will execute a Stored Procedure (I already created) in order to create extended properties for a specific schema …
Continue readingRonJohn needs to know if his VMs are hyperthreaded. I point him to vCenter for a definitive answer, and to a SQL Server DMV for the next best thing.
Continue readingEducorreia is using GitKraken with GitHub, and needs some help navigating the licensing & edition differences to make that combination work with private repos.
Continue readingHussain Akbar is creating a custom app, and is wondering if he can run both his production Web & SQL Server instances on the same Windows 10 machine to save on licensing. I don't like the sound of running the database on a web server.
Continue readingI was recently fussing with a CSV file that had an inconsistent number of columns. UGH. There was a bunch of historical data that had 4 columns, and then more recent data had a new attribute added with 5 columns. I spent a few minutes cursing whoever was …
Continue readingI might be a SQL Server pro, but I’m still a PowerShell novice. I learn best by doing, so I keep pushing myself to do more with PowerShell so that I can learn more. If you don’t already know this about the SqlServer PowerShell Module, you can access SQL Server …
Continue readingQuestion Is there a simple way to reconnect a query window that is “not connected” to the original connection that was used by that query without manually picking the server name needed? If I click the Connect button on the SQL Editor toolbar or right click …
Continue readingQuestion I have a powershell script that I am trying to add in to a sql agent job, but the job step is failing with the following error A job step received an error at line 1 in a PowerShell script. The corresponding line is 'import-module SQLPS …
Continue readingvstrien is using the (legacy) SQLPS Powershell module, and running into a bug where importing the module changes your current directory.
Continue readingEdit: I've published an updated version of my cheat sheet. Find the latest version by in the sidebar --> I've presented my **Shortcuts from an Impatient DBA** talk a few times now, and I really love it. Everyone learns something, whether you're a Junior …
Continue reading
