Browse the archive
Doggos increase blog readership by 140%. 14/10. They are good doggos. As a DBA, you probably use the OBJECT_NAME() function quite a bit. I know I do. If you aren’t familiar with it, you can read the documentation if you want, but it’s a pretty straightforward …
Continue readingThis guy doesn't have Elvis's password and is still able to impersonate him. As a DBA or SQL Developer, you've surely encountered a scenario where something worked for you, but not for another user. DBAs usually are part of the sysadmin role, or have a …
Continue readingChanging a column from int to bigint has gotten a lot easier since I started working on SQL Server back at the turn of the century. SQL Server 2016 introduced the ability to do ALTER TABLE...ALTER COLUMN as an online operation using the WITH (ONLINE=ON) …
Continue readingI was fiddling around with some data, looking at making a quick aging report. I probably should have reached for Power BI Desktop, but sometimes I can be stubborn, and I wanted to get my T-SQL to work–if nothing else to figure out how to make it work.
Continue readingI was recently chatting with a coworker, discussing why there is no discrete DROP permission for tables, procedures, etc. The conversation actually came from a #SQLHelp question on SQL Slack that was asked along the lines of “What if I want to let a user …
Continue readingIn Year Three, I had a pretty big year. I kind of felt like I had peaked. I had received the Community Influencer of the Year Award and Microsoft MVP Award. Where do you go from there? Mostly, I just wanted to keep up what I was doing, and keep sharing what I …
Continue readingOnly one thing can spark more joy than cleaning up old data. Doggos. Yesterday, I talked about batching deletes, and the day before I talked about how much I like to delete data, and why it's necessary to do it, despite being a data packrat. Today, let’s look …
Continue readingThis person understands that batching deletes can be helpful. Yesterday, I wrote about the importance of planning your data purges. Today, let's look at the simplest requirement for purging data: Keep data for X days after it's created. There are tons of …
Continue readingI get a thrill from roller coasters, but for some people it just makes them purge their lunch. DBAs & Data professionals tend to be digital pack rats. My personal Google Drive is filled with random files that I refused to part with–even though it’s of …
Continue readingIt’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Aaron Bertrand (blog | twitter). The topic: Dealer's Choice (Door Number 2: Bad Habits) When I was a kid, Choose Your Own …
Continue reading
