SQLServerCentral Webinar #5 - Powershell and Source Control
MVP Allen White talked about how Powershell can be used to script out your database and put it in Source Control, and how SQL Source Control from
2010-11-18
499 reads
SQL Source Control
SQLServerCentral Webinar Series #5: Setup Your Source Control With Help from PowerShell
MVP Allen White shows how he can use Powershell to setup SQL Source Control from Red Gate Software on Nov 18, 2010.
2010-11-30 (first published: 2010-11-10)
1,224 reads
SQL Source Control - Q & A
After a webinar for SQL Source Control, there were a large number of questions left unanswered. All have been listed here, along with answers from the Red Gate development team.
2010-08-27
3,829 reads
RE: Can this be done without using cursor?
If # of items would vary in time, you'd never get it running with a single select statement. I think concatenation would be the rigth approach. Even if you need a full table, you could use the concatenation to create this table... Example:Create Table #Concat_Table (item_id int, rows varchar(4000))Do the concatenation in such a way […]
2005-05-26
RE: OpenXML Problem
jt-75, you are my hero!!!!! I love you!!!!! If I was a girl (and you were, or are, a boy) I'd want to have your babies!!!!!My life is complete again. My code runs like the express train it should have been and not the overnighter (or direct express as Silverlink like to call it!!) from […]
2005-05-18
CSV Rendering
I have a report which takes lot of time to render, rather the stored procedure returning the data to the report consumes good amount of time because of the number of records and conditions in the stored procedure, So what I need to implement is when the report is invoked I am displaying different rendering […]
2005-05-18
2 reads
RE: DTS error handling when server down
I have lots of dts packages like this, I use an 'Execute SQL Task' to do a select on the source table (using a single key) and only execute the truncate if it is successful.If you want to fully protect against any data loss (ie lost connection during data transformation) then Jonathan's solution of using […]
2005-04-29
RE: urgent please
insert into record0 select * from record001 where left(FirstCol, 2) = '00' AND ( agency is null or trans_id is null or ISNUMERIC(trans_id)=0 or isnumeric(accounts_trans)=0 or isnumeric(baccounts)=0 or isnumeric(daccounts)=0 or isnumeric(osa)=0 )
2005-04-29
RE: Reporting Services installation problem
Check the path for the default Data and Log files in your production server. I'm not sure where RS tries to create its databases, but I assume they should be on the server's default.It may be that the default paths on the Prod server point to an invalid folder.
2005-04-05
2005-03-31
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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