Going Cloud Native
Lots of organizations are moving to the cloud, but having different levels of success. This change can be powerful and create tremendous opportunity, but it can also be a disappointment.
How to Enable and Disable Full Text Search for SQL Server Databases
Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup.
Troy Hunt talks Security and compliance in estate monitoring
Troy Hunt joins Steve Jones to discuss the critical and complex role of monitoring in organizational data security and compliance.
Connect to PostgreSQL as an External Data Source using PolyBase
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 […]
Growing and Keeping Up
Trying to keep up with technology is a losing game. Better to continue to grow and learn, balanced with the rest of your life.
What Is a Cost-Based Optimizer?
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.
Learning Is Challenging, So, Forgive Yourself
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 […]
To-do list: good, bad or indifferent?
Using a list to keep track of what you should work on is only as good as the plan or goal behind it.
Model and Log Trend Reversals for Time Series Data in SQL Server
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.
Monitoring Large Estates at BMW
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.
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers