Why should SQL Server 2019 excite developers?
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
Phil Factor
Microservice Reality
Phil Factor argues that very few processes, even in well-established businesses, mimic the dreamy clarity and autonomy of a microservice.
A Capital Error
It’s not the zero’th time Phil Factor has complained about the madness of a binary collation.
Where’s that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
The Wild Developers of SQL Server like Wildcards
Phil Factor explains the enduring attachment of database developers to wildcards, despite their current deficiencies.
Data with Provenance
File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.
Naming Conventions for SQL Server Objects
Phil Factor feels that as a community we can do more to help people who are wrestling with SQL coding standards.
‘Comedy Limited’ with SQL Server
Phil Factor is not amused by SQL Server’s handling of the comma-separated value (CSV) file format.
The TSB disaster: Where were the grown-ups?
Phil Factor describes how TSB performed a major public disservice with micrsoservices.
Blogs
Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
Lengthen a Primary Key–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Setup SQL Server Alert to get automatically notified of database blockings
By SQLPals
Suppose you want to or need to know anytime your SQL Server is experiencing...
Forums
Protecting Data Between Services
Comments posted to this topic are about the item Protecting Data Between Services
SQL browser and port number
We have several new servers running SQL 2014. Some servers are single instance servers...
ssms crashes when editing .sql script
I’ve recently been having an issue with ssms freezing and crashing while editing a...
Ask SSC