Optimize for ad hoc VS single use plans
Yesterday’s post talked about single use plans. The statements I’m using are also called ad hoc queries. The alternative to...
2019-02-20
310 reads
Blog Posts
Proposed SQL Server defaults: disable lightweight pooling
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
341 reads
Query Store Central Repository – Part 1
I’ve worked for SaaS companies for the last 6 years or so. So our queries are largely the same across...
2019-02-20
193 reads
SQL in the City 2019 in London
We’ve started setting up our SQL in the City Summits for 2019 and the first one is London on April...
2019-02-20
773 reads
Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you...
2019-02-20
186 reads
Using Power BI To Track My Activities
As a MS MVP one of the things you have to do is keep track of all the “things” you do for community, whether it be volunteering, organizing, speaking,...
2019-02-20
7 reads
Why do I (they) own that database?
Ever looked at the list of databases and wonder why you own one of them? Or why some other user...
2019-02-20
136 reads
7 more ways to Query Always on Availability groups
Post Updated: Replaced Query 3 with transactions/sec query.
When we first published 7 ways to Query Always On Availability Groups using...
2019-02-19
347 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of...
2019-02-19
805 reads
Azure Data Lake Store Gen2 is GA
Azure Data Lake Store (ADLS) Gen2 was made generally available on February 7th. In short, ADLS Gen2 is the best of the previous version of ADLS (now called ADLS Gen1)...
2019-02-19
105 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers