There was a recent post on Database Administrators, where there was some confusion over Daylight Saving Time(DST) in Australian timezones. Let’s be honest though–timezones are confusing, especially when DST comes into play. Arizona Time doesn’t observe Daylight Saving Time, so sometimes it’s the same as … [Read More]
In yesterday’s post, I showed how to configure an availability group (AG) to use the RegisterAllProvidersIP=0 when you can’t get clients to connect using the MultiSubnetFailover=true connection string attribute. I mentioned that you have to make some trade-offs when you set RegisterAllProvidersIP=0, and included this … [Read More]
As a DBA, we have the opportunity & responsibility to build highly available database platforms for use by applications & users. Even if you are a DBA at a small company supporting databases for only internal applications, we are usually still responsible for providing databases … [Read More]
I 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 … [Read More]
I was recently asked: For testing, I need to generate artificial CPU load on the server, outside of SQL Server. Do you have any ideas? Maybe something with PowerShell? I quickly replied: Heck yea, PowerShell can do that. I mean, I knew PowerShell could do … [Read More]
In case you’ve missed it (though, if you’re a data professional or other IT pro, you must live under a rock if you’ve missed it), SMBv1 should never ever be used. Alas, some shares out there still exist & use it. Recent Windows updates have … [Read More]
I 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, … [Read More]
I hate RSS readers For some reason, about once a year, I go hunting for a new RSS reader so I can keep track of blogs that I like to read. It’s always the same process: Dig through reviews to find an app that I think … [Read More]
It’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery Your backups are my bread & butter Backup & recovery are a DBA’s bread & butter. I always tell people that … [Read More]
Today, my friend Derik Hammer (blog|twitter) asked about moving SSRS reports between (versions and) instances of SSRS: What is the best way to move 2008 R2 SSRS reports into an existing 2012 SSRS instance? Catalog move is insufficient here. #sqlhelp — Derik Hammer (@SQLHammer) June … [Read More]
Copyright © 2024 | Andy Mallon | am2.co