(Emil Drkusic) In the previous article, we talked about the primary key (PK). In this one, we’ll check what is the foreign key (FK) and how it’s related to the primary key. This is the final step, after creating tables, inserting data, and defining primary keys, to cover all basics related to the da
Tag: sql server
(Atul Gaikwad) While working on a new production server, somehow a database was changed to single user mode and we were not notified until the application team informed us that they were not able to connect to the database and were getting errors.
(Pinal Dave) With the release of SQL Server 2019, there were enhancements that are known and talked about. There are few minor changes in SQL Server Configuration Manager which were un-noticed.
(Aleksejs Kozmins) In a big SQL Server data warehouse project, I had to provide an SQL Server Integration Services (SSIS) based ETL process to store historical data. The ETL flow is shown below.
(Jason Brimhall) Your success as a DBA is directly relational to your ability to ensure proper Database backups are occurring. There is a whole slew of considerations that go into effect when discussing what a proper Database backup actually is.
(Marcin Policht) Practically every SQL Server Database Administrator operating in an on-premises environment is familiar with Transact-SQL DBCC statements that serve the role of Database Console Commands.
(Pinal Dave) Learning never stops with SQL Server. In this blog, we would find new ways to find information. In this blog, we would see the current setting of instant file initialization and how to make the modification.
(Kenneth Igiri) With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still available.
(blobeater) This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure SQL DB.
(Fikrat Azizov) In a previous post (Lookup activity), we discussed Lookup activity to read the content of the database tables or files. ADF also has another type of activity: Get Metadata activity, which allows reading metadata of its sources. We are going to explore the capabilities of this activit