PolyBase is a new feature of SQL Server that allows you to connect to relational and non-relational data. You can run queries on any external data sources you might have, such as Oracle, PostgreSQL, Salesforce, MongoDB, Hadoop, etc. When paired with the CData ODBC Driver for PostgreSQL, you get access to your PostgreSQL data directly […]
Trying to keep up with technology is a losing game. Better to continue to grow and learn, balanced with the rest of your life.
When you execute a query, the database server has to figure a lot of things out. For even the simplest queries, there are usually several possible ways to get the job done.
In addition to trying to get better at SQL Server, Redgate Software, and all the various aspects of my job, I'm also trying to get better at this whole human interaction thing AND I'm working on trying to learn PostgreSQL much more deeply. Whew! Yeah, may not seem like a whole lot, but I assure […]
As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables. This is especially true with logging tables. Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]
Using a list to keep track of what you should work on is only as good as the plan or goal behind it.
This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well as exponential moving averages with different period lengths.
BMW have been monitoring their SQL Server estate for more than 7 years, but with evolving technology and circumstances, monitoring also needs to change and grow. Join Tony Maddonna in conversation with Redgate's James King, to discover how BMW are handling the challenges.
In this first article of the Stairway to SQL Server on Linux, learn how to set up your host server.
GE is using lots of data, and machine learning to predict when specific systems will fail by nurturing digital twins.
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, all! I have an existing always on availability group on-prem and last week...
Hi Result is determined by the calculated Usage, With the below query, the result...
Hi all, I'm still pretty new to SQL and could use some help getting...
Ask SSC