Do You Still Use CHAR?
When designing a database, choosing good datatypes is important, but not necessarily all the time. Today Steve wonders if you still use fixed sting data types.
2022-02-11
234 reads
Database Design and Implementation
Mathematicians and SQL
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,654 reads
Data Element Names and Scoping Rules in SQL
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
2,195 reads
Understanding Data Modeling Part 4: Fact Modeling
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
The Blast Radius of a database
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
493 reads
Downgrading A SQL Server Database To An Older Version
"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
Should I pluralize table names, is it Person, Persons, People or People?
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
Designing Highly Scalable Database Architectures
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
Understanding Data Modeling Part 2: "E/RM" and "RDM"
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
Understanding Your Database
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
564 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Alamat Kontak Bank BCA KCU TUBAN Telp:08218154393
WA:08218154393 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Alamat Kontak Bank BCA KCU PONTIANAK Telp:08218154393
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers