THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 29 (285 total posts) < 1 second(s)
  • [Speaking] SQL Saturday #295 - Las Vegas

    On Saturday I'll be presenting one of my favorite sessions, Manage SQLServer Efficiently w/PowerShell Remoting, at the Las Vegas SQL Saturday.&nbsp; Here's the abstract:You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell ...
    Posted to Allen White (Weblog) by AllenMWhite on April 2, 2014
  • re: Reliably Dropping a Database in a T-SQL Script is Too Hard

    In SMO there's a Server object method called KillAllProcesses('AdventureWorks'), where you specify the database name inside the parentheses. &nbsp;If you capture the T-SQL executed when that method is called it returns the following query: SELECT DISTINCT request_session_id FROM master.sys.dm_tran_locks WHERE resource_type = 'DATABASE' AND ...
    Posted to The Bit Bucket (Greg Low): IDisposable (Weblog) by AllenMWhite on January 5, 2014
  • re: Script and Migrate Agent Jobs between Servers using PowerShell

    Iqbal, here's an article I recently wrote that'll help you.
    Posted to Allen White (Weblog) by AllenMWhite on December 28, 2013
  • The 2013 PASS Summit - Day 2

    Good morning! It's Day 2 of the PASS Summit 2013 and it should be a busy one.Douglas McDowell, EVP Finance of PASS opened up the keynote to welcome people and talked about the financial status of the organization. Last year's Business Analytics Conference left the organization $100,000 ahead, and he went on to show the overall financial health, ...
    Posted to Allen White (Weblog) by AllenMWhite on October 17, 2013
  • Speaking - Automate Your ETL Infrastructure with SSIS and PowerShell

    Today at 4:45PM EDT I'm presenting a new session using PowerShell to auto-generate SSIS packages via the BIML language.&nbsp; The really cool thing is that this session will be live broadcast on PASS TV! You can view the session by clicking on this link. &nbsp;If you have questions for me during the session, you can send them to me via Twitter ...
    Posted to Allen White (Weblog) by AllenMWhite on October 16, 2013
  • The 2013 PASS Summit - Day 1

    It's SQL Server Geek Week once again! Every year at the PASS Summit the SQL Server faithful descend on the city of choice for the annual Summit, and this year it's Charlotte, North Carolina.&nbsp; Once again I've been given the privilege of sitting at the bloggers table, so my laptop is on a table!So far this week it's been great seeing people I ...
    Posted to Allen White (Weblog) by AllenMWhite on October 16, 2013
  • Fall 2013 IT/Dev Connections Sessions

    This week I had the honor of presenting two sessions at the IT/Dev Connections conference in Las Vegas.&nbsp; My two sessions were Manage SQL Server 2012 on Windows Server Core with PowerShell and Manage SQL Server Efficiently with PowerShell Remoting.&nbsp; I think both sessions went well, and the attendees indicated that they will be able to use ...
    Posted to Allen White (Weblog) by AllenMWhite on October 4, 2013
  • PASS Elections and Great Candidates

    The candidates for the PASS Board of Directors are a great group of people, and I consider each one of them friends. Each one of them, if elected, will do a great job bringing their talent and experience to the task of leading this organization that has helped all of us become better at everything surrounding SQL Server.&nbsp; There are two ...
    Posted to Allen White (Weblog) by AllenMWhite on September 24, 2013
  • re: Tech Ed Demos for "Manage SQL Server System and Performance Data with PowerShell"

    The $srv parameter you supply on the command line connects to the Windows Server and finds all SQL Server instances running on that machine. The testing I've done with multiple servers involved changing the script to supply a list of server names. It's better to just run one per machine, per my earlier comment.
    Posted to Allen White (Weblog) by AllenMWhite on August 30, 2013
  • re: Tech Ed Demos for "Manage SQL Server System and Performance Data with PowerShell"

    Thanks, Rob. You can run the script against a remote server. I've found that it's fine for up to about three servers, but gets bogged down beyond that. I generally just run it on each server, sending the data to a central database for reporting. (I put it in an Agent job that starts automatically whenever SQL Server is restarted.)
    Posted to Allen White (Weblog) by AllenMWhite on August 30, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement