(Bojan Petrovic) We all know that a Null value is a field with no value. The statements that we are running daily will have to deal with Null values, especially when it comes to strings concatenation (adding strings together).
Tag: sql server
Connection timeout and Command timeout in SQL Server
(Don Castelino) While working with SQL Server, one of the common issue application teams report is timeouts. In this article, we are covering connection and Command timeouts and ways to isolate them.
An Overview of Data Science for Stock Price Analysis with SQL: Part 1
(Rick Dobson) Please provide an overview of data science focusing on time series data, such as for product sales or stock prices. I want the overview to be relatively broad and consider conceptual topics, but the overview should also tie back to prior tips with practical examples so that I can get a
Invoking M Functions In Parallel Using List.ParallelInvoke()
(Chris Webb) I was looking at the list of M functions supported in custom connectors and not in Power BI Desktop (using the technique I blogged about here) in the latest version of the Power Query SDK when I came across an intriguing new function: List.ParallelInvoke().
Overview of In-Memory Technologies of Azure SQL Database
(Marcin Policht) Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling.
Accidentally deleted an Azure SQL DB?
(blobeater) Okay honestly I have done this once. I have deleted Azure SQL Databases and then try and find the quickest way to recover.
Estimated Plans and Forced Plans from Query Store
(Grant Fritchey) While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a plan from the cache or from query store. Or is there?
Always Encrypted with Secure Enclaves – Try It Now in SQL Server 2019 Preview!
(Jakub Szymaszek) Last year, we revealed our efforts to bring confidential computing capabilities of Always Encrypted to the next level, by leveraging secure enclave technologies.
SQL Server 2019 preview brings Hadoop, Spark and AI into DBMS
(Jack Vaughan) A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure Cosmos DB also gets an update.
We Need RDMA for Availability Groups and in All Public Clouds
(Allan Hirt) Yesterday was a big day between all of the Windows Server 2019, Azure, and SQL Server 2019 announcements. Others have covered things like new features at a broad glance (here’s the official list from Microsoft).
