2019-11-16
7 reads
2019-11-16
3 reads
Links and Resources from “How to Architect Successful Database Changes”
Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group...
2019-11-06
4 reads
2019-11-06
1 reads
2019-11-06
3 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
1 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
3 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
3 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
1 reads
T-SQL query to copy data from one database to another database
T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in...
2019-10-30
4 reads
Blogs
Daily Coping 18 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
I’ve added a new parameter to my permissions scripts (well, just the main two...
Creating TAIL on Windows for Text Files
By Steve Jones
UPDATE: Article changed based on the comment from Mr. Sewell. I wrote recently about...
Forums
Select Statement with two extra column headers
I have the following Select statement that exports data from a Horizon View SQL...
Dataset as source for another dataset
I have been working with SQL for almost 20 years, but I’m somewhat of...
Ask SSC