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.
Migrate the SSIS Catalog in Just a Few Clicks
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
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 […]
How to Delete Large Amounts of Data
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 […]
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.
Blogs
Join me next week at my first GroupBy session
2021 has been the year people want to learn about Temporal Tables, it seems....
Daily Coping 20 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Updated Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress
My updated course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available...
Forums
Please help with grouping totals and details
I am trying to get the same layout going in ssrs as in the...
Replace apostrophe in user input field
I have an Access front end with SQL backend. The user input field is...
DATEDIFF with GETWEEK worth of data
I have such an issue. I have units, on sale date and also how...
Ask SSC