2011-11-03 (first published: 2011-10-21)
1,607 reads
remote servers
Introducing PowerShell V2 Remoting for SQL Server
owerShell can be used to for many SQL administrative tasks; this tip walks through how to run T-SQL code and admin tasks on remote servers.
2011-09-13
3,153 reads
RE: Index for column with a lot of Null
CREATE TABLE [dbo].[CheckQueue] ( [CheckQueueKey] [int] IDENTITY (1, 1) NOT NULL , [AppUser] [int] NULL , [CmdCodeKey] [smallint] NOT NULL , [CustomerKey] [int] NULL , [RequestDate] [datetime] NOT NULL , [ResponseDate] [datetime] NULL , [CheckQueueCodeKey] [smallint] NULL , [WebCustomerKey] [int] NULL , [ProductKey] [smallint] NULL , [PIN] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [SerialNbr] [varchar] […]
2003-08-28
RE: BCP Utility
Hi Phill, Yes, I did try creating and using a format file to bcp in and out. Still got the same result going in, and bcp out, the money columns came out as garbled characters instead of numbers. In the end I did end up linking to SQL Server 2000 and using DTS. I agree […]
2003-08-28
RE: Store Excel , Word, Image documents in SQL server
Hi chitra, quote: How can I store Excel / word / Image documents in SQL server 2000. The files exists on the NT server. What should be the front end to browse the files and capture into the SQL server database. The front end given to the users is the I.E using ASP. Pl. guide. […]
2003-08-21
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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