databasejournal.comDatabase Journal – Daily Database Management & Administration News and Tutorials

Database Journal – Daily Database Management & Administration News and Tutorials MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum -- » Database Journal Home » DBA Videos -- » Database Articles » Database Tutorials MS SQL Oracle DB2 MS Access MySQL » RESOURCES SQL Scripts & Samples Tips » Database Forum » Slideshows Free Newsletters: Database Journal | DBA Support | SQLCourse | SQLCourse2 Advertiser Disclosure Database Management & Programming News, Articles & Tutorials for Database Administrators Featured Database Articles The New SQL Server Approximate Count Distinct Function 02/03/2020 With the introduction of SQL Server 2019, Microsoft introduced a new method to count distinct values that can be faster and uses less resources. Read on to learn more! Understanding Query Execution in Relational Database System Architecture 01/27/2020 What happens behind the scene in a modern relational database management system when a user submits a query until the result is obtained from the database? Read on to learn more! Running Database Console Commands (DBCCs) on Azure SQL Database 01/20/2020 Discover the primary characteristics of Database Console Commands (DBCCs) on Azure SQL Database and explore their role in Database-as-a-Service scenarios. Using Oracle EXPAND_SQL_TEXT 01/13/2020 Database tables are not static entities and sometimes changes can wreak havoc on packages and procedures. Read on to see how Oracle's expand_sql_text can help solve such issues. Suspending and Resuming Transparent Data Encryption (TDE) 01/08/2020 Running Transparent Data Encryption (TDE) in the SQL Server database engine asynchronously might take a while to encrypt the entire database. Read on to learn how to suspend and resume TDE to keep your system performant. Creating a Data-centric Mobile App 01/03/2020 See step-by-step how to create a data-centric mobile app using common tools including SQLite and C#. To learn about these tools and how to create a simple mobile app, read on! Overview of Azure SQL Database Serverless 12/30/2019 Azure SQL Database allows for stateful services in the cloud. Read on to learn about the characteristics and use cases of the Azure SQL Database serverless tier. Monitoring Table Change in Oracle 12/23/2019 Learn of possible scenarios to monitor changes when replicating Oracle. Read on to discover the best course of action for moving forward! A Quick Look at SQL Server Numeric Functions 12/19/2019 If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions Hands-on SQL in PostgreSQL 12/16/2019 Learn how SQL commands are typically entered using the PostgreSQL interactive terminal - psql. Get hands-on information for using SQL to deal with CRUD, viewing data, and more by using some of the basic SQL commands in PostgreSQL. Database Tips DBA Videos -- Latest Forum Threads More... Reverse Engineering via tracing combine two Access Jet SQL queries into one for experts about operations to data access in ER diagram constraint for replacing primary key Has My ERD/ERM Achieved 3NF? [IMAGE ATTACHED] Recent Headlines Oracle Using Oracle EXPAND_SQL_TEXT 01/13 Monitoring Table Change in Oracle 12/23 A Quick Look at SQL Server Numeric Functions 12/19 more... MS SQL The New SQL Server Approximate Count Distinct Function 02/03 Running Database Console Commands (DBCCs) on Azure SQL Database 01/20 Suspending and Resuming Transparent Data Encryption (TDE) 01/08 more... MS Access more... DB2 IBM Db2 for z/OS Useful Features 08/19 Doing Analytics Against Critical Production Data 07/29 Polling and Survey Data Transparency 07/01 more... Acceptable Use Policy Terms of Service | Licensing & Reprints | About Us | Privacy Notice | Contact Us | Advertise | Sitemap | California - Do Not Sell My Info Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace....