Do you find yourself managing lots of SQL Server instances? If so you might find you are connected to many different instances and have numerous query windows open that are connected to different instances. When you have lots of query windows open, do you sometimes find it confusing to know the instance in which your query window is connected? Color-coding your connections can help you manage complicated setups.
On Thursday October 20th, MVP Louis Davidson will discuss the why normalized databases are the most important part of query tuning.
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
The mix of hardware and feature limits in SQL Server varies by edition. Steve Jones thinks it should be simplified to only matter for hardware and scale, not features.
Receive-Side Scaling (RSS) was introduced in Windows 2003 to improve Windows scalability to handle heavy network traffic, which is typically the case for SQL Server OLTP workload. This post helps you get the most out of the feature.
This challenge invites you to identify the largest sequence of alphabets from a string.
Unlike the hierarchical database model, which created a tree structure in which to store data, the network model formed a generalized 'graph' structure that describes the relationships between the nodes. Nowadays, the relational model is used to solve the problems for which the network model was created, but the old 'network' solutions are still being implemented by programmers, even when they are less effective.
Do you need to setup a SQL Server development environment in short order? Are you familiar with the options available? Are they all laborious? Are you facing security and data privacy issues? Do you have sufficient storage? Attend this information-packed session to learn about the best ways to build, manage and protect your sandbox development environment.
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers