Kathi Kellenberger explains how to avoid build problems, when working with set of inter-dependent databases, by restoring or provisioning copies of all required databases to the development, build, or test instance.
When I decided to switch careers about 25 years ago, I had no idea how far I would go in tech. I just wanted to leave the profession for which I had trained and become a developer. My goal was to make the switch by the end of 1998. It actually happened in the summer […]
A look at SQL-On-Hadoop systems like PolyBase, Hive, Spark SQL in the context Distributed Computing Principles and new Big Data system design approach like the Lambda Architecture.
Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
What if you have several people in the team who are responsible for data security across your databases, and they need to work together to develop and maintain the data masking configurations, which must then be applied consistently as part of an automated provisioning process? How should they do it? The solution turns out to be simple: source control.
There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.
In this tip we look at some examples of how to get started with creating, modifying and deleting SQL Server stored procedures.
Phil Factor demonstrates why SQL Prompt has a 'Best Practice' rule (BP010) that checks for use of the @@IDENTITY function, and suggests less error-prone ways to get the latest identity values used in a table.
When we started SQLServerCentral, there were originally 7 of us. We all decided to "invest" $50 to get the site going. With this seed money, we paid for a VM that hosted both SQL Server and IIS. This was enough money to run the site for 6+ months, and we set about building an online […]
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
We want to setup a gateway db to host stored procedures which use tables...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers