Question We have a few Basic Availability groups in production and I’ve been reading about the limitations of them. I’m concerned about the following limitations: No backups on secondary replica. No integrity checks on secondary replicas. Suppose that we haven’t failed over in months. In … [Read More]
Question I am converting the times of some datetimeoffset columns from UTC to Eastern. I am doing this via the command This seemed to be working correctly (times were shifted 4 hours earlier and now have a -04:00 offset, exactly what I wanted), but then … [Read More]
Back in my day, we stored SQL Server Integration Services (SSIS) packages in msdb, or the file system. Well, I’m neither dead nor retired, so that’s not an accurate statement–today is still “my time.” But when I was learning about SQL Server, those were the … [Read More]
Question I have created a stored procedure which takes as inputs a schema name and a table name and outputs an INT containing the largest value in the id column of the table. I have also created a view containing all the schema names, table … [Read More]
Question Inherited a database server to maintain and found that the transaction log is 92 GB. My plan is to do the backup of that and get it brought back down to a regular size, then fix it. The problem is I don’t have enough … [Read More]
Rich Vieira asks about the feature compatibility of using AlwaysOn Availability Groups and Replication on the same database.
For this month’s T-SQL Tuesday, John McCormack (blog|twitter) asks us: “What are your go-to short, handy scripts”? I’ve got so many handy dandy scripts, it was hard to choose. Where to start? I have so many go-to scripts that are short, amazing, and I use … [Read More]
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]
Question I am using the below query to pull back database sizes for our SQL instances. This cannot pull data larger than 2TB back because of the maximum number the int data type can pull back. How do I go about altering the query to … [Read More]
Question I have a publisher with the distributor on the same server which is transactional replication. There is also an active subscriber using push method. I need to set a new subscriber up going to a different server using the same articles as the current … [Read More]
Copyright © 2024 | Andy Mallon | am2.co