Fun with Outer Joins
Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.
How to Post Performance Problems
How do you get help? You can post a question on SQLServerCentral, but to get the most help you can, read this article from MVP Gail Shaw.
Picking Your Packaging
Today we have a guest editorial from Andy Warren that asks you how you choose the tools you use to solve a problem.
Creating a DBA's Library
A DBA Library: it's not the library in traditional terms where you have books and journals stacked on your desk; rather it's a centralized and integrated repository of knowledge, information and applications for the DBA.
Learn SQL Server in Arabic
A series of videos on SQL Server have been produced in Arabic. Learn about SQL Server in another language.
Step Up, Don’t Step Back
We have a guest editorial today from Chris Shaw, on the need to take chances in your life.
SQL Server 2014 Backup Basics
There is nothing mysterious about SQL Server backups. They are essential, however you use your databases. Grant Fritchey explains the basics of database backups and restores with SQL Server 2014.
We're not craftsmen and craftswomen
We don't always do the job we would want done for us. We don't pride ourselves as craftspeople do. At least that's what Steve Jones thinks.
SQL Server 2014 Memory Optimization Advisor
The new SQL Server 2014 “Memory Optimization Advisor” tool helps you quickly analyze tables to see how easy it is to migrate them to In-Memory OLTP tables. Read on to learn more.
Double Checks
Many of us have checks in place on systems or processes, but would we be aware of tampering with the operation of our computer systems? Steve Jones notes that auditing can be important to ensure things are working well.
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers