When more than one numeric SQL Server data type may be suitable for a field in a project, which data type should you choose and what are the implications for SQL Server performance?
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]
What should a good DBA do? Steve Jones came across a list he likes that showcases those things that should guide your efforts on a daily basis.
Using online accounts for license management has some advantages, Red Gate is researching how to implement this for our tools in a way that improves the experience for all involved. To say thank you for your participation, there's a chance to win a $25 Amazon certificate.
Continuous Integration and automatic builds are fantastic tools for software teams, but only if developers take responsibility for their code. Karsten Kempe explains how to use Team Foundation Server to drive better continuous integration, and walks through a simple open-source tool he built to make nightly builds more transparent, and more valuable.
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.
For many developers, does DBA really stand for Don't Bother Asking? David Poole thinks it is time to end the unnecessary conflict between developer and DBA, and explains how to deal professionally with the inevitable friction between development and operation activities in IT.
There's a new contest going on, giving you the chance to win some software, SQL training, and a vacation, all at once.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Comments posted to this topic are about the item Detecting Deadlocks Quickly
We have a SQL Server installed. We have a 500GB drive for the database....
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers