Pulling Together
When a co-worker is ill, what should the rest of the office do? How do you handle absences that might extend for weeks or months. Steve Jones comments on the responsibilities of the team.
Pulling Together
When a co-worker is ill, what should the rest of the office do? How do you handle absences that might extend for weeks or months. Steve Jones comments on the responsibilities of the team.
A Good Case For Reference
Steve Jones is looking for some interesting application ideas using SQL Server that can help teach people how to take advantage of features.
Bread and Butter of SQL Server DBA - Part 1
We have a new author at SQLServerCentral.com, Muthusamy Anantha Kumar AKA The MAK, who starts a new series on the basics that a DBA needs to know. This installment walks over basic backup and restore.
DML Trigger Status Alerts
When databases suddenly stop working, it can be for a number of different reasons. Human error plays a large part, of course, and the DBA needs to know what these various humans are up to. DDL triggers can help alert the DBA to unauthorized tampering with a production system, of course, but DDL triggers can't tell you everything. At some point, you will need to implement your own checks. Randy certainly reached that point!
Untouched Data
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
Untouched Data
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
Untouched Data
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
Using NOLOCK and READPAST table hints in SQL Server
Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server
Five Free Hours of Training
We're sponsoring over 5 hours over 5 days of training on SSIS and Business Intelligence with Brian Knight, SQL Server MVP and founder of Pragmatic Works.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers