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
Create
2009-09-24 (first published: 2009-09-15)
683 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: SQLServer 7.0 Query against smalldatetime
Or, don't bother with any of the conversion stuff and just: CREATE PROC dbo.GetProjects @StartDate SMALLDATETIME , @EndDate SMALLDATETIME AS BEGIN SELECT Fields -- Don't use * !!! FROM tblProjects WHERE insertedDate BETWEEN DATEDIFF(day, 0, @StartDate) AND DATEDIFF(day, 0, @EndDate) END The DATEDIFF strips the time portion of the smalldatetime/datetime field. Since DATETIME fields are […]
2003-07-28
1 reads
RE: Importing data from txt file and updating Table
A couple of extra points. 1. Do the updates before the inserts otherwise you end up updating the rows you have just inserted. 2. If you have 500K rows to process and a table of 1.7M, then you will probably have locking issues. One way round this would be to add an identity column to […]
2003-07-25
2003-06-26
1 reads
RE: DBA's tasks in general (daily, weekly or monthly)
Some additional information that might be helpful is on this web site:
2003-06-17
1 reads
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