Remove articles sql-server-from-zero-to-advanced-level
article thumbnail

Enterprise Cloud Security Strategy For 2024

Scalegrid

This article delivers direct insights on solid security frameworks, agile defensive tactics, and compliance adherence, providing the blueprint to reinforce your enterprise against the rigors of the cloud. As more and more enterprises incorporate cloud-based systems, ensuring their security becomes a key concern.

Strategy 130
article thumbnail

Common SQL Server Mishaps

SQL Performance

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. DBCC CHECKDB. Statistics.

Servers 49
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only.

Servers 40
article thumbnail

SQL Server Mysteries: The Case of the Not 100% RESTORE…

SQL Server According to Bob

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. Here is the script I used to restore that backup I downloaded from github. OK, this is very cool. 10 percent processed.

Servers 40
article thumbnail

SQL Server Mysteries: The Case of the Not 100% RESTORE…

SQL Server According to Bob

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. Here is the script I used to restore that backup I downloaded from github. OK, this is very cool. 10 percent processed.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This White Paper is for informational purposes only.

Servers 40
article thumbnail

Using SQL Server’s SNITrace to Troubleshoot Networking Issues

SQL Server According to Bob

Using SQL Server’s SNITrace to Troubleshoot Networking Issues In the process of tracking down a few TCP 10054 issues (highlighted here: ​​ [link] ) I ​​ also ​​ used ​​ the ​​ SNITrace ​​ (SNI Trace) ​​ capabilities.

Network 40