When a Service Pack or Cumulative Update Install Fails by Evaporating
Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.
How Much Memory is “Normal” for SQL Servers?
When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.
Write more compact SQL Server code using new features
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
Adding Disks - Level 3 of the Stairway to SQL Server on Linux
In this level we examine how to add disks to separate our data, log, and tempdb files.
Lax Security is Harmful for Employment
Data breaches do more than harm an organization. There's a human cost.
Transferring Data with JSON in SQL Server
JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.
Overview of Azure SQL Database Information Protection
Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime examples of this trend. Microsoft delivers relevant features by leveraging several different security-related Azure services. In this article, we will provide an overview of this functionality.
Cost estimation for SQL Server Azure VMs
This article provides pricing guidance for SQL Server virtual machines in Azure.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
BCA KCU Menara Bidakara Telp:0821-8200-233
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers