hi arkiboys,

I can't speak for SSIS or SSRS adjustements but, there are a couple articles posted recently by Brent Ozar Unlimited that will help you with determining if the upgrade...

No problem! Glad you got everything figured out and it was a simple fix! 🙂

~Steve

hi butcherking13,

I haven't run into this issue before but, I will see if I can offer some advice. First, are you running this in a physical or virtual environment?

Max server...

Hi New Persopn,

AWE

AWE stands for Address Windowing Extension and is primarily used on 32 bit architectures. According to an article by Microsoft, "AWE should be used only when available physical...

Hi jiya.care,

In this situation (assuming you are needing a licensed copy of SQL Server and not Express), your best option is going to be core based licensing. Since you have...

Hey Tallboy,

Glad I could help! I don't have much experience with application roles, but I did find a nice article detailing some pretty in-depth information about the topic.

http://sqlmag.com/business-intelligence/mastering-application-roles

Hope...

Hi Tallboy,

I think your best solution is going to be managing security permissions through the creation of database roles:

https://msdn.microsoft.com/en-us/library/bb669058%28v=vs.110%29.aspx

The following article gives you a little more information on...

hi iapearsall,

I'm not sure I really understand what you are trying to do but, I'll give an answer a shot.

How many variations of the school name do you have?

If the...

Hey sqlfriends,

yeah, a backup and restore process may prove to be significantly faster than the SSIS package. I find myself itching to delve into that process and figure out why...

hi dschubel,

I would usually start troubleshooting an issue like this by using the "SET STATISTICS IO ON" and "SET STATISTICS TIME ON" feature in my script, turning on actual execution...

Hi sqlfriends!

I have used backup/restore operations to transfer data before and found it to work well in certain circumstances. A 6GB backup/restore should be relatively quick however, I think it's...