The Curse of Cursor Options
Books Online says the FAST_FORWARD option has "performance optimizations enabled," but they didn't say if they were good. It turns out they're not.
2018-11-30
3,017 reads
Additional Articles
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
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
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers