Viewing 15 posts - 9,406 through 9,420 (of 22,219 total)
For just learning PowerShell, I'd suggest Don Jones book, PowerShell in a Month of Lunches. It'll give you most of what you need to learn it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2013 at 8:05 am
The EPM does all the work for you. But the other stuff is documented on Microsoft. It's very easy. Yes, for more complete direct control you'll do PowerShell scripting, but...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2013 at 7:40 am
Just don't ever forget that all these types of tables from table variables, multi-statement UDF and table parameters, all of them lack statistics which can seriously, negatively, impact performance.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2013 at 6:13 am
Sure. It's a part of PBM. You can make calls from Agent. Keep reading in the documentation. PBM is great.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2013 at 6:08 am
All databases must have a transaction log, even on SQL Server 2000. Are you trying to remove a log file you are no longer using, but there will still be...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2013 at 5:50 am
If you look at Policy Based Management, it has backup monitoring built in. But there are examples online. Here's one from MSSQLTips[/url]. As far as reports goes, I'd suggest taking...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2013 at 4:45 am
A) It's difficult to get a job without experience, despite any training you have. So that's going to be a hurdle. I wouldn't mess around with SSIS because that is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2013 at 12:10 pm
According to the documentation, you have to use a table variable. That means defining the columns.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2013 at 12:06 pm
If you have a mechanism to test the backup, meaning restore it, then you could do a physical only check on the live database which is much faster. Then, you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2013 at 10:33 am
Koen Verbeeck (10/23/2013)
Beatrix Kiddo (10/23/2013)
Grant Fritchey (10/23/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2013 at 7:15 am
Beatrix Kiddo (10/23/2013)
Grant Fritchey (10/23/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2013 at 7:14 am
100% Accidental.
I mainly took the job because it paid more. Flat out. When I was offered the job, I said no... until I was told the raise that went with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2013 at 6:27 am
Just remember that upward compatibility is seldom supported. Meaning, if you install SSMS for 2005, it probably won't connect to 2008, 2008R2, 2012 or 2014. Even if it does connect,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 23, 2013 at 6:25 am
tabinsc (10/22/2013)
Thank you Steve for this article. This is something I need to do but haven't done yet. I guess writing the first one is the most difficult.
Nah,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 22, 2013 at 8:18 am
Sean Pearce (10/22/2013)
Grant Fritchey (10/22/2013)
You could look at materialized or indexed views. These are actually a separate data store that you have to update to see data changes.
Indexed views do...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 22, 2013 at 8:16 am
Viewing 15 posts - 9,406 through 9,420 (of 22,219 total)