(James Serra) I discover a small new feature the other day, but a very useful one. Previously, there was no way to upload files to an ADLS Gen2 storage account via the Azure portal.
Tag: sql server
How to Attach a SQL Server Database without a Transaction Log and with Open Transactions
(Daniel Farina) You want to attach a SQL Server database that does not have the transaction log file and you get the following error when you try to attach the data file:
Why SQL Server Doesn’t Give the Memory Back to OS?
(Pinal Dave) The purpose of this post is to show you what SQL Server is storing in memory and to discuss why SQL doesn’t give the memory back to the OS.
Statistical Parameter Estimation Examples in SQL Server and R
(Nai Biao Zhou) Because of physical constraints, economical constraints, time constraints or other constraints, it is usually impractical to gather information from every unit within a population to determine the characteristics of the population.
Data-Driven Apps
(Maria Colgan) At the moment, we hear a lot about how businesses need to become data-driven to remain competitive, how business need to understand their customer’s needs and quickly deliver value to those customers.
SQL SERVER – How to Order By a Parameter?
(Pinal Dave) There are no stupid questions or smart questions, they are all information. Recently while working with a huge telecommunication organization on Comprehensive Database Performance Health Check, we figured out that one of the stored procedures is taking too long to run for a client.
Fundamentals of table expressions, Part 4 – Derived tables, optimization considerations, continued
(Itzik Ben-Gan) This article is the fourth part in a series on table expressions. In Part 1 and Part 2 I covered the conceptual treatment of derived tables.
Azure Monitor and Azure SQL Database
(blobeater) This is all about enabling diagnostics telemetry for Azure SQL databases. For Azure SQL Database there are quite a few options to select from. Below shows the diagnostic settings available.
Create Custom SSIS Execution Log – Part 2
(Haroon Ashraf) As a Data Warehouse or SQL Server BI (Business Intelligence) Developer, how I can make sure that my SQL Server Integration Services (SSIS) Packages use Azure UTC time to log events rather than my local system time while my packages are built locally, but run against Azure SQL Databas
End an ALTER DATABASE immediately if anyone is in the database.
(Kenneth Fisher) The development team has told me they’ve shut down the application, there are no more connections and I can go ahead and set the database to SINGLE_USER, or maybe RESTRICTED_USER before running various processes on it. I check and low and behold, no connections.