Featured Database Articles
Have you ever wondered, especially in the case of a data warehousing scenario, why the transaction log file grows bigger and bigger--sometimes much bigger than your database's data files? What caused it to happen? How do you control it? How does the recovery model of a database control the growing size of the transaction log? Read on to learn the answers.
Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.
If you are a DBA you probably are responsible for running and monitoring all of the SQL Server Agent jobs on one or more SQL Server instances. Read on to learn some automated approaches of monitoring SQL Server agent jobs.
You're running processes in parallel; is it really faster? Sometimes it may not be; read on to see why parallel processing may be creating more work than you'd expect.
Week numbering schemes are interesting and getting the starting date based on that number is even more so. Read on to see what schemes there are and if you can, indeed, get the starting date you expect.
Large Oracle instances running on Linux can benefit from using hugepages. Read on to see what hugepages are and how they help Oracle run better.
Big data applications do not need the same infrastructure support teams as do more common applications. As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.
Technical support teams usually support familiar hardware and software configurations. Specialization in particular combinations of operating systems and database management software is common, and this allows some team members to gain in-depth experience that is extremely valuable in an enterprise IT setting. How has big data changed this paradigm?
Big data applications are here to stay. The promise of this technology is the ability to quickly and easily analyze large amounts of data and derive from that analysis changes to customer-facing systems. Management believes that the analysis and subsequent changes will drive up customer satisfaction, market share and profits, hopefully at a reasonable cost.