Showing tag results for SQL Server

Summary: Learn how to use Windows PowerShell to automatically create Tempdb files in your SQL Server instance.   Hey, Scripting Guy! How can I easily create multiple tempdb data files in my SQL Server instance? —WM Hello WM, Microsoft Scripting Guy, Ed Wilson, is here. What a great week of SQL guest bloggers, and we have Michael Wells h...

Summary: Quit using deprecated JET drivers to talk to Microsoft Access and Excel. Learn how to use Windows PowerShell and ACE Drivers.   Hey, Scripting Guy! How do I get data out of Microsoft Access and Excel files and into SQL Server by using Windows PowerShell? —MC Hello MC, Microsoft Scripting Guy, Ed Wilson, is here. We are at the c...

Summary: Learn how to use Windows PowerShell to perform SQL Server data mining. Microsoft Scripting Guy, Ed Wilson, is here. Today I continue the week about SQL in honor of next week’s SQLRally in Orlando. I have the honor of introducing Mark Tabladillo, who will talk to us about data mining. Mark Tabladillo Ph.D. is a business intelligenc...

Summary: Learn how to use Windows PowerShell to automatically email a report on SQL Server backup status. Hey, Scripting Guy! —CN Hello CN, Microsoft Scripting Guy, Ed Wilson, here. The time is near for SQLRally in Orlando. I will be making a presentation about Windows PowerShell and I wanted to support the rally. I thought the best way to...

    Summary: Learn how to use Windows PowerShell to document your Microsoft SQL Server database   Hey, Scripting Guy!  Is it possible to use Windows PowerShell to document my Microsoft SQL Server database? -- CR   Hello CR, Microsoft Scripting Guy Ed Wilson here. Welcome to day three of guest blogger week as it bring...