Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.
What's the best driver for your server? What's the best of anything? Steve Jones talks about how the experts determine this, and why there is no easy answer.
I am aware of the WITH ENCRYPTION clause that is used to encrypt the code for objects like views, stored procedures and functions. It sort of fulfills my purpose and is easy to implement, but it does not cover all SQL Server objects. In this tip we look at another option to restrict users from viewing the definition/code of any SQL Server object.
How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How should lists be lined up? SQL is one of those languages that will execute anyway however you treat whitespace and capitalization. However, the way SQL is laid out will effect its readability and the time taken to review and understand it. Standardisation of code layout is an important issue, but what standard should you adopt? Rob avoids a direct answer, but tells you the sort of answers you'll need to decide upon when creating a strategy for formatting SQL code.
What's the best driver for your server? What's the best of anything? Steve Jones talks about how the experts determine this, and why there is no easy answer.
What's the best driver for your server? What's the best of anything? Steve Jones talks about how the experts determine this, and why there is no easy answer.
Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.
Rodney Landrum has lived through several simulated emergencies and one real one, in the form of Hurricane Ivan. The tests do not adequately prepare you for the real thing. Real emergencies bring tension, exhaustion and hunger pangs. Simulations bring lethargy, pre-determined end times, and warm pizza.
It's a holiday in the US and Steve Jones takes a day off with a blooper reel for the editorial.
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers