Viewing 15 posts - 31 through 45 (of 137 total)
You could do this is SSIS, and you wouldn't have to rely on a linked server. Use a Foreach Loop Container to loop thru all of the tables, and pick...
March 26, 2015 at 8:31 am
If those queries interfere with maintenance plans, backups, and warehouse fill jobs, then you should make your management aware of that fact. All three are important your customer base in...
February 12, 2015 at 2:09 pm
The first thing I would want is an inventory of the servers I am supposed to support. This could be as simple as a spreadsheet, an inventory database, or access...
February 12, 2015 at 8:29 am
For our backup jobs, we use a cursor to loop thru a list of databases (no problem with cursors here, since the backup commands run in sequence anyway). You could...
February 6, 2015 at 9:42 am
Gary Varga (2/5/2015)
Andy Warren (2/5/2015)
February 5, 2015 at 9:37 am
One additional thing to consider regarding cost. it is true that SQL Server gives you extras such as SSAS and SSRS for 'free'. But you still need to license the...
January 8, 2015 at 2:39 pm
One thing that could be a huge factor is licensing.
January 8, 2015 at 9:41 am
Um, shouldn't the CEO and his son in-law abide by the company's standards and procedures? I mean, pretty much anybody else would get fired for keeping that much personal stuff...
December 24, 2014 at 9:51 am
Steve, there is actually a good deal of data that does get deleted. Any company's retention policy also includes when the data gets deleted. It is highly desirable to do...
December 18, 2014 at 12:41 pm
Try looking on Indeed.com or Dice.com and see what rates companies are offering in their postings in your target area.
August 18, 2014 at 2:08 pm
Most importantly, coordinate your DR plan with the application side. Maybe your database server crashes and you want to fail over to the DR site, but the application server is...
August 15, 2014 at 8:52 am
Regarding the question of links to articles, etc., put those links in your LinkedIn profile, and put the profile in the top section of your resume.
August 1, 2014 at 8:44 am
Here are a couple of somewhat kludgy things you could do, which might be enough, depending on your overall requirements.
The first is set up replication, and then copy the data...
July 14, 2014 at 9:54 am
That is one way to distinguish between a good place to work and a bad one. In a well run shop, everybody's contribution is appreciated. In a bad shop, recognition...
July 11, 2014 at 9:42 am
From the software side, this reminds me of Windows 8. My notebook computer came with 8.0, and I have gone thru 8.1 and the 8.1 update. My Dell Venue 8...
July 7, 2014 at 10:55 am
Viewing 15 posts - 31 through 45 (of 137 total)