Browse the archive
Question I’m breaking some new ground and trying to get into Azure Data Studio. I’m having a problem with intellisense that seems to be a bug with Azure Data Studio but I’m not sure. I have issues with basic queries. Foreign keys, select statements and insert …
Continue readingUse sys.dm_server_services to find SQL Server service accounts, startup times, and instant file initialization status.
Continue readingThere’s a lot of advice out there on the internet that suggests that you should not install SSMS on your database servers running SQL Server. This came up at work recently, where I was asked “Should we install SSMS on our database servers?” and my answer is:
Continue readingLast week, I had the pleasure of participating in Redgate Streamed, a three-day virtual conference organized by my friends at Redgate. My session was Shortcuts from an impatient DBA–discussing a bunch of Management Studio tips & tricks for data professionals. …
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 readingThe number of people who really love having their code [quoted] with [square brackets] is pretty small. The vast majority of people who I meet really hate them, and promptly remove them.
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 readingUpdated (2018-09-24): SQL Ops Studio is now generally available, and has been renamed Azure Data Studio. I've updated the cheat sheet to reflect the name change, but the shortcuts remain the same. Feel free to grab the updated PDF with the new label, or keep …
Continue readingUse a backup to NUL to test SQL Server backup throughput without writing a backup file.
Continue readingI often get asked, “Do you have any of your sessions recorded so I can watch them online?” And the answer has always been, “No, you’ll have to come see me in person.” I’m a tad of a perfectionist, so if I was going to record something just for publication …
Continue reading
