Viewing 15 posts - 1 through 15 (of 173 total)
Just as a note, all of the data for this exact question was made available during SQL Discovery Day event for the release of SQL Server 2016.
July 29, 2016 at 8:45 am
Eric M Russell (7/11/2016)
July 20, 2016 at 2:23 pm
I'd imagine, if one was inclined to, they could use the DAC in single user mode to directly edit some of the meta sys tables in master.
July 6, 2016 at 5:01 pm
Is this a purely windows domain?
If so you could probably use something like sp_validatelogins.
May 16, 2016 at 12:13 pm
I would occasionally get an error with a SQL 7 box that would just have the Ok button and no message.
April 28, 2016 at 12:47 pm
Nope, switched to robocopy long ago.
April 22, 2016 at 9:45 am
I recently had a similar situation, and found the import-csv powershell cmdlet mixed with out-datatable/write-datatable cmdlets seemed to work the smoothest. Also easily handled parsing an array in one...
April 18, 2016 at 3:06 pm
You can script your bacpac/dacpac deployments via sqlpackage.exe and run them via cmd line.
March 29, 2016 at 10:54 am
I don't know when exactly, but somewhere between SQL 2005 and SQL 2012 SSMS...
March 10, 2016 at 4:45 pm
To gain confidence speaking I suggest starting small and with a non work related subject you really enjoy. Do you enjoy kayaking? Organize a quick presentation with your...
February 26, 2016 at 10:43 am
I'd really love to see 2 classes.
The first would be on deciding on how to consume the data. Should it be an application, a dashboard, a table dump to...
February 26, 2016 at 10:15 am
In a previous job, I inherited an environment where a developer did that as part of an automated process. Made it more difficult to track down and troubleshoot than...
February 26, 2016 at 9:22 am
Most of my coworkers make it out to the local SQL Saturday, and I regularly attend the monthly users group. It is wildly helpful. I'll probably also try...
February 26, 2016 at 9:06 am
I think the direction things are need to/are going is individualized sandboxes per application. Of course you could always use virtualbox as a staging point to evaluate things. ...
February 24, 2016 at 9:43 am
Are you sure that user doesn't have access to accounts they shouldn't?
Your environment should have some sort of IP assignment control in the domain and IP filtering in...
February 23, 2016 at 3:30 pm