As we were closing out 2023, I wrote the article Observability: The Central Watchtower for Your All-Seeing IT Needs for DevOps.com. I've enclosed the first few paragraphs below, but I'd love for you to read the entire article and provide your feedback and thoughts. Enjoy! -Kevin If there’s something you need to keep secure, it’s natural to want to keep it sealed away under lock and key. However, even keeping something in a vault, far from prying eyes and ill intent, may not be enough to offer peace of mind. After all, how can you have the peace of mind of knowing it’s safe if you don’t … [Read more...]
The Top Six Benefits of Database DevOps for Streamlined and Stronger Database Operations
June 18, 2024 by Leave a Comment
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...]
SQL Server 2016 – The Cool is in the Tool (SSMS That is)
November 28, 2017 by Leave a Comment
SQL SERVER 2016 – THE COOL IS IN THE TOOL (SSMS THAT IS) As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS). While SSMS is an outstanding administration and T-SQL programming tool, it does have its minor qualms and quibbles. READ MORE... Originally Posted September 02, 2016 … [Read more...]
SQL Server on Linux – It’s No Joke
November 14, 2017 by Leave a Comment
SQL SERVER ON LINUX – IT’S NO JOKE Many thought it was an early April Fool's Day prank, but it was no joke: On March 7, 2016, Microsoft announced the beta release of SQL Server on Linux with the intention of shipping a full release of the product in 2017. READ MORE... Originally Posted May 04, 2016 … [Read more...]
Powerful ETL Technologies in the Microsoft Data Platform
October 31, 2017 by Leave a Comment
POWERFUL ETL TECHNOLOGIES IN THE MICROSOFT DATA PLATFORM Microsoft first truly disrupted the ETL marketplace with the introduction of SQL Server Integration Services (SSIS) back with the release of SQL Server 2005. Microsoft has upped the ante yet again by bringing to market powerful ETL features to the cloud via the Azure Data Factory, which enables IT shops to integrate a multitude of data sources, both on-premises and in the cloud, via a workflow (called a "pipeline) that utilizes Hive, Pig, and customized C# programs. READ MORE... Originally Posted March 03, 2016 … [Read more...]
Surprising but True: the Basics are Still Difficult
October 20, 2017 by Leave a Comment
SURPRISING BUT TRUE: THE BASICS ARE STILL DIFFICULT I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report which you should read is "SQL Server Transformation: Toward Agility & Resiliency 2017; PASS Database Management Survey." READ MORE... Originally Posted April 07, 2017 … [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...]
New Releases for the Microsoft Data Platform
September 18, 2017 by Leave a Comment
NEW RELEASES FOR THE MICROSOFT DATA PLATFORM The Microsoft data platform team is on fire! It is delivering more updates and features faster and more thoroughly than ever before. If you're a data professional and you're using the Microsoft stack, this is a really exciting time to be involved. Here's a look at the top new capabilities in SQL Server 2016 Public Preview, SSIS Feature Packs For Azure, and Azure SQL Data Warehouse. READ MORE... Originally Posted July 08, 2015 … [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...]
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...]
