Viewing 15 posts - 1 through 15 (of 135 total)
It seems DST lingers because it's supposed to save energy. There's been lots of debate on this, and the most recent information I've read is that it's likely in our...
February 6, 2019 at 10:43 am
It's actually just Turkey, TX, not Turkey City, TX (although if you search on the latter in Google Maps, it will take you to the same place). I live about 100...
December 4, 2018 at 8:38 am
This reminds me of a quote I heard. Someone on TV was interviewing a business consultant, and he said: "There's one thing worse than training an employee and having him...
October 31, 2018 at 1:09 pm
I've been trying to promote Windows authentication on my new job, but it's a network with a lot of public-facing web apps, and all the public web servers are in...
April 9, 2018 at 1:43 pm
Forgot to add that periodically, I think a couple of times a year, on request and for no extra charge, iDrive will send you one or more physical drives for you...
September 13, 2017 at 8:56 am
I formerly used Carbonite, but they charge separately for every new device to be backed up. So I switched to iDrive, who lets you back up any number of devices as...
September 13, 2017 at 7:51 am
GilaMonster (6/17/2016)
You can't delete 'sa'.
Oh, OK -- I thought I saw an article or forum entry where someone said he did, but maybe either he or I misunderstood something. I...
June 20, 2016 at 2:59 pm
GilaMonster (12/29/2010)
General recommendations are to disable the sa login completely and never use it.
Disable, or delete? (And create another login with same permissions for cases where you need it.)
June 17, 2016 at 3:49 pm
Sarab_SQLGeek (8/8/2009)
by opting this you are actually applying group policy of OS to...
June 17, 2016 at 2:29 pm
I agree completely with the editorial. Unfortunately I'm in a job where I wear so many hats that interruptions always seem to be about 3 (or more) deep (depending whether...
October 30, 2015 at 10:41 am
jelias 69485 (4/1/2015)
April 1, 2015 at 12:02 pm
OK, shortly after my earlier post, I discovered the USE-inside-stored-procedure issue did indeed occur elsewhere -- in script 7. Here the solution isn't quite as simple, because EXEC sp_updatestats doesn't...
February 20, 2015 at 11:18 am
Great post, and I learned a few things -- like updating usage and statistics. Since reading this I've determined that my SQL Server 2000 DBs have many usage discrepancies, which...
February 18, 2015 at 3:27 pm
All right, it's egg-on-face time. When I said I gave the new group "every permission in the book," I didn't notice that two of those "permissions" were db_denydatareader and db_denydatawriter....
February 16, 2015 at 2:54 pm
Viewing 15 posts - 1 through 15 (of 135 total)