DevOps is a very popular approach for running and managing development projects. But it shouldn't be restricted to only development projects. Databases have lots of code as well, from triggers to functions to stored procedures, and these too should be managed under the umbrella of DevOps. Back in July of 2023, I wrote about this idea in greater detail at DBTA.com. Click the link to read more. Here's a brief snippet of the article: Data is the cornerstone of the modern digital business. IT teams, database professionals, and business leaders use data to make informed decisions, … [Read more...]
The Top Six Benefits of Database DevOps for Streamlined and Stronger Database Operations
June 18, 2024 by Leave a Comment
Building Modern Data Pipelines Using DBT
June 11, 2024 by Leave a Comment
Back in May 2024, I had the opportunity to write a guest column for Database Trends and Applications Magazine, a publication I once where I once wrote a monthly column on Microsoft SQL Server and Azure SQL for many years. I thought I'd take a moment to bring it to your attention. I'd love to hear your feedback! Cheers, -Kevin Earlier this year, I had the privilege of serving on the organizing committee for the DataTune conference in my hometown of Nashville, Tenn. Unlike many database-specific or platform-specific conferences, which tend to focus on analytics and data science, … [Read more...]
Buy Generic Cialis online
September 21, 2017 by Leave a Comment
Buy Cialis Online Tadalafil is indicated for the treatment of erectile dysfunction. Tadacip works by helping to increase blood flow into the penis during sexual stimulation. Generic Cialis helps you to achieve and maintain an erection. Tadacip from Cipla is used to treat erection problems in men. It is the only drug which works in 30 minutes, but is also know to be effective for as long as 24 hours. This enabling you to choose the moment that is just right for you as well as your partner. Thousands of men have benefited from Tadacip 20mg, moderate or severe Erectile Dysfunction. We sell … [Read more...]
How Can the SQL Server Resource Governor Help You?
February 10, 2017 by Leave a Comment
MANAGING ‘NOISY NEIGHBORS’ IN SQL SERVER If you've been managing databases for any length of time, you've probably had to contend with the "noisy neighbors" scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don't share the resources of the server nicely. To deal with this issue, you might want to investigate Resource Governor as an alternative. READ MORE... Originally Posted in DBTA Magazine in June 09, 2015 … [Read more...]
Learn More About the SQL Server Cardinality Estimator
January 27, 2017 by Leave a Comment
COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relational engine predicts for the number of rows affected … [Read more...]
The Top 10 Mistakes Made by SQL Server DBAs
August 10, 2015 by Leave a Comment
THE TOP 10 MISTAKES MADE BY SQL SERVER DBAS The SQL Server world has its own set of challenges when it comes to database administration. One of the biggest challenges is that there are never enough skilled DBAs. Consequently, many people who are not true DBAs are pressed into service, perhaps a Windows SysAdmin or the lead developer on an application using a SQL Server back end, so-called "accidental DBAs." That means that people doing DBA work on SQL Server frequently do not know the fundamental technical details or the processes and practices commonly used by experienced enterprise DBAs. … [Read more...]
