Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:
2023-12-01
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:
2023-12-01
In this article, we look at how using the Tablock hint in SQL Server could impact concurrency and block other sessions.
2023-11-29
Updating and deleting documents, creating queries, and managing query results in Microsoft's new NoSQL database-as-a-service.
2023-11-29
Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining.
2023-11-27
November approaches again. For Europeans, that is a month like any other, for Americans, November means: Black Friday, with huge discounts!
2023-11-24
Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
2023-11-24
Coding for the new NoSQL JSON database service that supports SQL queries.
2023-11-22
When people start learning a new field, for example T-SQL, it’s tempting to spend very little time trying to understand the fundamentals of the field so that you can quickly get to the advanced parts.
2023-11-22
How do other architects solve the common problems they encounter when tasked with implementing a major new business initiative? We asked 9 of your fellow IT architects to tell us how they approach the most common challenges.
2023-11-20
In this article, we look at using Microsoft Fabric to build a data warehouse and some things you should know about doing this.
2023-11-20
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers