Databases

Top 50+ Tech Influencers and Thought Leaders You Should Follow

Today’s technology is growing at an extraordinary pace, so it is important to follow industry influencers and thought leaders to stay in the loop and learn new trends and best practices. Keeping on top of things in the industry is a great way to make sure you are functioning most effectively every day. We have … Read more Top 50+ Tech Influencers and Thought Leaders You Should Follow

SQL Server Performance Tuning Tips

Query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level server performance (memory, processors, and so on) improvement measures are ineffective and expensive. Expert developers believe most performance issues can be traced to poorly written queries & inefficient indexing, not hardware constraints. In fact, some performance issues can only be … Read more SQL Server Performance Tuning Tips

SQL and Database Performance Tuning Guide and Checklist: Expert Tips

A Database Administrator (DBA) is like a racecar technician. Building and optimizing a high-performance vehicle requires minuscule fine-tuning and attention to detail. A tweak here and an adjustment there could shave just a fraction of a second from your lap time. Of course, that fraction of a second could determine whether you win or lose … Read more SQL and Database Performance Tuning Guide and Checklist: Expert Tips

What Happened to Logical Data Models (LDM)?

In a recent blog post entitled Is Logical Data Modeling Dead?, Karen Lopez (b | t) comments on the trends in the data modeling discipline and shares her own processes and preferences for logical data modeling (LDM). Her key point is that LDMs are on the decline primarily because they (and their creators) have failed to adapt to changing development … Read more What Happened to Logical Data Models (LDM)?

Subjectivity: Naming Standards

Naming conventions are a very subjective thing, of course. Just like coding styles, they can often lead to anything from minor debates to full-blown religious arguments. Upper case vs. lower case keywords, tabs vs. spaces, and where to put commas come to mind. Heck, these same people even get into sub-arguments about whether the terms “upper … Read more Subjectivity: Naming Standards

4 Practical Use Cases for Grouped Concatenation

Let’s forget about performance for a moment, or even user-facing processes at all. A lot of tasks are admin-related and require at least the concept of looping, if not an explicit loop or cursor (or multiple). Think about how you would do these things in T-SQL otherwise:  The search ultimately needs to check every string column in … Read more 4 Practical Use Cases for Grouped Concatenation