Georg Ferdinand Ludwig Philipp Cantor is considered the creator of set theory, and his theories are the basis for the naïve set theory you learned in school. But there are lots of other mathematicians you should know, such as Hilbert, Frege, Russell, Zermelo and Dedekind. They made a lot of contributions, too. Hilbert Hilbert is […]
2021-01-19
5,274 reads
How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variables would be named based on the current theme. One of his programs […]
2021-01-11
1,599 reads
In Part 1 we presented some foundation knowledge with which to debunk misconceptions lurking in the "data models" mess in the industry that Friesendal has tried to catalog. In...
2019-05-04
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
2019-05-04
339 reads
"How do I restore a SQL Server backup to a previous version of SQL Server?" is a commonly-asked question. The answer, of course, is you don't - but if you must, there may be some solutions.
2019-05-03
There is a lot of confusion when it comes to designing tables in SQL Server around whether to pluralize names or not. How do you choose whether to pluralize or not?
2019-05-03
While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.
2019-05-02
In Part 1 we presented some foundation knowledge with which to debunk misconceptions lurking in the industry's modeling mess that Friesendal has tried to map, and to show how...
2019-04-22
Steve notes that many of us might not completely understand every part of our database, but it's information that can be helpful in cleaning out unnecessary entities.
2019-04-10
519 reads
What’s a good natural key? This is a very difficult question for most entities when you design your schema. In some rare cases, there seems to be an “obvious” candidate, such as a variety of ISO standards.
2019-04-05
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...
By James Serra
Microsoft has a ton of data platform-related products, but there are certain areas where...
Hi, I come across this once in a while, I have a column header...
We have this ad hoc query that is a recurring block leader, blocking dozens...
I am working with Microsoft SQL Server MANAGMENT STUDIO 18 and i Have 2...
Ask SSC