Thank a Mentor
There is almost always someone that helps us in our career with mentorship. Today Steve suggests you thank them.
How LAG compares to other techniques
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
PostgreSQL Date And Time Part 2
In the second part of this PostgreSQL date time series, we examine a number of commonly used functions for getting current dates and times and converting strings to dates and times.
To Inifinity and Beyond With 1=1
There is some code that might work, but could lead others astray in the future. Today Steve notes that we ought to write code that sets a good example, and a loop that potentially runs forever isn't that type of code.
Use SQLAlchemy ORMs to Access MongoDB Data in Python
The wide ecosystem of Python modules enables you get to work fast and effectively integrate your systems. You can use the CData Python Connector for MongoDB and the SQLAlchemy toolkit to build MongoDB-connected Python applications and scripts. This article details how to use SQLAlchemy to connect to MongoDB data to query, update, delete, and insert MongoDB data. Connecting to MongoDB Data Connecting to MongoDB data is similar to connecting to any other relational database. Create a […]
Real-Time Streaming using Power BI Streaming Dataset
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.
What's the real story behind the explosive growth of data?
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.
Author Power BI Reports on Real-Time ServiceNow Data
This article shows in detail how to use the Power BI Connector to create real-time visualizations of ServiceNow data in Microsoft Power BI Desktop.
Azure SQL Migrations using Azure Data Studio
This article looks at database migration with the Azure Data Studio extension, making it easy to move databases from an on premises SQL Server to one in Azure.
Poor Work Management
The future of work is uncertain, but not everyone is ready for remote work to continue.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers