12 June 2009
New Manageability White Papers for SQL Server 2008
TechNet Books Online just published three whitepapers - check them out! SQL Server 2008 Management Data Warehouse: http://msdn.microsoft.com/en-us/library/dd939169.aspx SQL Server 2008 Policy-Based Management: http://msdn.microsoft.com/en-us/library/dd938891.aspx Read More...
0 Comments
 
15 May 2009
DAT315 – Session Review for SSMS Tips & Tricks Session
One of the attendees of my TechEd session “DAT315 - Manageability Series: Uncover Hidden Secrets of T-SQL Scripts with Microsoft SQL Server Management Studio” suggested that I post the list of demos that I did for the session so that they could remember Read More...
1 Comments
 
13 May 2009
PowerShell Script Examples from DAT314
I’d like to thank everyone who attended my TechEd session today titled “Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support”. Sean McCown – SQL MVP – and all around DBA – creator of the Midnight DBA videos available Read More...
1 Comments
 
10 May 2009
Welcome to TechEd 2009
This is my first TechEd in a long time. The last time I spoke at a TechEd was back in 1997 in Japan! I have three sessions this Tuesday, Wednesday, and Thursday that talk about how to get the most out of our manageability suite of tools in SSMS.  Read More...
1 Comments
 
06 May 2009
SQLPSX from Chad Miller
I’ve been playing around Chad Miller’s SQL Server PowerShell Extensions – SQLPSX 1.5 on CodePlex getting ready for my TechEd session Manageability Series: Microsoft SQL Server Automation on Steroids, Including Powershell on Wed 5/13. Chad has developed Read More...
1 Comments
 
12 April 2009
Transact-SQL Debugger for SQL Server 2008 – Part 3
In part 3 of working with the debugger, I’ll talk about how to set breakpoints and the trick to setting them in stored procedures and triggers. This 3 part series covers: Basic debugging Configure remote debugging & best practices Debugging triggers Read More...
2 Comments
Filed under: ,
 
11 April 2009
Transact-SQL Debugger for SQL Server 2008 – Part 2
This blog will go over what you need to know for setting up your environment for remote debugging along with best practices and other things to consider when using the debugger in SSMS. This 3 part series covers: Basic debugging Configure remote debugging Read More...
4 Comments
Filed under: ,
 
11 April 2009
Transact-SQL Debugger for SQL Server 2008 – Part 1
In my next series of blog posts, I’ll explore the Transact-SQL Debugger for SQL Server 2008. This feature only works against database instances of SQL Server 2008. If you need to use a debugger for SQL Server 2005, you’ll have to use the Visual Studio Read More...
6 Comments
Filed under: ,
 
10 April 2009
SQL Server Management Studio Tips – Part 4
This is the fourth in a series of posts highlighting Scott Cate ’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog . As I mentioned in Part 1 , many of the commands are documented in the  SQL Server 2008 help topic Read More...
1 Comments
Filed under:
 
09 April 2009
SQL Server Management Studio Tips – Part 3
This is the third in a series of posts highlighting Scott Cate ’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog . As I mentioned in Part 1 , many of the commands are documented in the SQL Server 2008 help topic – Read More...
1 Comments
Filed under:
 
08 April 2009
SQL Server Management Studio Tips – Part 2
This is the second in a series of posts highlighting Scott Cate ’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog . As I mentioned in Part 1 , many of the commands are documented in the  SQL Server 2008 help topic Read More...
2 Comments
Filed under:
 
08 April 2009
SQL Server Management Studio Tips – Part 1
Scott Cate has been publishing a video series of Visual Studio tricks over the last few months from Sara Ford’s blog . It turns out when you use the Standard keyboard scheme in SSMS under Tools | Options Keyboard, many of them work because SSMS is built Read More...
5 Comments
Filed under:
 
30 March 2009
SQL Server Agent and Database Mail – Better Together
This post is how to configure SQL Agent to use Database Mail for sending an email to an operator in the event a job fails. I was hoping that there was a single MSDN topic on how to do this, but no such luck. The steps are fairly straight forward, but Read More...
1 Comments
Filed under: ,
 
29 March 2009
Using Live/Hotmail/MSN for SQL Server 2008 Database Mail
Over the weekend, I was playing around with trying to use my hotmail email account for SQL Server 2008 Database Mail. After searching, I found a promising post on the MSDN Forum under SQL Tools . In the forum posted, it was suggested that you need to Read More...
2 Comments
Filed under:
 
26 March 2009
Database Manager for IIS 7 RC Preview
I recently had a chance to preview the Release Candidate of Database Manager 1.0 for IIS7 . If you are looking for a very lightweight tool that is easy to install for doing basic operations against SQL Server used by your IIS applications, this tool is Read More...
2 Comments
 
More Posts Next page »
Page view tracker