Viewing 15 posts - 2,326 through 2,340 (of 6,041 total)
Talking about users creating databases, I assume we're really just talking about the development envrironment here, and when it comes time to deploy to production, you can adust the file...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 1, 2016 at 6:49 am
I've never used it, but there is this Enterprise feature called 'Policy Based Management' whereby you can setup rules that govern things like server and database settings or even object...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 31, 2016 at 12:01 pm
Sean Lange (8/31/2016)
Eric M Russell (8/30/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 31, 2016 at 9:32 am
There are no dumb questions, only dumb decisions. Whoever designed the MSDB job activity tables didn't make the temporal columns as user friendly as they could be.
Here are a couple...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 31, 2016 at 9:00 am
webrunner (8/31/2016)
Eric M Russell (8/29/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 31, 2016 at 8:38 am
Unless you're using a 3rd party product like Melissa, then attempting to auto-magically identify and recode mistyped company names is probably beyond the level of effort you would be willing...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 31, 2016 at 7:45 am
The SOUNDEX hashing function is primitive and will result in many false matches when comparing strings of multiple words, even if they are very dissimilar. Basically, it retains the first...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 30, 2016 at 1:45 pm
I would say that's generally true. SQL Server, or relational database engines in general, are ideal for applications where the entities are normalized tables and data access patterns are predefined....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 30, 2016 at 12:41 pm
SQL_Student (8/30/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 30, 2016 at 8:41 am
We're perhaps just kicking a dead horse. I still freshly remember this topic when it was originally published four years ago, and it has come up again numerous times long...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 30, 2016 at 8:04 am
Define "better".
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 29, 2016 at 8:00 am
Azure SQL and SQL Server 2016 also have a new feature called Always Encrypted, which in a nutshell is a combination of TDE and transparent column level encryption where the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 29, 2016 at 7:58 am
You'll need to create this database on another instance for which you are the only SYSADMIN. Also, you'll need to enable transparent database encryption (TDE) on this database to prevent...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 29, 2016 at 7:48 am
MMartin1 (8/26/2016)
I guess things like this happen when there is no effort to learn what the other roles are, like ddl admin.
But you probably know that db_ddbadmin will grant them...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 26, 2016 at 2:37 pm
Granting developers and other users membership in the SYSADMIN role is like planting a Tree Of Good And Evil in the middle of the Garden If Eden and then commanding...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 26, 2016 at 2:24 pm
Viewing 15 posts - 2,326 through 2,340 (of 6,041 total)