The Usefulness of Database Features
The features we want and get in a database platform can make our job easier or harder. Steve has a few thoughts on how they should work.
2022-02-25
119 reads
The features we want and get in a database platform can make our job easier or harder. Steve has a few thoughts on how they should work.
2022-02-25
119 reads
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
4,888 reads
In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.
2022-02-18
4,445 reads
2021-09-08
703 reads
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2021-11-26 (first published: 2019-11-04)
12,557 reads
This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.
Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.
2019-10-15 (first published: 2019-10-10)
1,288 reads
As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks
2014-09-16
6,435 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Andy Warren
I drove up to Jacksonville Friday afternoon to allow for bad traffic and immediately...
This months subject for T-SQL Tuesday was Your first technical job. I have to...
I hate to be a pain, but I am a beginner at this and...
Hi All, I am trying to figure out if it is possible to...
Hi all, as the title says, I'm interviewing for a job as a SQL...