SQL Server Diagnostic Memory Queries
Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server.
2021-10-04
Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server.
2021-10-04
This article demonstrates how to get started with using Auto Loader cloudFiles with Databricks through an end-to-end practical example of ingesting a data stream which has an evolving schema.
2021-10-01
Get Gartner’s latest DevOps and Agile recommendations for I&O leaders.Redgate is named as a sample vendor for Continuous Compliance Automation in the 2021 Hype Cycle™ for Agile and DevOps
2021-10-01
Get Gartner’s latest DevOps and Agile recommendations for I&O leaders. Redgate is named as a sample vendor for Continuous Compliance Automation in the 2021 Hype Cycle™ for Agile and DevOps.
2021-09-29
295 reads
Learn how to plot a financial time series using SQL Server data and Python to reveal the value of exponential moving averages and make decisions about time series values.
2021-09-29
In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.
2021-09-27
The very definition of open-source software means that developers can change the code, which means that exclusive, paid, licensing is not a part of the deal. In short, open-source is free. Free of licensing anyway. So, why might you choose to pay for an open-source software like Flyway? Grant Fritchey explores.
2021-09-27
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
2021-09-24
In this tip we will look at using a Streaming Dataset in Power BI to visualize real time data using the streaming service Azure Stream Analytics job.
2021-09-22
IDC’s recent Global DataSphere Forecast, 2021-2025 predicts that global data creation and replication will experience a compound annual growth rate of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it? Read this blog to explore these important questions.
2021-09-22
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers