Alen
  • Member for 5 years
  • Last seen more than a month ago
Enable Job instantly after AOAG Role change
0 votes

we use a simple primary node checker to only run jobs on the primary node of an AlwaysOn cluster. It's a little flaky with some things like SSIS packages so in those cases we have the first step as a ...

View answer
Script to turn off SQL agent when Primary role change to Secondary in AlwaysOn - sql2014
0 votes

we use a simple primary node checker to only run jobs on the primary node of an AlwaysOn cluster. It's a little flaky with some things like SSIS packages so in those cases we have the first step as a ...

View answer
Query to report disk space allocation and used space
0 votes

Something I put together. You NEED POWERSHELL on your SQL Server to run this. Not sure of the version. This will take your drive sizes and report back the file sizes and free space as well as free ...

View answer
Trigger To Find Deleting Job Agent History
0 votes

I can't post a screenshot due to the server name being in there, but right click on SQL Server Agent and select Properties. Once there, go to the lowest option, History. Check the settings there. I ...

View answer
Log Shipping or Always on as DR for SQL Failover CLuster
0 votes

AlwaysOn. If the application is configured properly for the listener, you can have a fail-over every hour and no one is going to care and no complaints from users in 99% of cases. I've also seen ...

View answer
What are some real world applications that generate large numbers of records in a database every day and what are those metrics?
0 votes

I've worked at a place where our billing data ranged from 80GB to 200GB or so every month. Every few days new bills were generated and old bills archived to another server. The original schema was ...

View answer
Does restoring a full backup bring it to the backup START time or the backup FINISH time?
0 votes

Any SQL backup is done when it writes the backup end time to the backupset table in the msdb database. When you search in there full backups are type D and log backups are type L. And there is a copy-...

View answer
What to do when your Always On cluster loses quorum?
0 votes

Once I've been involved in an outage where our mirrored servers lost connectivity. One of the things to worry about is making sure your applications are pointed to a single instance. In a network ...

View answer
Domain Account or Windows account for Transactional Replication
0 votes

The only problem I've ever had with using a Windows account for replication is when there were domain controller issues. A DC would stop authenticating and replication would fail. After a few ...

View answer
SSIS: How do I create tables using Foreach Loop Container?
0 votes

This isn't exactly what you're looking for, but I do something similar with powershell. We have an automated process where we have to dynamically build a folder name and UNC path and execute every SQL ...

View answer
Normalization Problem for drugstores information
0 votes

I'd think about adding a column and a foreign key for the pharmacy tech table to make sure only valid drug store ID's can be assigned to the tech.

View answer
Are there any caveats in my SQL migration plan?
0 votes

If you are running Enterprise Edition then you can simply set up AlwaysOn to the 2016 server and fail over once. If you are running Standard i'm 99% sure mirroring is supported and you can do the ...

View answer
Different Disk Drive Same Backend Storage
0 votes

This will depend on your exact SAN. But in a former job we had a SAN with auto-tiering. In this case, in theory you can divide up your database into files and the most active files would automatically ...

View answer
SQL Server Linked Server performance: Why are remote queries so expensive?
0 votes

I think you are better off replicating the remote table to the server you are querying from and then running all your SQL locally.

View answer
Syncronizing process difference between replication and alwayson high availability
0 votes

AlwaysOn/Mirroring reads the log on the master server and transfers all the commands to the DR servers where it essentially restores the t-log from a backup. Replication reads the log and translates ...

View answer
Is there any reason for an index to contain the primary key?
0 votes

you need to use the index DMV's to figure out which indexes are currently being used or not used. second it could be a case where the server is being used for OLTP and reporting which can result in ...

View answer
Replication between two different SQL Server versions
-1 votes

Are you using a distributor? The order is DPS: Distributor > Publisher > Subscriber I think as long as everyone is SQL Server 2008 and later you should be OK. Last I read, SQL Server 2014 won't ...

View answer
Is there a way to backup a mysql database without having to run mysqldump?
-3 votes

You can try using the built in OS backup software. Been a while, but I think I used to do it with Windows backup many years ago

View answer
1
2