Meeting Preparation for SQL Server Projects
Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.
2018-11-29
2,515 reads
Additional Articles
SQL Server on Amazon Web Services (AWS)
Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazon Web Services (AWS).
2018-11-28
2,382 reads
SQL Server Auditing for HIPAA and SOX – Part 4
Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.
2018-11-27
2,290 reads
Monitoring Azure Health Status Using Azure Portal - Part 1
In this tip we look at how you can monitor Azure health to know if there are any issues that may interupt your services running on Azure.
2018-11-26
1,932 reads
How Check Constraints MIGHT Improve Your Queries and Missing Index Requests
In theory, you get better execution plans when SQL Server understands the contents of your tables. In practice, well, it's hit or miss.
2018-11-23
3,977 reads
Creating Calculated Columns Using DAX
In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.
2018-11-22
2,396 reads
Executing Integration Services Packages in the Azure-SSIS Integration Runtime
n this tip we will explain how you can deploy, execute and schedule SSIS packages in the Azure cloud.
2018-11-21
1,712 reads
Installing SQL Server 2019 CTP 2.0
Greg Larsen offers detailed instructions on how to install SQL Server 2019 CTP 2.0.
2018-11-20
2,371 reads
What Is SQLPSX?
SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior demonstrates several useful commands and shows you how to create a SQL Agent job using this library to run daily DBA checks.
2018-11-19
3,347 reads
Batch Mode For Row Store: What Does It Help With?
Considering SQL Server 2019? Erik tells you what kinds of queries will get the biggest performance improvements.
2018-11-16
2,401 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers