Comments
Sort by recent activity
Another possibility is that where a foreign key relationship exists back to a reference set, hyperlink the column name back to the reference set. / comments
Another possibility is that where a foreign key relationship exists back to a reference set, hyperlink the column name back to the reference set.
I've been writing for SQLServerCentral fora long time but have never spoken at an event. Although it is out of my comfort zone I should like to try it but don't know where or how to start. The only presentations I have given have been internal presentations. / comments
I've been writing for SQLServerCentral fora long time but have never spoken at an event. Although it is out of my comfort zone I should like to try it but don't know where or how to start. The on...
I've been a bit quiet this year.
One article on Simple Talk.
Two articles on SQLServerCentral
One article currently in flight with regard to the Data Catalog
One article idea currently working on for SQLDoc
Feedback session with the Data Catalog team
/ comments
I've been a bit quiet this year.
One article on Simple Talk.
Two articles on SQLServerCentral
One article currently in flight with regard to the Data Catalog
One article idea currently working on...
Had an interesting telephone conversation with the guys. Hope they found it useful / comments
Had an interesting telephone conversation with the guys. Hope they found it useful
The flawed implementation of the idea was to have a one-stop shop for building a server and database to the point where it could be used for development and unit testing. The intent was for data used for reference and application configuration would reside in there. The problem came from three sources.
Not understanding the data model fully. It's a undocumented system riddled with tech debt. This led to more data than was anticipated being included for one particular table.
Not fully understanding the limitations of source control
Organisational inertia. We used the tools we had available. When all you have is a hammer.......
/ comments
The flawed implementation of the idea was to have a one-stop shop for building a server and database to the point where it could be used for development and unit testing. The intent was for data u...
We considered AWS S3 for the larger data sets. Azure blob storage and Google cloud storage. The consideration for us is that there is deliberate separation of environments (DEV, TEST, UAT, PROD) explicitly to stop PROD data permeating down through the environments. Realistically data in DEV environments is only to allow basic development so versioning of the data is not a requirement for us. / comments
We considered AWS S3 for the larger data sets. Azure blob storage and Google cloud storage. The consideration for us is that there is deliberate separation of environments (DEV, TEST, UAT, PROD) ...
Hi @gbargsley I don't write as much as I used to due to time and other commitments. I've written mainly for SQLServerCentral. I got ideas from a number of places
Exploring solutions to questions posted on StackOverFlow
Reading a number of articles to find out about a subject and finding the answers I was looking for were either missing or sparsely explained.
Things I was doing at work that I thought might be interesting to the community
Things I was learning in my own time.
Reviews of products or books
Discussions with colleagues that generated more questions than answers
How to use 3rd party tools (such as Redgate SQL Generator) in unusual ways or perhaps ways in which the vendor hadn't thought of.
If you have an idea, write down absolutely everything you think of without trying to edit it. It's know as the Disney technique
Phase one is just to get your ideas recorded.
Phase two is to critique what you have written and discard the bits that won't work or don't fit.
Phase three is to refine and polish what is left.
It is normal to discard 70%+ of what you write. / comments
Hi @gbargsley I don't write as much as I used to due to time and other commitments. I've written mainly for SQLServerCentral. I got ideas from a number of places
Exploring solutions to questions ...
I'm writing something for SQLServerCentral that uses work I did with Soundex type algorithms and SQLCLR to enhance full text search. After that I've promised Tony Davis to write something to hook SQLMonitor to security metrics. Last year I was inspired by Redgate SQL Source Control to build a mechanism to place a non-Microsoft distributed column store called Vertica under source control. When you see something done it gives you a "Why didn't I think of that?" moment. My colleagues and I have been working to get the mechanism Dockerised and implement a deployment pipeline. We wouldn't have got this far or been so successful if we hadn't seen the way that Redgate does it for SQL Server. / comments
I'm writing something for SQLServerCentral that uses work I did with Soundex type algorithms and SQLCLR to enhance full text search. After that I've promised Tony Davis to write something to hook ...
I've stuck one in for SQLPrompt. Of all the tools this is the one I miss most. For code consistency, readability and quality code at speed it is hard to beat. / comments
I've stuck one in for SQLPrompt. Of all the tools this is the one I miss most. For code consistency, readability and quality code at speed it is hard to beat.
Thanks Steve, I was thinking more on the lines of the pre-canned patterns under the headings
Personal
Geographical
Shopping
Payment
I have the full list now and am using it to build my POC.
The POC is to use Red-Gate data generator to populate SQL2017 Express on Linux as a component to provide test data for other non-Microsoft systems. / comments
Thanks Steve, I was thinking more on the lines of the pre-canned patterns under the headings
Personal
Geographical
Shopping
Payment
I have the full list now and am using it to build my POC.
The ...