Viewing 15 posts - 1 through 15 (of 44 total)
and no...im not talking to myself :crazy:
July 2, 2014 at 4:45 pm
Posted out to #sqlhelp and thanks to @SQLHA, @Kendra_Little and @SQLSoldier I was able to fix the issue.
The SIDs were different across the servers, so as a quick...
July 2, 2014 at 4:42 pm
sql4gnt (7/2/2014)So I'm thinking if I perform a quick failover, modify the user1 permissions on the replica, then fail back, this might fix the problem? :unsure:
Negative, because the user or...
July 2, 2014 at 3:52 pm
One thing I'm noticing is that when I set this up, the user(s) in question were created after the AG was configured. So user1 on the primary was able...
July 2, 2014 at 3:36 pm
Yeah I'm a bit skeptical as to whether this can be done or not myself, but I was hoping someone with more experience would have good news for me...
April 18, 2014 at 12:00 pm
We should start a new thread for discussing SQLIO (totally didn't mean to hijack the original) 🙂
I run SQLIO for read and write, sequential and random, and 8k and 64k....
March 18, 2014 at 2:33 pm
First, recognize the appropriate dbareaction
Here is a good chance for you to some science. Setup your lab, and run through the scenario. Maybe using HammerDB you can run...
March 18, 2014 at 7:45 am
I would check the uptime of the server. Lot's of indexes might seem unused shortly after a reboot. I'm usually hesitant to do any index changes like this...
March 18, 2014 at 7:31 am
8x15k SAS Drives configured as RAID 1+0 and...
March 17, 2014 at 3:24 pm
We ran some tests just at the storage level and the RamDisk was 13x faster. Here are the CrystalDiskMark results
8x15k SAS Drives configured as RAID 1+0 and 100 Write...
March 17, 2014 at 12:30 pm
I've been using Red Gate SQL Monitor for about 5 years. The price point is great, and it has never let me down.
I've come from days where...
February 12, 2014 at 10:00 am
+1 for Poor Man's T-SQL Formatter. Free is affordable. I use a combination of tools.
When I'm writing code in SSMS I use Red Gate SQL Prompt which is...
February 11, 2014 at 11:50 am
Here is my favorite. Written by SQLDenis
February 3, 2014 at 11:28 pm
If you are doing it strictly for development purposes, then there shouldn't be any problem with just running a local instance of sql server.
Personally, I run everything inside virtual machines...
January 29, 2014 at 7:35 am
Along the lines of what Jeff suggested, maybe you can implement your fix and publish it as a "fix" to a security hole in their api? At the very...
January 29, 2014 at 7:30 am