Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.
References and information on the Live Query Statistics feature in SQL Server 2016.
This document describes the process to provision a SQL Azure server manually. While it is expected that most servers will be provisioned using automation, DBA's must have the skills and know the process to perform the same provisioning manually.
Steve Jones has a story about what it's like to work with, and without, Version Control Systems.
Of course it seems a great idea to have your application on all the main mobile platforms as well as on the desktop. However, as Arkadiusz Pachucy knows all too well, this can ultimately leave you with a full-scale maintenance nightmare. In this article he looks at whether technologies like PhoneGap/Cordova or Adobe Air could be the perfect compromise - and if so, what frameworks to use.
How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
In the past, working in .NET for non-Windows platforms has been dependent on third-party frameworks like Mono. Now, with VS2015 and DNX Microsoft have stepped up to provide everything you need to code multi-platform apps straight out of the box. Clive Tong introduces this new .NET technology.
Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers