Viewing 15 posts - 2,431 through 2,445 (of 6,038 total)
I use 1Password as my password manager. However, for the logins I don't actually enter the complete password but will instead obfuscate a common prefix. For example, if the actual...
August 2, 2016 at 10:50 am
Eric M Russell (8/1/2016)
Rod at work (8/1/2016)
August 2, 2016 at 8:10 am
Rather than attempting to hack SSMS Object Explorer, maybe there is a SSMS add-in alternative that work in the way you want. Some people like to use RedGate SQL Search...
August 1, 2016 at 1:05 pm
Maybe local user SQL Server groups should organize van pools for out-of-town SQL Saturday events. Not only would it help mitigate the expense of travel, but it would event even...
August 1, 2016 at 9:15 am
2016 can potentially be several orders of magnitude faster than 2008, if you also want to invest in re-architecting your database to leverage things like Clustered ColumnStore, In-Memory OLTP, or...
August 1, 2016 at 9:10 am
Rod at work (8/1/2016)
August 1, 2016 at 9:04 am
If the wifi isn't secured with encryption, then it doesn't matter whether authentication is via password, fob, or biometrics. Hackers can steal the credentials or token in mid-flight.
August 1, 2016 at 8:45 am
If we're talking about narrowing down the Object Explorer to only those objects I want to work with, then I typcially use Filter Settings for that, because the objects and...
July 29, 2016 at 9:10 am
The SQL Saturday event I attend yearly here in Atlanta is close enough to my home I could theoretically ride my bike. There are about three or four other events...
July 29, 2016 at 9:04 am
You can setup an SQL Audit trace on DDL events.
Also you can have a job scheduled to periodically monitor query for modified objects and fire off an email alert in...
July 28, 2016 at 6:55 am
Back in '90s I developed and maintained FoxPro applications, which was then using the same client / file server model perpetuated by MS Access today. Things like network bandwidth, concurrency,...
July 28, 2016 at 6:43 am
Good topic, and you have also written in a style that's accessible and relevent not just for data professionals but also for non-technical team members and stake holders. Lack of...
July 28, 2016 at 6:26 am
GilaMonster (7/27/2016)
Eric M Russell (7/26/2016)
Rod at work (7/26/2016)
July 27, 2016 at 9:04 am
Auto formatted code can look a bit dry. If you think it's worth spending a little money on genuine hand crafted SQL formatting (with all the little ticks and imperfections...
July 26, 2016 at 1:38 pm
Rod at work (7/26/2016)
July 26, 2016 at 11:31 am
Viewing 15 posts - 2,431 through 2,445 (of 6,038 total)