PowerShell Solutions - Working with files
When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.
2016-10-04
2,822 reads
copy
Generate row constructors for existing data
Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard
2013-11-14 (first published: 2013-10-31)
1,165 reads
RE: Temporary Network
To use a name you need to ask your network admins to create a record foryour server on DNS server. I also tested creating a DNS alias which is not a machine name but a nice name. We usually use DNS aliases for the Web, but it works fine with SQL ServerYelena
2004-11-19
Distributed Transaction - OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator.
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-11-11
RE: Migrating SQL Server Jobs
There is a DTS task in SQL2000 to transfer jobs. The source can be a SQL 7 server and you can select the specific jobs you want to transfer.
2004-03-03
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers