I haven’t done it much the past few years, but I would answer some programming questions posted in forums back in the day. In the late 90s, I answered Visual Basic questions and eventually switched to SQL Server questions here on SQL Server Central as my career progressed. Answering questions not only assisted someone else, […]
In 2021, many companies had employees leave positions. The number of people resigning from their jobs was so high that the term "The Great Resignation" began appearing in many publications. A number of industries were affected, and there are no shortage of pundits and experts analyzing why. This happened primarily in the US, but the […]
This short piece shows how to add logging for the Delete activity and track which files or folders are deleted.
A data lake is a scalable data storage repository that can ingest large amounts of raw data and make it available on-demand. Robert Sheldon explains the benefits and challenges of data lakes.
The 2021 report from the DevOps Research and Assessment (DORA) team at Google Cloud has now been published and provides highlights from seven years of research and data from more than 32,000 professionals worldwide.
The next level of the Stairway to Integration Services looks at how you can execute your package.
DevOps is a journey, not a project. Today Steve reminds us that while we want to work across time and constantly improve, we also need some urgency. A marathon is the balance.
Phil Factor offers a programmer's guide to Flyway's configuration settings, explaining the different categories of parameters, the role of each of parameter within each category, and how to exploit Flyway's multi-level configuration file system.
Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.
Video chat is how many of us see our colleagues every week. It's not a great system, but maybe it can get better.
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Comments posted to this topic are about the item Do You Really Need HA?
Comments posted to this topic are about the item The New Database CheckDB
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers