It's so hard using SSMS then switching back to snowsight. Snowsight is just so far behind. We unfortunately use snowflake dynamic tables (don't use them by the way, they perform...

• This reply was modified 1 month, 3 weeks ago by  bnordberg.

What about something like posted here

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/

Assuming you have sql server 2012, you could use sys.dm_server_registry

See how to use it here:

https://msdn.microsoft.com/en-us/library/hh204561.aspx

So something like (I have no alias's to test!, but you get the idea):

SELECT...

My only recommendation, assuming you are using SQL 2012, would be to use a CONCAT(@tableHTML1, @tableHTML2) instead of:

= @tableHTML1 + @tableHTML2;

Because if one of the tables is null,...

Using SQL Agent to do this would be better as it typically already has elevated permissions.

Let it do the restore, then have it just grant the needed permissions (read, write,...

what concerns me is how hospitals interpret HIPAA to slow access to patients medical records. we requested my wife's records well over a year ago and have not formally received...

I could not agree more.

However isn't this the same concept being used for "Big Data" .

Every presentation I see about big data (aside from hadoop), seems to look just like...

I'd like to add one of my pet peeves.

I get lots of resumes, that have a skills section. In this section, the list all the languages they know and...

Are you using a different installer than the one used for the VS install? You may have to do a full uninstall of VS, then do a selective re-install.

If you are restoring to a different server - remember logins are held in Master, so if your not restoring Master as well, those logins will not exist.

We use informatica. Oracle really does not have a built in tool similiar to SSIS. Sure there is the SQL Loader - that only the script junkies use. Most Oracle...

I've had ok luck with the OTN. I've posted a few things there, just don't mention that you prefer SQL Server and Oracle sucks - for some reason they don't...

We run 128 GB on our big DW SQL server

I forgot to mention - data loss from contractors http://thehill.com/blogs/hillicon-valley/technology/97817-va-loses-another-laptop-with-veterans-personal-information

Some of our contractors use Macs for the sole purpose that we cannot lock down USB ports...

I work in Research at the Veterans Admin Hospital. It is very hard to convert research $$ to IT dollars - as they are congressionally split. So we end up...