-
Joey on SQL Server
Microsoft's Asad Khan breaks down some details on the recently announced feature.
06/27/2022
-
News
Microsoft this week noted that its SQL Server 2022 public preview, made available late last month, can now be tried on some Linux distros.
06/03/2022
-
Joey on SQL Server
It's time. Make your life a lot easier by automating those time-intensive tasks.
06/03/2022
-
Joey on SQL Server
Build 2022 marks the long-awaited public preview of Microsoft's next-generation database engine. Here are the top seven new SQL Server 2022 features to look out for.
05/24/2022
-
News
The Microsoft Information Protection (MIP) service now works with SQL Server data, and can be applied using SQL Server Management Studio (SSMS), according to a Monday Microsoft announcement.
04/18/2022
-
News
SQL Server 2022 is nearing a public preview release, Microsoft announced on Monday.
04/12/2022
-
Joey on SQL Server
Here's how Microsoft can make data migration easier on us.
03/25/2022
-
News
Microsoft announced late last month that it'll be ending support for two SQL Server capabilities, with cloud services and SQL Server 2022 typically proposed as replacements.
03/09/2022
-
Joey on SQL Server
Getting a bird's eye view can help to quickly spot trouble areas.
02/23/2022
-
Joey on SQL Server
Let's break down when it's ideal to use the NOLOCK hint and when you should never use it.
01/21/2022
-
News
Microsoft on Tuesday announced the "general availability" (GA) commercial release of the Flexible Server deployment option for the Azure Database for PostgreSQL service.
11/30/2021
-
Joey on SQL Server
The next major version of Microsoft's flagship database engine is now in private preview. Here's what you need to know about it.
11/02/2021
-
Joey on SQL Server
Time to hit the basics and dive into how theSQL Server database engine works.
10/28/2021
-
Joey on SQL Server
Here's how to fix that performance database query to speed up response time.
09/28/2021
-
News
Microsoft recently described Eclipse Data Connector (EDC) progress, along with its efforts to align cross-organizational data-sharing needs with Europe-based privacy and security laws.
09/22/2021
-
Some SQL Server features are good, some are great -- and some are great only in the right situations and in the right hands. Learn how to spot the difference.
09/22/2021
-
News
According to a five-year study by California-based security firm Imperva Inc., 46 percent of all global on-premises databases have existing flaws that can be leveraged by outside attackers.
09/15/2021
-
A Microsoft data platform MVP on the state of SQL Server today -- how it's evolved in Microsoft's Azure-first word, the best features to emerge in recent years and troubleshooting gotchas.
09/14/2021
-
News
Microsoft warned thousands of Azure Cosmos DB users last week that their data may have been exposed through a recently discovered security flaw in Jupyter Notebook.
08/30/2021
-
Joey on SQL Server
As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives.
08/25/2021
-
Joey on SQL Server
As of July 13, SQL Server 2016 no longer has mainstream support. Your next steps as a DBA include understanding Microsoft's support model, knowing the risks of upgrading and then biting the upgrade bullet.
07/20/2021
-
News
Microsoft plans to release a "General Purpose" version of its Azure Arc-enabled SQL Managed Instance (MI) at the "general availability" (GA) commercial-release stage, "starting July 30, 2021."
06/30/2021
-
Joey on SQL Server
Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.
06/15/2021
-
Joey on SQL Server
Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things to keep in mind to make backup and recovery as smooth as possible.
05/19/2021
-
News
Microsoft has commercially released its Data Loss Prevention Alerts Dashboard, which is used for viewing data loss prevention (DLP) policy violations in organizations, per a Monday announcement.
04/13/2021